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

[cluenek <cluenek@yahoo.com>]

I'm pretty sure it's not used in a following query. 
It does get passed into a c function down the road. If
I change $home_price_date output to
$home_price_date_test, there is no problem.  Man this
is strange.

Thanks again for the assistance.

--- "Knapp, Richard" <KnappR@umsystem.edu> wrote:
> 
> Is the null field used as a key in the next query
> down the line?
> 
> 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 cluenek
> Sent: Friday, February 27, 2004 3:59 PM
> To: sqr-users@sqrug.org
> Subject: Re: [sqr-users] Error: Buffer overflow
> converting characters
> from client into server's character set.
> 
> 
> 
> 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
> 
> _______________________________________________
> 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