My Oracle Support Banner

[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 (Doc ID 2644257.1)

Last updated on APRIL 17, 2023

Applies to:

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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