JR36170: READING LARGE XMLTYPE VALUES FAILS WHEN RUNTIME COLUMN PROPAGATI ON IS USED

Download Fix Pack 2 for InfoSphere Information Server Version 8.1

APAR status

• Closed as program error.

Error description

• Oracle Connector and DB2 Connector are used to replicate data
  from Oracle 10 DB to DB2 9.5 DB.
  User implemented a generic job with RCP but have a problem with
  tables with Oracle XMLTYPE columns.
  
  The error message is :
  
  ORA_READ_Table,0: [IIS-CONN-ORA-001003] The OCI function
  
  OCIStmtFetch
  returned status -1. Error code: 19.011, Error message:
  
  ORA-19011:
  Character string buffer too small. (CC_OraStatement::fetch,
  file
  CC_OraStatement.cpp, line 1.009)
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  DataStage users who are using Oracle Connector stage in their
  jobs
  ****************************************************************
  PROBLEM DESCRIPTION:
  Oracle Connector is configured to read data from a table that
  contains a column of XMLTYPE data type. Some of the values in
  this column are larger than 4000 bytes. The output link of the
  Oracle Connector stage does not contain any columns and the
  stage is configured to use Runtime Column Propagation. The job
  fails with the Oracle error: ORA-19011: Character string buffer
  too small.
  
  ****************************************************************
  RECOMMENDATION:
  Install the patch (JR36170).
  ****************************************************************
  

Problem conclusion

• The code for generating SELECT statement was updated. Instead of
  generating the generic "SELECT * FROM table_name" statement,
  the connector provides the select list of columns that are
  defined in the table and specifies this list instead of the *
  wildcard. For any XMLTYPE column, rather than including the
  column name in the select list, the connector includes the
  XMLTYPE.GETCLOBVAL() or XMLTYPE.GETBLOBVAL() function call for
  that column, depending on the XML storage type that was
  specified in the XMLTYPE column definition. This in turn allows
  for fetching values from that column that are larger than 4000
  bytes.
  

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

• R810 PSN

     UP