error on Oracle connector stage

chulett · Post by **chulett** » Tue Jul 24, 2012 7:29 am

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

ravipuli · Post by **ravipuli** » Tue Jul 24, 2012 8:05 am

I have increased ,but still error is going on

chulett · Post by **chulett** » Tue Jul 24, 2012 8:58 am

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".

ykhan · Post by **ykhan** » Wed Jul 25, 2012 9:17 am

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)

ykhan · Post by **ykhan** » Wed Jul 25, 2012 9:27 am

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.

ykhan · Post by **ykhan** » Thu Jul 26, 2012 8:38 am

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