JR63155: SUBSCRIPTION FAILS AFTER "UNEXPECTED HISTORY ACTION TRANSITION ALTER_TABLE TO DROP_PARTITION"

APAR status

• Closed as program error.

Error description

• When ALTER TABLE DROP PARTITION operation is issued, log reader
  may fail after "Unexpected history action transition
  ALTER_TABLE to DROP_PARTITION" error
  

Local fix

• NA
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue may affect you if you are using IDR CDC           *
  * 11.4.0.3-5576 or earlier for Oracle, where CDC Oracle is a   *
  * source datastore and tables you are replicating are modified *
  * with ALTER TABLE DROP or MOVE PARTITION.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * ALTER TABLE MOVE PARTITION statements were not being handled *
  * properly, and mirroring would end on error.                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR 11.4.0.3-5582 for Oracle.                     *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.3-5582 for Oracle 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