ogg-00869 oracle---pgsql

Oracle GoldenGate - Version 12.2.0.2.2 to 12.2.0.2.2 [Release 12.2]
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补丁)

ogg-00869 oracle---pgsql

上一篇:K8S PDB和taint同时存在


下一篇:Screw数据库文档生成神器