OGG Replicat Abends Even With HANDLECOLLISIONS Set For PostgreSQL Target
(Doc ID 2253046.1)
Last updated on DECEMBER 27, 2023
Applies to:
Oracle GoldenGate - Version 12.2.0.1.0 to 12.2.0.1.0 [Release 12.2]Information in this document applies to any platform.
Symptoms
Using GG version 12.2.0.1.0 for PostgreSQL, the following error occurs when trying to insert a record that is exist already. HANDLECOLLISIONS param does not prevent the abend.
2017-03-08 18:09:17 WARNING OGG-01004 Aborted grouped transaction on '<table_name>', Database error 680 ([SQL error 680 (0x2a8)][Oracle][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]No backend error text returned).
2017-03-08 18:09:17 WARNING OGG-01003 Repositioning to rba 1528692 in seqno 0.
2017-03-08 18:09:17 WARNING OGG-01154 SQL error 680 mapping <source_table> to <target_table> [SQL error 680 (0x2a8)][Oracle][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]No backend error text returned.
2017-03-08 18:09:17 ERROR OGG-01296 Error mapping from <source_table> to <target_table>
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 |