My Oracle Support Banner

Db2 z/OS - After upgrade- Failed to get next timestamp value for EXTRACT xxx (Invalid type (19) retrieving timestamp (Doc ID 2853781.1)

Last updated on SEPTEMBER 20, 2022

Applies to:

Oracle GoldenGate - Version 19.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

When trying to upgrade from ogg v19.1.0.0.4 to 21.3.0.0.0.
The checkpoint files for the extract is corrupted and show

GGSCI() 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
Failed to get next timestamp value for EXTRACT <Extname> (Invalid type (19)
retrieving timestamp in <OGG_HOME>/dirchk/<Extname>.cpe.).
Failed to get next timestamp value for EXTRACT <Extname> (Invalid type (19)
retrieving timestamp in <OGG_HOME>/dirchk/<Extname>.cpe.).
Failed to get next timestamp value for EXTRACT <Extname> (Invalid type (19)
retrieving timestamp in <OGG_HOME>/dirchk/<Extname>.cpe.).
Failed to get next timestamp value for EXTRACT <Extname> (Invalid type (19)
retrieving timestamp in <OGG_HOME>/dirchk/<Extname>.cpe.).
Failed to get next timestamp value for EXTRACT <Extname> (Invalid type (19)
retrieving timestamp in <OGG_HOME>/dirchk/<Extname>.cpe.).
--

Tried to revert back to 19.1.0.0.4 and that also gives the same error

When Tried to start the extract, it failed with
--

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.