OGG Replicat on PostgreSQL Abends with Mapping problem with compressed update record Error - ODBC PostgreSQL Wire Protocol driver (Doc ID 2297570.1)

Last updated on AUGUST 29, 2017

Applies to:

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

Symptoms

OGG Replicat abends with below error in Discard file:


----------------------------------------------------------------------------------------------------------
[SQL error 0 (0x0)][Oracle][ODBC PostgreSQL Wire Protocol driver]Timestamp parameters with a scale, must have a scale
 less than ten and a precision equal to 20 plus the scale. You specified a precision of 6 and scale of 6. Error in
parameter 3.


-- Example of Replicat mapping 
MAP epm_sc.c_cons, TARGET alterlog.test_c_cons_log, KEYCOLS (cons_id), INSERTALLRECORDS, OVERRIDEDUPS, COLMAP (usedefaults, target_write_time = @datenow(), source_change_time = @datenow(), deal_flag="00", dml_flag=@GETENV("GGHEADER","OPTYPE"), before_after=@GETENV("GGHEADER", "BEFOREAFTERINDICATOR"), trans_id=@GETENV ("TRANSACTION", "XID"));


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms