linux定时任务执行sqlldr失败,GoldenGate OGG ORA-01403 SQL ERROR 1403

OGG  oracle goldengate 1403错误解决方法

1. 错误描述

WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, repyxb.prm: SQL error 1403 mapping SGPM.P_SMS_SEND to SGPM.P_SMS_SEND.

WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, repyxb.prm:  Repositioning to rba 2509817 in seqno 1.

ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, repyxb.prm:  Error mapping from SGPM.P_SMS_SEND to SGPM.P_SMS_SEND.

ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, repyxb.prm:  PROCESS ABENDING.

2. 错误原因和分析

SQL ERROR 1403属数据错误，指记录无法投递到目标数据库，需通过查看错误信息及discarded文件，到两端库寻找相应记录，并结合logdump工具分析队列中的实际数据，分析出现该错误的原因，进而解决该问题。

造成该错误的可能原因：

两端表结构不一致

附加日志错误

初始化方法错误导致不一致

<