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 number
JR64110
Reported component name
IS CDC ORACLE
Reported component ID
5725E30OR
Reported release
B40
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-08-27
Closed date
2021-09-28
Last modified date
2021-09-28
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
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTRGZ","label":"InfoSphere Data Replication"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.4"}]
Document Information
Modified date:
29 September 2021