Re: [sqr-users] SQL Error = ORA-01406: fetched column value was truncated

[Ray Ontko <rayo@ontko.com>]

Sheetal,

The only adjustable parameter for SQR that I can think
of that might be related to this error message 
is LONGSPACE=32766 in your -M or SQR.INI file.

What's going on in that particular SQL statement? 
Are any of the columns "LONG" or "LONGRAW"?

Ray

On Fri, Oct 17, 2003 at 09:08:49AM +0530, sheetalk wrote:
> Hi All,
> 
> My working environment :  ps 8 sp2,  pt 8.15, oracle db
> 
> I'm getting this error msg when i run one sqr only on production thr
> process scheduler both on nt and unix..
> On all other instances it works fine..
> Surprisingly enough it runs fine on production from dos prompt with sqrw
> command !!!
> 
> I tried to trace if any particular data value causes this but i don't
> get this error for particular data row..but it occurs mostly when
> report data is large...
> 
> SQL Status =    -1, SQL Error  = ORA-01406: fetched column value was
> truncated
> Error on line 59:
>    (SQR 3301) Program stopped by user request.
> 
> Which  options for sqr or oracle or process scheduler on production
> should i check?
> I've already compared pssqr.unx files on all instances and they are
> same...
> 
> Please help !!!!!
> 
> Thanks & Regards,
> Sheetal.
> 
> *********************************************************
> Disclaimer
> 
> This message (including any attachments) contains 
> confidential information intended for a specific 
> individual and purpose, and is protected by law. 
> If you are not the intended recipient, you should 
> delete this message and are hereby notified that 
> any disclosure, copying, or distribution of this
> message, or the taking of any action based on it, 
> is strictly prohibited.
> 
> *********************************************************
> Visit us at http://www.mahindrabt.com
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
----------------------------------------------------------------------
Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/

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