My Oracle Support Banner

Replicat truncate the data with this WARNING OGG-03014 if SQLEXEC is being used. (Doc ID 2797931.1)

Last updated on SEPTEMBER 23, 2021

Applies to:

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

Symptoms

Replicat is unable to handle particular column value while executing procedure via SQLEXEC().

It generates lot of warning messages and it occupy more server storage in dirrpt and /var/ mount point too.

It is a regression bug from 11.2.1.0.33. Because replicat was working fine with 11.2.1.0.1 version for the same set of data.

 

Error :
===
2021-07-03 06:44:36 WARNING OGG-03014 Oracle GoldenGate Delivery for Oracle, <repname>.prm: WARNING: Source column <COLUMN_NAME> has more
characters than target column <COLUMN_NAME> can hold.

Changes

As per this bug 16941997  and following documentation , it is expected behavior.
https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/gg_parameters156.htm
https://docs.oracle.com/en/middleware/goldengate/core/19.1/reference/reference-oracle-goldengate.pdf 

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.