issue on replicate tables via goldenGate
edited Apr 29, 2013 2:50AM in GoldenGate, Streams and Distributed Database (MOSC) 7 commentsAnswered
Hello Team,
We are trying to set up extract/replicate process from our prod to dev env for reporting purpose. While setting up we are facing issue for one table (INT_CAMPAIGN_DETAILS) showing more row count on target box.
There is no error coming in logs but we are getting one warning for that table like below:
2013-04-25 09:48:56 WARNING OGG-01396 Oracle GoldenGate Delivery for Oracle, rep1.prm: A complete after image is not available in INSEG.INT_CAMPAIGN_DETAILS at rba 87888315 in file /ora1/oracle/software/goldengate/dirdat/rt000409, while inserting a row into APPROD04FEED.INT_CAMPAIGN_DETAILS due to missing target row for a key update operation. NOCOMPRESSUPDATES or FETCHOPTIONS FETCHPKUPDATECOLS may be specified in the EXTRACT parameter file to include a complete image for key update operations.
We are trying to set up extract/replicate process from our prod to dev env for reporting purpose. While setting up we are facing issue for one table (INT_CAMPAIGN_DETAILS) showing more row count on target box.
There is no error coming in logs but we are getting one warning for that table like below:
2013-04-25 09:48:56 WARNING OGG-01396 Oracle GoldenGate Delivery for Oracle, rep1.prm: A complete after image is not available in INSEG.INT_CAMPAIGN_DETAILS at rba 87888315 in file /ora1/oracle/software/goldengate/dirdat/rt000409, while inserting a row into APPROD04FEED.INT_CAMPAIGN_DETAILS due to missing target row for a key update operation. NOCOMPRESSUPDATES or FETCHOPTIONS FETCHPKUPDATECOLS may be specified in the EXTRACT parameter file to include a complete image for key update operations.
0