Robert, Appears like you might have some corruption in your ARS meta data.. Go into SQL Developer. Describe T570, and check the lengths of each of those selected columns reports.
Then open up your Developer Studio or Admin Client whatever you use, and check the lengths there.. Check for any discrepancies.. correct them if any. Also before correcting that, you may want to run a select max(Cn) from T570 for each of those columns to check what is the max length of data in each of those columns to give you an idea of what your column sizes should be.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Martin, Robert Sent: Wednesday, February 17, 2010 4:15 PM To: [email protected] Subject: ORA-01406: fetched column value was truncated ** Dear List, We have a form that we have been using for years, but when I try to do a unqualified search I get ": ORA-01406: fetched column value was truncated." The sql log shows the same message, but no indication of what is causing it. The sql log selection statement is: SELECT * FROM ( SELECT T570.C1,C2,C561000257,C561000214,C8 FROM T570 ORDER BY 1 ASC ) WHERE ROWNUM <= 2147483648. I can paste this statement into SQL Developer, and it runs with no problem. I can open individual entries with no problem, but somewhere there must be a problem entry. How can I track it down? (ARS 7.1 p3, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
