GoldenGate SQL error 1403 mapping error Solution

Fault symptom:

15:45:29WARNING OGG-01004Oracle GoldenGate Delivery for Oracle, rora_001.prm:Aborted grouped transaction on 'realestate. JZWFCMS ', Database error 1403 ().
15:45:29WARNING OGG-01003Oracle GoldenGate Delivery for Oracle, rora_001.prm:Repositioning to rba 8825466 in seqno 34.
15:45:29WARNING OGG-01154Oracle GoldenGate Delivery for Oracle, rora_001.prm:SQL error 1403 mapping REALESTATE. JZWFCMS to REALESTATE. JZWFCMS.
15:45:29WARNING OGG-01003Oracle GoldenGate Delivery for Oracle, rora_001.prm:Repositioning to rba 9293635 in seqno 34.
15:45:29ERROR OGG-01296Oracle GoldenGate Delivery for Oracle, rora_001.prm:Error mapping from REALESTATE. JZWFCMS to REALESTATE. JZWFCMS.
15:45:29ERROR OGG-01668Oracle GoldenGate Delivery for Oracle, rora_001.prm:Process abending.

Problem Analysis:

This problem occurs generally because the synchronization source and target table structures are inconsistent, including table fields and indexes.

In addition to the table structure, data inconsistency may also lead to mapping errors. For example, the gg database cannot find the data when the original database is to be deleted or updated. for specific reasons, see the error number in the report:

Database error 1403

 Oerr ora 1403.
01403,000 00, "no data found"
// * Cause:
// * Action:

Troubleshooting:

1) if the table fields are inconsistent, You need to modify the table fields. In heterogeneous databases, you also need to regenerate the table structure definition file and restart the process.

2) If the index is inconsistent, you need to re-create the index. heterogeneous databases also need to re-generate the table structure definition file and restart the process. (Check whether the index is the same before. Check the index later)

3) in this case, you cannot compare the table structures at both ends (the SQL statements that may modify the table structure are executed later), but you should first find out the cause. In case of data problems, you can skip the synchronization of the table and then re-Synchronize the table.