JR62595: CDC CAN THROW NULLPOINTEREXCEPTION WHEN TRYING TO RETRIEVE ROWID FOR LOB COLUMN OF THE TABLE

APAR status

• Closed as program error.

Error description

• IBM InfoSphere Data Replication will be shutdown due to an
  error while parsing logs for table XXXXXX.XXXXXX at position
  918465992011.1.3.155313.80.1.0. The table definition may have
  changed. Please update the table definition and refresh this
  table. The issue can also be resolved by parking the table and
  restarting the subscription. And the trace file would show
  NullPointerException like following:
  Line 54280:
  65959669	2020-07-21 18:20:35.727	SHAREDSCRAPE LOG PARSER:DECODER
  {564}	com.datamirror.ts.scrapers.oraclescraper.redo.parserunit.D
  mlUnitDecoder	unexpectedOperation()	Unexpected Error for:
  Table: XXXXXX.XXXXXX Operation: U CurrentTimeStamp:
  1595367985000 ObjectId: 187538 DataId: 187538 Multiblock:
  [RawData@918783792159.2.23.2433345.364.1.0: [null rawHead;;
  Impl:null impl;null undoKdoInfo;null redoKdoInfo;null
  kdoSuppInfo], RawData@918783792231.2.1.2433596.300.1.0:
  [RawHead: [OhmJrnRawDataStruct: Header: msgType: 44461 r: true
  JrnHeader: OhmJrnHdrStruct:
  logPos:918783792231.2.1.2433596.300.1.0 undoDba:17533824
  Object_ID: 187538 Data_ID: 187538 Object_Type: 2 IOT: 0
  DmlAction: true oraFileVersion: 201326592;OIDPart:
  [opFamily:11,undoType:0]];; Impl:TableData;KDOChangeHeader: [kdo
  Op:5,rowFb:44,tabn:0,numCols:4,rowidFileBlockNumber:118132072,ro
  widRow:0];KDOChangeHeader: [kdoOp:5,rowFb:0,tabn:0,numCols:4,row
  idFileBlockNumber:118132072,rowidRow:0];KDOSupplementaryHeader:
  [sqlOp:1,supRowFb:92,n...
  2:39
  65959660	2020-07-21
  18:20:35.727	SHAREDSCRAPE LOG PARSER:DECODER{564}	com.datamirror
  .ts.scrapers.oraclescraper.redo.parserunit.DmlUnitDecoder	execut
  e()	?ava.lang.NullPointerException | at com.datamirror.ts.scrape
  rs.oraclescraper.redo.logicallog.RawDmlWithUndo.getRowId(RawDmlW
  ithUndo.java:1358)| at com.datamirror.ts.scrapers.oraclescraper.
  redo.parserunit.MultiEntryDmlUnit.getRowId(MultiEntryDmlUnit.jav
  a:1060)| at com.datamirror.ts.scrapers.oraclescraper.redo.parser
  unit.DmlUnitDecoder.parseDmlOperation(DmlUnitDecoder.java:614)|
  at com.datamirror.ts.scrapers.oraclescraper.redo.parserunit.DmlU
  nitDecoder.parseDmlOperation(DmlUnitDecoder.java:580)| at com.da
  tamirror.ts.scrapers.oraclescraper.redo.parserunit.DmlUnitDecode
  
  r.parseDmlOperationAndIncrementCounter(DmlUnitDecoder.java:466)|
  at com.datamirror.ts.scrapers.oraclescraper.redo.parserunit.DmlU
  nitDecoder.execute(DmlUnitDecoder.java:285)| at com.datamirror.t
  s.scrapers.oraclescraper.redo.parserunit.DmlUnitDecoder$DecoderP
  ipelineJob.execute(DmlUnitDecoder.java:89)| at com.datamirror.ts
  .engine.component.PipelineThread.runThread(PipelineThread.java:2
  17)| at com.datamirror.ts.util.TsThread.run(TsThread.java:130)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue may affect you if you are using IDR 11.4.0.2-5564 *
  * or older for Oracle.                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Replication ends on error.                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.3-5566 or newer for Oracle 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