Replicat truncate the data with this WARNING OGG-03014 if SQLEXEC is being used.
(Doc ID 2797931.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle GoldenGate - Version 11.2.1.0.33 and laterInformation 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 |