JR31292: OCI PLUGIN PROBLEM READING MORE THAN 1 CLOB IN A TABLE. IT EFFEC TS VIEW DATAAND OUTPUT.

Download Fix Pack 2 for InfoSphere Information Server Version 8.1

APAR status

• Closed as program error.

Error description

• This problem effects when the Oracle plugin is trying to get
  more than one clob out of a table,
  thus it effects "View Data" and Output. The Input function is
  working correctly.
  The problem is that several variables need to be reset when
  there is more than 1 CLOB in a table.
  

Local fix

• This fix is included in 8.0.1 fix pack 3
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Server jobs containing Oracle OCI stage using Oracle table that
  contains more than 1 CLOB.
  ****************************************************************
  PROBLEM DESCRIPTION:
  When a Server Job contains an Oracle OCI Output stage and/or
  theuser clicks on the "View Data"  button on either
      stage and the table contains more than 1 CLOB, the data in
  the  in garbage. Even if the Oracle table      does not have
  garbage in the 2 - # CLOBs, then "View Data"      button will
  return that they do contain garbage. The Oracle     output
  function will change valid data in the 2 - # CLOBS to  invalid
  data to be returned. The data in the table will not be changed.
  ****************************************************************
  RECOMMENDATION:
  Apply patch JR31292.
  This change is included in 8.1 Fix Pack 1.
  ****************************************************************
  

Problem conclusion

• When each CLOB is received from the Oracle table, all of the
  variables are reset before processing the CLOB. Previously,
  several variables were not reset when a CLOB was received.
  Thereis no change that the customer is required to make other
  than   the patch installation.
  

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:

Modules/Macros

• SERVER
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R801 PSY

     UP

• R810 PSY

     UP