Dear List, We have an “IT:Resource” form. I can search for individual entries and display them, but if I do an unqualified search I get:
ARERR [552] Failure during SQL operation to the database : ARERR [552] Failure during SQL operation to the database : ORA-01406: fetched column value was truncated I looked up both “552” and “ORA-01406” in the Support Knowledge Base, but didn’t find anything that seemed to fit my situation. I figured that there must be a bad record somewhere. In trying to track it down I found that if I search for: 'Resource ID' LIKE "ITRS4%" I get the error. Ergo the Resource ID starts with "ITRS4.” (Resource ID is the renamed Request ID, C1) But if I search for 'Resource ID' LIKE "ITRS4" the record displays. Records also appear when I search for 'Resource ID' LIKE "ITRS40%" or 'Resource ID' LIKE "ITRS41%"” all the way to 'Resource ID' LIKE "ITRS49%" So I’ve now eliminated all possibilities. Maybe it isn’t a bad record causing the problem. Any suggestions on tracking this down? (ARS 7.1, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University
