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

[cluenek <cluenek@yahoo.com>]

I should also mention, that the equivilant output
variable of the stored procedure is declared as a
datetime, while $home_price_date is a string.  I still
don't think this should matter.


--- cluenek <cluenek@yahoo.com> wrote:
> 
> 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


__________________________________
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