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

[cluenek <cluenek@yahoo.com>]

Wouldn't I get an array error?  Also, I don't have
this problem running the exact same code with sqr 3. 
Could it be something with the sqr.ini file?  Grabbing
at straws here.

--- Kent Schaetzly <KSchaetzly@eprod.com> wrote:
> 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
> 
=== 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