JR61380: "ARITHMETICEXCEPTION DIVIDE BY 0" IS THROWN WHEN ONLY DERIVED COLUMN ARE SET FOR REPLICATION

APAR status

• Closed as program error.

Error description

• When only Derived Columns are selected for replication, CDC
  wrongly calculates the row size during initial refresh. As a
  result, the following exception is thrown:
  
  Source Data Channel (9824)
  com.datamirror.ts.util.TsExceptionHandler
  processUnhandledException() An uncaught exception has occurred:
  Java.lang.ArithmeticException divide by zero| at
  com.datamirror.ts.source.tablereader.TableReader.calculateFetchS
  ize(TableReader.java:344)| at
  com.datamirror.ts.source.tablereader.TableReader.queryData(Table
  Reader.java:316)| at
  com.datamirror.ts.source.tablereader.TableReader.beginTableRead(
  TableReader.java:177)| at
  com.datamirror.ts.source.tablereader.TableReader.beginTableRead(
  TableReader.java:119)| at
  com.datamirror.ts.source.replication.TableRefresher.refreshTable
  (TableRefresher.java:331)| at
  com.datamirror.ts.source.replication.MirrorComponent.doRefresh(M
  irrorComponent.java:391)| at
  com.datamirror.ts.source.replication.MirrorComponent.refreshTabl
  eSetForMirrorRefresh(MirrorComponent.java:3318)| at
  com.datamirror.ts.source.replication.MirrorComponent.evaluateRul
  esAndRefresh(MirrorComponent.java:1961)| at
  com.datamirror.ts.source.replication.MirrorComponent.startReplic
  ation(MirrorComponent.java:2994)| at
  com.datamirror.ts.source.replication.MirrorComponent.moderateFor
  TheSource(MirrorComponent.java:472)| at
  com.datamirror.ts.source.replication.ModeratorBase$SourceDataCha
  nnelJob.execute(ModeratorBase.java:495)| at
  com.datamirror.ts.engine.component.PipelineThread.runThread(Pipe
  lineThread.java:217)| at
  com.datamirror.ts.util.TsThread.run(TsThread.java:130)
  

Local fix

• The two workarounds include:
  
  1) Instead of using Derived Columns to modify base column
  names, this can be done in the KCOP (for CDC for Kafka targets)
  
  2) Select at least one base column from the source table to
  replicate. This will bypass the error
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue affects you if you have table mappings where no   *
  * table columns are mapped; only derived columns are mapped.   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * An error is returned for table mappings that only have       *
  * derived columns selected for replication.                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR 11.4.0.2-5503 or newer for all LUW engines.   *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.2-5503 or newer for all LUW engines
  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 DATA REPLICA

• Fixed component ID

  5725E3000

Applicable component levels

• RB40 PSY

     UP