My Oracle Support Banner

Extract Pump generates incorrect trail record with 'OUTPUTFORMAT TEXT' parameter for negative numbers (Doc ID 2800519.1)

Last updated on SEPTEMBER 09, 2021

Applies to:

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

Symptoms

Extract Pump generates incorrect trail record with 'OUTPUTFORMAT TEXT' parameter for negative numbers.


Sample Extract Pump parameter file:
extract <Pump name>
OUTPUTFORMAT TEXT NAMES, OP, IND, DELIMITER '|', TS, _NOTRANSTMTS, _FILE, NOQUOTE
RMTHOST <IP Address>, mgrport < port no>
RMTRAIL <path>/pc
TABLE <schema>.<Tablename>;


When extract is running with OUTPUTFORMAT, column of type NUMBER(precision), having data with negative values of type is showing wrong values.
So insert statement like:
INSERT INTO <schema>.<Tablename>(ColA,ColB) VALUES ('TEST','-5');


Here ColB column is of NUMBER(6)
The incorrect output shown in text trail file was:
I|A|<Tablename>|2021-06-24:02:10:44.000000|<ColA>|TEST|<ColB>|18446744073709551611

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.