JR65239: IIDR ORACLE XSTREAM MIRRORING ENDS ON PARSING EXCEPTION WHEN TABLE INCLUDES INVISIBLE COLUMNS.

APAR status

• Closed as program error.

Error description

• InfoSphere Data Replication for Oracle XStream does not
  correctly identify Invisible columns as Hidden to exclude them
  from being expected for mirroring.  This would result in errors
  in the parser when matching the expected columns and mirroring
  ending with an exception :
  
  Failed to process a logical change record (LCR) for table
  <Schema.Table>, LCR type INSERT at LCR position <Pos#> .|Failed
  processing image type AFTER.|Failed to find a column definition
  for column name <INVISCOL> in <Column List>.
  
  The corrected behavior will be to hide and ignore columns
  defined as  INVISIBLE for both Refresh and Mirroring activity.
  

Local fix

• Use of the  IIDR instance parameter
  mirror_on_ddl_operation=IGNORE can be used to avoid the parsing
  error until this fix can be applied,  but this also has
  implications to when IIDR should stop for actual DDL changes
  that happen on the tables in mirroring.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue might affect you if you are using IDR             *
  * 11.4.0.4-5666 or older for Oracle - XStream.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Not available                                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR 11.4.0.4-5670 or newer for Oracle - XStream.  *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.4-5670 or newer for Oracle - XStream
  resolves the issue
  

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

  IS CDC ORACLE

• Fixed component ID

  5725E30OR

Applicable component levels