OGGBD Replicats Fail After Upgrade To 21.6 With TaskEngine_4 FlushTask Id Null Location Missing required fields And Some Replicated Columns Get Null Values (Doc ID 2896507.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Replicat is abended with below errors after upgrading from 21.4 to OGG BIGDATA 21.6:

=ERROR 2022-08-19 07:28:10.000773 [TaskEngine_4(FlushTask)] - id: null location: message: Missing required fields: Msg_0_CLOUD_QUERY_TABLE.event_timestamp, Msg_0_CLOUD_QUERY_TABLE.process_timestamp. reason: invalid

=ERROR 2022-08-19 07:28:10.000798 [TaskEngine_4(FlushTask)] - Error executing flush for table [ TTFGLD495].

And also COLMAP is not working.

We could have incorrect null values as well when using colmap

For ex:
COLMAP (USEDEFAULTS, TESTDATE = @DATE('YYYYMMDDHH','JTS',@GETENV ('JULIANTIMESTAMP')));

The associated column in target Hana is

"TESTDATE ","SECONDDATE","19","YES","n/a"

The test data shows null when using 21.6 and it was fine when using 21.4:

OGGBIGDATA 21.6:
----------------
hdbsql=> select TESTPK,TESTDATE from <SCHEMA>.<TABLE_NAME> where TESTPK=0;
TESTPK,TESTDATE
0,?

OGGBIGDATA 21.4:
----------------
hdbsql=> select TESTPK,TESTDATE from <SCHEMA>.<TABLE_NAME> where TESTPK=0;
0,"2022-08-09 14:34:38"

Changes

 OGGBD upgrade from 21.4 to 21.6 OGGBIGDATA version.

Cause

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