Linux x86-64
SYMPTOMS
Repicat to Postgres abends with
2019-11-08 21:43:10 WARNING OGG-00869 Oracle GoldenGate Delivery, <replicat>.prm: [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 6.
2019-11-08 21:43:10 ERROR OGG-01296 Oracle GoldenGate Delivery, <replicat>.prm: Error mapping from <DB_NAME>.<USER>.<TABLE> to <USER>.<TABLE>.
CAUSE
Issue affects TIMESTAMP W/ TIMEZONE and TIMESTAMP W/O TIMEZONE columns if they are defined with explicit
precision. i.e., TIMESTAMP(p) and TIMESTAMP(p) with TIME ZONE columns.
OGG PostgreSQL Replicat Abends With [SQL error 0 (0x0)] And Timestamp Is Getting Truncated At The 6th Character (Doc ID 2436847.1)
SOLUTION
Fixed in
Patch 26943661: Patch for BLR 26812342: Linux x86-64: PostgreSQL: OGG 12.2.0.2.2 (OGG补丁)