This content has been marked as final. Show 4 replies
It simply means that the record GG wanted to update doesn't exist in the target database.
Post your replicat param file. Not sure whether you are using a discard file or not. If not, then include a discard file in the replicat param file and the replicat will dump all the details of the record it failed to update in the discard file. Then you should be able to investigate it further.
The problem lies with the SQL you are doing, SQL ERROR 1403 is ROW NOT FOUND. As you were told, the SQL statement is trying to update a record that does not exist
Check the records which you have on target AND source, make sure they match
Once they do, stop the replicat on the target and to:
ALTER <REPNAME> BEGIN NOW
Then issue the update statement on the source database. You will see it works.