JR64110: IDR FAILS WITH NUMERIC OVERFLOW EXCEPTION WHEN TRYING TO EXTRACT INDEX DETAILS ON 19C.

APAR status

• Closed as program error.

Error description

• Table mapping creation may fail due to the following error
  message :
  
  Agent Reader{2674} com.datamirror.ts.eventlog.EventLogger
  logActualEvent() Event logged: ID=9604 MSG=The following message
  was sent to the Management Console. Failed to retrieve the table
  structure for table
  CDCTEST.CUST.?com.datamirror.ts.jdbcagent.message.AgentException
  Failed to retrieve the table structure for table CDCTEST.CUST.|
  at com.datamirror.ts.jdbcagent.messagehandler.generated.MsgAddT
  ablesHandler.handleMessage(MsgAddTablesHandler.java:120)|at com.
  geHandlerFactory.handleMessage(TsMessageHandlerFactory.java:670
  )|at com.datamirror.ts.jdbcagent.messagehandler.AgentMessageHand
  er.handleMessage(AgentMessageHandler.java:172)|at com.datamirror
  sageReader.java:212)|at com.datamirror.ts.util.TsThread.run(TsTh
  by: com.datamirror.ts.customertable.TableCaptureException Failed
  to retrieve the table structure for table CDCTEST.CUST.| at com
  .datamirror.ts.customertable.oracle.redo.OracleRedoTableMetadat
  aFactory.queryTableStructure(OracleRedoTableMetadataFactory.jav
  a:326)|at com.datamirror.ts.customertable.oracle.redo.OracleRedo
  etadataFactory.queryTableStructure(OracleRedoTableMetadataFacto
  ry.java:75)|at com.datamirror.ts.customertable.TableMetadataFact
  bleStructure(TableMetadataFactory.java:137)|at com.datamirror.ts
  bleStructure(TableMetadataFactory.java:156)|at com.datamirror.ts
  ablesHandler.addTableColumns(MsgAddTablesHandler.java:308)|at co
  ablesHandler.addTable(MsgAddTablesHandler.java:256)|at com.datam
  ablesHandler.handleMessage(MsgAddTablesHandler.java:107)|at com.
  geHandlerFactory.handleMessage(TsMessageHandlerFactory.java:670
  )|at com.datamirror.ts.jdbcagent.messagehandler.AgentMessageHand
  er.handleMessage(AgentMessageHandler.java:172)|at com.datamirror
  sageReader.java:212)|at com.datamirror.ts.util.TsThread.run(TsTh
  by: com.datamirror.ts.util.EnvironmentUserException 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.| at ...
  
  The value for FLAGS column of the table index from sys.ind$ view
  is over the MAX_INT cause this issue.
  

Local fix

• Can try dropping this index and re-create it. Oracle may create
  a new index with flags value less than max_int, however it can
  not be assured.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue may affect you if you are using IDR 11.4.0.4-5603 *
  * or older for Oracle (redolog) with Oracle 19c.               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Table mapping creation may fail with the error described.    *
  * The value for FLAGS column of the table index from sys.ind$  *
  * views was larger than expected for 19c.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR 11.4.0.4-5607 or newer for Oracle (redolog).  *
  ****************************************************************
  

Problem conclusion

•  Upgrading to IDR 11.4.0.4-5607 or newer for Oracle (redolog)
  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