报错信息:
view report repsy报错如下:
2022-01-20 14:05:11 WARNING OGG-01154 SQL error 1403 mapping dbo.eoims_skin_test_record
to ODSPDB.SY.EOIMS_SKIN_TEST_RECORD OCI Error ORA-01403: no data found, SQL <UPDATE "SY"."
EOIMS_SKIN_TEST_RECORD" x SET x."PATIENT_ID" = :a1,x."TEST_STATUS" = :a2,x."TEST_RESULT" =
:a3,x."TEST_OPR_CODE" = :a4,x."TEST_OPR_NAME" = :a5,x."TEST_END_TIME" = :a6,x."GMT_MODIFI
ED" = :a7 WHERE x."ID" = :b0>........
ERROR OGG-01296 Error mapping from dbo.eoims_skin_test_record to O
DSPDB.SY.EOIMS_SKIN_TEST_RECORD.
问题原因:
ogg进行增量同步,update时,发现没有该条数据,导致数据丢失报错no data found,无法进行数据同步,则需要抽取全量数据处理
处理步骤:
1、停止ODS端rep进程
2、利用kettle/数据泵/dblink等工具重新抽取eoims_skin_test_record 表的全量数据
2、开启容错
3、启动进程:start repsy
4、待延迟追平后,关闭进程:stop repsy,
关闭容错(注释掉容错参数):edit param repsy
5、开启进程:start repsy
6、info all
7、验证数据即可