Re: [sqr-users] Error: Buffer overflow converting characters from client into server's character set.

[cluenek <cluenek@yahoo.com>]

I've narrowed down the problem I am having.  Basically
the output value of the stored procedure below is
causing the problem.

execute homehost_price_sync #home_price_file,
$home_price_date, $host_price_date, $home_price_date
output

The value getting returned is null, not sure if this
matters, with regards to the subject: error statement.
 If I comment out this procedure the same error occurs
on a different procedure.  Not all stored procedures
are having this problem though.

Any ideas anyone.

Thanks

--- cluenek <cluenek@yahoo.com> wrote:
> Thanks for the response.  Very strange, this error
> occurs in 6.0, but not 3.0.  Is there some kind of
> sqr
> arg that may not be set for my newly installed
> version
> 6.0.  We are not converting to another db
> manufacturer.  Sticking with ase 11.9.3.  Eventually
> we will upgrade to 12.5
> 
> 
> ATTACHMENT part 3.3 message/rfc822 
> Subject: RE: [sqr-users] Error:  Buffer overflow
> converting characters from client into server's
> character set.
> Date: Wed, 25 Feb 2004 16:52:31 -0600
> From: "Knapp, Richard" <KnappR@umsystem.edu>
> To: <sqr-users@sqrug.org>
> 
> I think the error message tells the tale.  You are
> attempting to call a stored procedure at a time when
> the db is processing another command.  Are you also
> converting from one db manufacturer to another?
> 
> Richard Knapp
> Database Programmer/Analyst
> Institutional Research and Planning
> University of Missouri System
> 573-882-8856
> knappr@umsystem.edu
> 
> 
> -----Original Message-----
> From: sqr-users-admin@sqrug.org
> [mailto:sqr-users-admin@sqrug.org]On
> Behalf Of Ken Ulc
> Sent: Wednesday, February 25, 2004 4:37 PM
> To: sqr-users@sqrug.org
> Subject: [sqr-users] Error: Buffer overflow
> converting characters from
> client into server's character set.
> 
> 
> Hello All,
> 
> I'm trying to upgrade from SQR V3.0.7.1 to SQR V6.0.
> 
> Yes, I know it's a big jump, but I'm trying anyway. 
> When I try to run my report, I get the below error
> message and I'm not sure where to begin.  How can I
> tell which sql statement within SQR is having the
> problem?  Where is cursor 75.  Any insite on
> upgrading
> to V6.0 would also be helpful.
> 
> Thanks,
> 
>
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
> 
> (SQR 5528) Sybase CT_RESULTS error in cursor 75:
>    (2404) Buffer overflow converting characters from
> client into server's character set.
> 
> Error on line 65:
>    (SQR 3913) Could not EXECUTE stored procedure.
> 
> SQR: Program Aborting.
> (SQR 5528) Sybase dblogf: ct_send error in cursor 0:
>    (16) ct_command(): user api layer: external
> error:
> This routine cannot be called while results are
> pending for a command that has been sent to the
> server.
> (SQR 5502) Cannot drop SQR generated stored
> procedure: SQR_28787_1077748104.
> 
> 
> 
> __________________________________
> Do you Yahoo!?
> Get better spam protection with Yahoo! Mail.
> http://antispam.yahoo.com/tools
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users


__________________________________
Do you Yahoo!?
Get better spam protection with Yahoo! Mail.
http://antispam.yahoo.com/tools

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users