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 AUGUST 19, 2018

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information 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!

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