My Oracle Support Banner

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 and later
Information in this document applies to any platform.


Oracle GoldenGate Delivery
  Version OGGCORE_12.
  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.


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

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