Replicat applying changes incorrectly in table with extended statistics (Doc ID 2815001.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Replicat is applying data incorrectly on a table with extended statistics enabled.

If extended statistics is disabled in the target table, the replicat will abend with the following error:

ERROR OGG-01161 Bad column index (99) specified for table <SCHEMA_NAME>.<TABLE_NAME>, max columns = 98.

If extended statistics is enabled using the following on the target database:

select dbms_stats.create_extended_stats(ownname => '<SCHEMA_NAME>',tabname =>
'<TABLE_NAME>', extension => '("<COL1>","<COL2>")') from dual;

The replicat will apply the record in the target table and we see the
following message in the report file:

WARNING OGG-02544 Unhandled error (ORA-01840: input
value not long enough for date format) while processing the record at SEQNO
0, RBA 0 in Integrated mode. REPLICAT will retry in Direct mode.

And after that, the value in some of the columns will not match to the corresponding values
on the source.

The customer has the following parameter defined in the GLOBALS parameter file:

NO_USE_TRAILDEFS

and is using ASSUMETRAGETDEFS in the replicat parameter file.

Some additional columns were added to the table in the source after extended statistics was enabled.

Changes

 Database was upgraded to 19c

Cause

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