My Oracle Support Banner

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

Last updated on APRIL 17, 2023

Applies to:

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

Symptoms

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)...
*

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.