GoldenGate Replicat Abended with ORA-01756: quoted string not properly terminated, OGG-01154 SQL error 1756 mapping, ERROR OGG-01296 (Doc ID 1447903.1)

Last updated on JUNE 15, 2017

Applies to:

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

Symptoms


The replicat abends with the below errors seen in the report file.

[2012-04-04 21:52:33 WARNING OGG-01154 SQL error 1756 mapping SOURCE.TEST to SOURCE.TEST ORA-01756: quoted string not properly terminated, SQL INSERT INTO "SOURCE"."TEST" 2012-04-04 21:52:33 WARNING OGG-01003 Repositioning to rba 30707795 in seqno 37 2012-04-04 21:52:33 ERROR OGG-01296 Error mapping from SOURCE.TEST to SOURCE.TEST]

Cause

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 hundreds of Community platforms