My Oracle Support Banner

Goldengate Replication to PostgreSQL 9.6.6 Fails With 'Unknown SQL Error, ODBC Return Code = -1' (Doc ID 2595222.1)

Last updated on OCTOBER 24, 2019

Applies to:

Oracle GoldenGate - Version 12.2.0.2.2 and later
Information in this document applies to any platform.

Symptoms

Goldegate replication fails with Unknown SQL error, ODBC return code = -1.

2019-08-22 11:59:59 WARNING OGG-00869 Oracle GoldenGate Delivery, load.prm: Unknown SQL error, ODBC return code = -1.
2019-08-22 12:13:23 INFO OGG-01971 Oracle GoldenGate Delivery, load.prm: The previous message, 'WARNING OGG-00869', repeated 11 times.
2019-08-22 12:13:23 ERROR OGG-00551 Oracle GoldenGate Delivery, load.prm: Database operation failed: Preparing statement (INSERT INTO "A"."binary_data" ("bin...). ODBC error: SQLSTATE native database error 0. ODBC return code: -1. No additional information available.
2019-08-22 12:13:28 ERROR OGG-01668 Oracle GoldenGate Delivery, load.prm: PROCESS ABENDING.

Changes

 

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
Changes
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.