OGG PostgreSQL Replicat Abends With [SQL error 0 (0x0)] And Timestamp Is Getting Truncated At The 6th Character
(Doc ID 2436847.1)
Last updated on NOVEMBER 21, 2019
Applies to:
Oracle GoldenGate - Version 12.2.0.1.0 and laterInformation in this document applies to any platform.
Symptoms
Oracle GoldenGate Delivery
Version 12.2.0.2.2 OGGCORE_12.2.0.2.0_PLATFORMS_170630.0419
Linux, x64, 64bit (optimized), PostgreSQL on Jun 30 2017 08:20:07
INSERT INTO "omni"."testtable2" ("id","ts1","ts2") VALUES (1,'2018-0','2018-0')
2018-07-26 14:59:49 WARNING OGG-00869 [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 2.
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 |