GG Replicate abended with No data found --1403

user10126973

Hi All,

I have classic extract/replicate for data replication, Once of the replicated abended with no data found issue

when I check report file its trying update a record but the record not found , then I checked in the source with that Id the record exists in the source but not in the target.

I have scan through logdump source and target i did not found insert statement in that trail file, then I did data mine I found insert statement , Somehow GG did not capture insert statement

How to avoid this kind situation ? , Please share your thoughts if you have encountered this issue

My GG version oracle 12.3 and DB version oracle 11.2.4

Regards,

DR

ORASCN

Hello,

If this is the case, then as I mentioned in your previous post, this should be a bug with OGG.

Oracle GoldenGate Extract Missing Single Record Transactions (Doc ID 2414711.1)

Insert Operation Missing During OGG Replication When Source Is RAC With Error ORA-1403 (Doc ID 2290687.1)

Replicat Abends Due To ORA-1403 Error As Record Is Not Captured By Extract (Doc ID 1990385.1)

Like the above one, we have many Bugs related to this issue. It's better to open an SR with Oracle Support and check with them.

Another option which I would suggest is,

Create a dummy extract process and extract the data from that particular archive log and see if that extract captures that INSERT statement.

Regards,

Veera

ORASCN

Hello,

If this is the case, then as I mentioned in your previous post, this should be a bug with OGG.

Oracle GoldenGate Extract Missing Single Record Transactions (Doc ID 2414711.1)

Insert Operation Missing During OGG Replication When Source Is RAC With Error ORA-1403 (Doc ID 2290687.1)

Replicat Abends Due To ORA-1403 Error As Record Is Not Captured By Extract (Doc ID 1990385.1)

Like the above one, we have many Bugs related to this issue. It's better to open an SR with Oracle Support and check with them.

Another option which I would suggest is,

Create a dummy extract process and extract the data from that particular archive log and see if that extract captures that INSERT statement.

Regards,

Veera

user10126973

Yes , thank you all your info

hafeezkalsekar

Hi ,

Please check databse and gg error log and report files for all extract pump and replicate for time when insert was executed .

Please check if force logging is enabled and transactional logging is enabled

Regards ,

Abdul Hafeez Kalsekar