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 JULY 20, 2024

Applies to:

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

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