JR59139: EXCEPTION PERSISTING THE TRANSACTION QUEUE

APAR status

• Closed as program error.

Error description

• Numeric Value out of range excpetion is thrown in persisting
  uncommited transaction Object IDs in pointbase.
  The error is thrown because value of Object Id (long) is
  greater than max value of an integer
  

Local fix

• Delete transaction queue files stored in
  <cdc-install>/<instance_name>/txnstore
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue affects users running IIDR 11.4.0.0-5052 for all  *
  * LUW engines or earlier                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Replication from MSSQL to Netezza                            *
  * Numeric Value out of range exception is thrown in persisting *
  * uncommited transaction Object IDs in pointbase.              *
  *                                                              *
  * Stack:                                                       *
  * SHAREDSCRAPE LOG PARSER{15277}                               *
  * com.datamirror.ts.scrapers.cdc.TxnQueuesSnapShotManager      *
  * takeSnapshotIfNecessary()    Persisting of transaction queue *
  * snapshot # 14 failed due to error:                           *
  * com.datamirror.ts.exception.InternalErrorException:          *
  * Exception persisting the transaction queue                   *
  * DB?com.datamirror.ts.exception.InternalErrorException        *
  * Exception persisting the transaction queue DB|A SQL          *
  * exception has occurred. The SQL error code is '25203'. The   *
  * SQL state is: 22003. The error message is: |Data exception   *
  * -- numeric value out of range. 72057637782880256.|    at     *
  * com.datamirror.ts.scrapers.cdc.TxnQueuesPersistence.persistT *
  * ransQueues(TxnQueuesPersistence.java:385)|    at             *
  * com.datamirror.ts.scrapers.cdc.TransactionQueues.persistTran *
  * sQueues(TransactionQueues.java:3804)|    at                  *
  * com.datamirror.ts.scrapers.cdc.TxnQueuesSnapShotManager.take *
  * SnapshotIfNecessary(TxnQueuesSnapShotManager.java:431)|      *
  * at                                                           *
  * com.datamirror.ts.scrapers.cdc.LogParser.execute(LogParser.j *
  * ava:849)|    at                                              *
  * com.datamirror.ts.scrapers.cdc.LogParser$LogParserPipelineJo *
  * b.execute(LogParser.java:154)|    at                         *
  * com.datamirror.ts.engine.component.PipelineThread.runThread( *
  * PipelineThread.java:217)|    at                              *
  * com.datamirror.ts.util.TsThread.run(TsThread.java:130)|Cause *
  * d by: java.sql.SQLException Data exception -- numeric value  *
  * out of range. 72057637782880256.|    at                      *
  * com.pointbase.dbexcp.dbexcpException.getSQLException(DashoA1 *
  * 0*..:215)|    at                                             *
  * com.pointbase.jdbc.jdbcPreparedStatement.b(DashoA10*..:1824) *
  * |    at                                                      *
  * com.pointbase.jdbc.jdbcPreparedStatement.execute(DashoA10*.. *
  * :343)|    at                                                 *
  * com.datamirror.ts.scrapers.cdc.TxnQueuesPersistence.persistU *
  * ncommittedObjectIdQueues(TxnQueuesPersistence.java:422)|     *
  * at                                                           *
  * com.datamirror.ts.scrapers.cdc.TxnQueuesPersistence.persistT *
  * ransQueues(TxnQueuesPersistence.java:367)|    at             *
  * com.datamirror.ts.scrapers.cdc.TransactionQueues.persistTran *
  * sQueues(TransactionQueues.java:3804)|    at                  *
  * com.datamirror.ts.scrapers.cdc.TxnQueuesSnapShotManager.take *
  * SnapshotIfNecessary(TxnQueuesSnapShotManager.java:431)|      *
  * at                                                           *
  * com.datamirror.ts.scrapers.cdc.LogParser.execute(LogParser.j *
  * ava:849)|    at                                              *
  * com.datamirror.ts.scrapers.cdc.LogParser$LogParserPipelineJo *
  * b.execute(LogParser.java:154)|    at                         *
  * com.datamirror.ts.engine.component.PipelineThread.runThread( *
  * PipelineThread.java:217)|    at                              *
  * com.datamirror.ts.util.TsThread.run(TsThread.java:130)       *
  *                                                              *
  * Cause:                                                       *
  * The error is thrown because value of Object Id (long) is     *
  * greater than max value of an integer                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IIDR 11.3.3.3-74 for all LUW engines or later, OR *
  * 11.4.0.0-5053 for all LUW engines or later                   *
  ****************************************************************
  

Problem conclusion

• Upgrading to IIDR 11.3.3.3-74 for all LUW engines or later, OR
  11.4.0.0-5053 for all LUW engines or later will fix 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 SQL

• Fixed component ID

  5725E30SQ

Applicable component levels

• RB40 PSY

     UP

• RB33 PSY

     UP