Home > ISSUES > WARNING OGG-01154 SQL error 1403 mapping HR.MYTESTTBL to

WARNING OGG-01154 SQL error 1403 mapping HR.MYTESTTBL to

June 17, 2013

Today while doing some RD…I tried to start REPLICATE PROCESS AND PROCESS is going to ABEND state.

I checked the error in the replicat log(view report <REPLICATE PROCESS NAME>) and found the below error.

ERROR:-

2013-06-17 11:00:55 WARNING OGG-01154 SQL error 1403 mapping HR.MYTESTTBL to HR.MYTESTTBL OCI Error ORA-01403: no data found, SQL <DELETE F
ROM “HR”.”MYTESTTBL” WHERE “SRNO” = :b0 AND “NAME” = :b1 AND ROWNUM = 1>.

Cause:-

GG is trying to delete a record which does not exists in the target.

Solution:

alter replicate process to “begin now”

 

alter RHRAMER1 begin now;

 

With above command problem got resolved.  This is completely data issue. there are other options such as a REPERROR or HANDLECOLLISION ETC…so far i have not gone through them….i will cover them later……

Advertisements
Categories: ISSUES
%d bloggers like this: