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

["Kent Schaetzly" <KSchaetzly@eprod.com>]

If you have any arrays in your sqr, check to make sure that you are not 
exceeding your array size by attempting to execute PUT commands beyond the 
limit.  If memory serves me correctly, I have seen this before, and the data 
that exceeded the array seemed to be affecting other variables causing 
additional errors that threw me off the trail.

-----Original Message-----
From: sqr-users-bounces+kschaetzly=eprod.com@sqrug.org
[mailto:sqr-users-bounces+kschaetzly=eprod.com@sqrug.org]On Behalf Of
cluenek
Sent: Monday, March 01, 2004 9:33 AM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: RE: [sqr-users] Error: Buffer overflow converting characters
fromclient into server's character set.



More usefull/useless information:

The string for $home_price_date is passed in as part
of the orcsqr command line arguements.  ocsqr is our
custom sqr to incorporate c calls with the sqr code.

#ifdef home_price_date
    move '{home_price_date}' to $home_price_date
#endif

--- cluenek <cluenek@yahoo.com> wrote:
> 
> You are correct sir.  Although, I don't believe
> initial string is declared.
> 
> 
> --- "Knapp, Richard" <KnappR@umsystem.edu> wrote:
> > 
> > So, let me see if I have the facts straight - if
> you
> > run the stored proc as is, stuffing the output
> into
> > a (declared?) string, it produces the overflow
> > error.  If you put the output of the same proc
> into
> > an (undeclared) string (defined in some default
> > way?), there is no error.
> > 
> > Is this a fair description?
> > 
> > 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 5:09 PM
> > To: sqr-users@sqrug.org
> > Subject: RE: [sqr-users] Error: Buffer overflow
> > converting characters
> > from client into server's character set.
> > 
> > 
> > 
> > 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
> 
=== message truncated ===


__________________________________
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