JR50102: WHILE READING DATA THE ORACLE CONNECTOR RECEIVED ORACLE ERROR ORA-01406 AND FETCHED COLUMN VALUE WAS TRUNCATED WITH NULL

APAR status

• Closed as program error.

Error description

• A column is defined as CHAR(1) in DataStage and CHAR(5)
  inOracle.The contents of the column is 1 regular character
  followed by 4 blanks. That causes Oracle error
  ORA-01406 and fetched column value was truncated with NULL in
  the target
  

Local fix

• Manual modification of the jobs to have same data type length
  in Datastage as in Oracle
  

Problem summary

• This is a big buffer related issue.  Big buffer was a
  performance improvement enhancement of the connectors. When
  Oracle truncates a value during fetch, it returns ORA-01406
  return code, and sets the indicator for the value not to NULL
  (-1) nor to NOT NULL (0) but to either -2 or the length of the
  original value. The connector passes the indicator array (as
  part of the big buffer structure) to the connector framework.
  The connector framework implementation of big buffer checks the
  indicator, and if it is neither NULL nor NOT NULL it assumes it
  is NULL. In this case however it is NOT null it is just
  truncated.
  

Problem conclusion

• Rather than changing connector framework, a fix was made to the
  connector as follows. When the truncation happens, check if
  Oracle has set the indicator to -1 NULL and if not force the
  indicator to 0 NOT NULL. It is a very small change.
  

Temporary fix

• There is work-around, but it is not certified for production.
  Environment variable can be set.
  CC_DISABLE_BIG_BUFFER_API=TRUE activates the pre-v9.1 behavior.
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFO SRVR PLATF

• Fixed component ID

  5724Q3612

Applicable component levels

• R910 PSY

     UP

• R912 PSY

     UP