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

[sheetalk <sheetalk@mahindrabt.com>]

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