Since it is a column value that is truncated, what is the size of the data and the size of the fields you are putting them into? Did someone change the size of a field on either form?
C1,C2,C561000203,C8 Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Tuesday, October 30, 2007 3:05 PM To: [email protected] Subject: ORA-01406 SQL error in Active Link Hello Everyone, I am getting an error in an Active Link that says, "ARERR [552] Failure during SQL operation to the database : ORA-01406: fetched column value was truncated." This happens during a Set Fields operation where it is reading a value from another form. The Set Field is very similar to a dozen others that work, and it was working till just now. I ran an SQL log, and the SQL statement is ":SELECT T570.C1,C2,C561000203,C8 FROM T570 WHERE ((T570.C561000214 != 'PIQ00120') AND (T570.C1 != 'ITRS0003037') AND (T570.C561000257 != 'Cancelled')) ORDER BY 1 DESC" followed by the same error message. But I can paste that very same SQL statement into TOAD, and it brings back a result set. I tried the Support Knowledge base, but the one entry referred to retrieving an attachment and the other to flashboards. Any idea what is going on? (ARS 7.1, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University Dwayne Martin Computing Support James Madison University _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
