ORA-01406 Error when running reports

[rob11nj]

Oracle 9i -> ODBC -> Crystal Reports XI

I'm receiving the following error when running my reports:

Database Connector Error: 'HY000:[Oracle][ODBC][Ora]ORA-01406: fetched column value was truncated [Database Vendor Code: 1406 ]'

I can run the query being used by Crystal (Database->Show SQL Query) just fine using TOAD but the report keeps giving me this error when I attempt to refresh. I would assume that since it states an ORA error code that this is an Oracle problem but then again the fact that I can run the query being used by Crystal seems to negate that assumption?

Any help on this issue would be VERY much appreciated!

 

[synapsevampire]

It's probably a data type problem, try to minimize the columns being returned to isolate it, and then try a CAST against it to a another data type.

One common cause is selecting a timestamp with timezone, and there are others. But you don't post anything technical such as the data types in the SQL, nor the SQL, so it's difficult to assist you.

Otherwise I'd assume that it's a connectivity problem.

You can try switching to using Oracle Native connectivity, it may not resolve this, but it's faster anyway and you should use it instead of ODBC.

You'll find it listed as Oracle Server.

Since it's CR 9, you can select Add Command and paste the SQL in there to use that as a data source, which also might prove enlightening/successful.

-k