JR63733: IDR FOR POSTGRESQL SOURCE FAILS WHEN PARSING TIMESTAMP WITH TIMEZONE COLUMN DATA WITH NO FRACTIONAL SECONDS

APAR status

• Closed as program error.

Error description

• Parser error when no value given for microseconds or timezone,
  only works when all values are present.
  
  Instance trace log :
  com.datamirror.ts.scrapers.postgresqlscraper.PostgreSQLLogParse
  r	parseCommittedTxn()	Failedto parse the number  i. Invalid numb
  format.?com.datamirror.ts.scrapers.cdc.LogParserException Failed
  to parse the number  i. Invalid number format
  
  Event log:
  An exception has occurred in the log parser.
  Unexpected parsing error for table  txid: 1987 currLogPosition:
  00000000/074e0d18 prevLogPosition: 00000000/074e0ce0 operation:
  I object id: 0 journal id: 0 tablename: "public"."t1"
  imageLength: 70 User Name {} Program name {null} Time in
  milliseconds {0} CommitCycleId {-1}   in transaction 1987 at
  position 00000000/074e0ce0.
  Error: The error value is "70:47:26".
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue may affect you if you are using IDR 11.4.0.3-5594 *
  * or older for PostgreSQL source.                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Mirroring fails.                                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR 11.4.0.3-5596 or newer for PostgreSQL source. *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.3-5596 or newer for PostgreSQL source
  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