Forum Stats

  • 3,769,028 Users
  • 2,252,898 Discussions
  • 7,874,843 Comments

Discussions

Oracle GoldenGate Extract Null Values For Primary Key Column

Umut Tekin
Umut Tekin Member Posts: 11 Red Ribbon
edited Feb 11, 2021 10:53PM in GoldenGate On-Premises

Hi,

Goldengate extract process extract null values for primary key column. Due to FORMATASCII parameter in extract, I' am able to read context of trail file.

Here my extract parameter file:

EXTRACT EXTXXX1

TRANLOGOPTIONS ALTARCHIVELOGDEST $arc_path

TRANLOGOPTIONS ALTARCHIVEDLOGFORMAT $arc_pattern.arc

SETENV (ORACLE_SID="ORASID")

SETENV (ORACLE_HOME = "ORA_HOME")

USERID gg, PASSWORD ****************, AES128, ENCRYPTKEY *********

-- Just in case we can't process a record we'll dump info here

DISCARDFILE $GG_HOME/dirrpt/EXTXXX1.dsc, PURGE, MEGABYTES 10

REPORTROLLOVER on sunday

FORMATASCII

EXTTRAIL $GG_HOME/dirdat/ex

TABLE SCHEMA.MY_TABLE;

ddl exclude all


And also, here my trail file context:


V,B,SCHEMA.MY_TABLE,MY_PRIMARY_KEY_COLUMN,NULL,UPDATE_COLUMN,'2020-12-23:13:19:22'

V,A,SCHEMA.MY_TABLE,MY_PRIMARY_KEY_COLUMN,NULL,UPDATE_COLUMN,'2020-12-23:13:19:22'

As you can see, subsequent values after MY_PRIMARY_KEY_COLUMN is null. How can manage them?


Extract is in classic capture mode(Thinking of to upgrade it to integrated capture).

My GoldenGate information:

Oracle GoldenGate Command Interpreter for Oracle

Version 12.3.0.1.4 OGGCORE_12.3.0.1.0_PLATFORMS_180415.0359_FBO


Database version:


Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production 0

PL/SQL Release 12.2.0.1.0 - Production 0


Thanks in advance:)!

Tagged: