JR64560: IDR FAILS WITH EXCEPTION RETRIEVING THE TABLE STRUCTURE IF TABLE OID GOES OUT OF RANGE OF INTEGER

APAR status

• Closed as new function.

Error description

• Exception  main{1}
  com.datamirror.ts.engine.ReplicationExecutive
  initOptionalComponents() Failed to retrieve the table structure
  for table iidrcdc.ts_bookmark.<86>com.datamirror.ts.customertab
  le.TableCaptureExceptionFailed to retrieve the table structure f
  iidrcdc.ts_bookmark.| at com.datamirror.ts.customertable.postgr
  esql.PostgreSQLTableMetadataFactory.queryTableStructure(Postgre
  SQLTableMetadataFactory.java:341)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue might affect you if you use IDR 11.4.0.4-5618 or  *
  * older for PostgreSQL as source                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Instance cannot be used as Source.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR 11.4.0.4-5619 or newer for PostgreSQL.        *
  ****************************************************************
  

Problem conclusion

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

  IDR CDC POSTGRE

• Fixed component ID

  5725E30PS

Applicable component levels