DSXchange

Then increase the size, see if that causes the error to stop.

I have increased ,but still error is going on

You increased it to what? Technically, a NUMBER in Oracle is stored as a Float and can be up to a DECIMAL(38). I've had to specify it as DECIMAL(40) in the past to stop the "truncation".

We have encountered this error and contacted IBM too. We got a patch "patch_JR40722_cc-oracle_linux64_8500-8502" but the issue remained. When we checked with our ORACLE DBA, we were told that they upgraded the oracle server OS from AIX 5.3 to AIX 6.1 and added a DMU patch. We tested our job with simple query "select 'a' from dual" against another db which did not have this DMU patch and the job finished fine. We reported it to IBM but the rep does not think this has anything to do with it. But when I read error it clearly shows "CC_OraConnection::logOracleNlsDatabaseParameters". Do you think NLS_DMU_USAGE could have impacted DS 8.5 fp1?

We also tried trying UTF-8/16/32 but no good. The DS is on Linux SUSE


The OCI function OCIStmtFetch returned status -1. Error code: 1,406, Error message: ORA-01406: fetched column value was truncated. (CC_OraConnection::logOracleNlsDatabaseParameters, file CC_OraConnection.cpp, line 3,635)

We've also tried the same with ODBC stage and it works fine. We suspected the oracle client compatibility issue from Linux to AIX but the SQLPLUS works fine.

Issue resolved. We had to delete "NLS_DMU_USAGE" from v$nls_parameteres. Jobs run fine now