error on Oracle connector stage
Moderators: chulett, rschirm, roy
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 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)