My Oracle Support Banner

ODBC Errors In Target (Postgres) After GoldenGate Upgrade To In Source (IBM ISeries DB2) (Doc ID 2629532.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle GoldenGate - Version to [Release 12.2 to 12.3]
IBM i on POWER Systems


We are receiving errors mapping data from our source DB2 (IBM iSeries/AS400) database to our target PostgreSQL database in AWS. The errors being thrown to the discard file are as follows:
[SQL error 0 (0x0)][Oracle][ODBC PostgreSQL Wire Protocol driver]Datetime field overflow. Error in parameter 47.

Operation failed at seqno 47 rba 39052610
Discarding record on action DISCARD on error 0
Problem replicating EIGR11DAT.BASP0200E to pt_eigr11dat.basp0200e
Mapping problem with compressed update record (target format)...


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.