JR34486: ORA-01406 ERROR IN READING LITERAL BY ORACLE ENTERPRISE STAGE.

Download Fix Pack 2 for InfoSphere Information Server Version 8.1

APAR status

• Closed as program error.

Error description

• After applying patch JR34111_aix_DS752.tar.Z, job extracting
  constant Hangul literal from Oracle fails meeting
  ORA-01406 error.
  
     Item #: 54
     Event ID: 53
     Timestamp: 2009-09-30 11:51:55
     Type: Fatal
     User Name: dsadm
     Message: S_M00,0: (aptoci.C:460). Message: ORA-01406:
  fetched column value was truncated
  
     Item #: 55
     Event ID: 54
     Timestamp: 2009-09-30 11:51:55
     Type: Fatal
     User Name: dsadm
     Message: S_M00,0: The runLocally() of the operator
  failed.
  

Local fix

• This fix is included in 8.0.1 fixpack 3
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Jobs reading multi byte literals in select lists.
  ****************************************************************
  PROBLEM DESCRIPTION:
  Fetching multi-byte literal string  from Oracle fails meeting
  ORA-01406 error.
  Message: ORA-01406:   fetched column value was truncated.
  
  ****************************************************************
  RECOMMENDATION:
  Apply provided patch.
  ****************************************************************
  

Problem conclusion

• If a multi- byte Oracle client is using the server character
  set,  then -use_strings option awards literal with wrong
  schema.
  This results in ORA-01406 error in reading literal by Oracle
  Enterprise stage.
  
  Resolution is to change the conditional so that we enable
  expansion factor on columns/literals whenever byte length and
  code-point length values differ.
  

Temporary fix

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

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R752 PSN

     UP