JR65293: CDC FOR ORACLE XSTREAM TABLE MAPPING FAILED WITH [CDC][ORACLE JDBC DRIVER]NUMERIC OVERFLOW ERROR

APAR status

• Closed as program error.

Error description

• InfoSphere Data Replication for Oracle XStream does not
  successfully map the table mapping
  ending with an exception :
  Event logged: ID=9604 MSG=The following message was sent to the
  Management Console. A SQL exception has occurred. The SQL error
  code is '0'. The SQL state is: HY000. The error message is:
  |[CDC][Oracle JDBC Driver]Numeric
  overflow.com.datamirror.ts.jdbcagent.message.AgentException A
  SQL exception has occurred. The SQL error code is '0'. The SQL
  state is: HY000. The error message is: |[CDC][Oracle JDBC
  Driver]Numeric overflow.
  
  The correct behavior will be to create mapping without error
  

Local fix

• N/A
  

Problem summary

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

Problem conclusion

• Upgrading to IDR 11.4.0.4-5686 or newer for Oracle or 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