ogg常见报错问题处理之no datafound

1、日志信息

ogg目标端复制进程挂起，查看report部分信息如下
ps:部分字段名称或者表名称用***替换，不影响阅读

2023-12-27 10:13:22  INFO    OGG-06511  Using following columns in default map by name: ID, A**OUNT_CODE, M***GAGE_TYPE, M***GAGE_AMOUNT, EXPIRAT***_DATE, REMARK, LE_CODE, 
JV_CODE, C***E_BY, C***E_****, UPDATE_BY, UPDATE_****.

2023-12-27 10:13:22  INFO    OGG-06510  Using the following key columns for target table *****T.CF_AM_A**OUNT_M***GAGE: ID.


2023-12-27 10:13:22  WARNING OGG-01004  Aborted grouped transacT*** on *****T.CF_AM_A**OUNT_M***GAGE, Database error 1403 (No data found).

2023-12-27 10:13:22  WARNING OGG-01003  ReposiT***ing to rba 20835975 in seqno 19284.

2023-12-27 10:13:22  WARNING OGG-01154  SQL error 1403 mapping SHELL_BIZ.CF_AM_A**OUNT_M***GAGE to *****T.CF_AM_A**OUNT_M***GAGE No data found.

Source Context :
  SourceModule            : [er.replicat.errors]
  SourceID                : [/scratch/aime/adestore/views/aime_adc4150325/oggcore/OpenSys/src/app/er/replicat/reperrors.cpp]
  SourceMethod            : [repError]
  SourceLine              : [1680]
  ThreadBacktrace         : [15] elements
                          : [/lib64/libc.so.6(__libc_start_main)]
                          : [/u01/ogg/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
                          : []
                          : []
                          : []
                          : [ng::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)]
                          : [/u01/ogg/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**)]
                          : [/lib64/libc.so.6(__libc_start_main)]
                          : [/u01/ogg/replicat()]
                          : [/u01/ogg/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**)]
                          : [  : [/u01/ogg/replicat(ggs::ggli:ggliltiThreading::MainThread::Rad::Ra, char**)]
]
                          : [/u01/ogg/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
                          : [/u01/ogg/replicat(main)]
                          : [/lib64/libc.so.6(__libc_start_main)]
                          : [/u01/ogg/replicat()]

2023-12-27 10:13:22  ERROR   OGG-01296  Error mapping from SHELL_BIZ.CF_AM_A**OUNT_M***GAGE to *****T.CF_AM_A**OUNT_M***GAGE.

***********************************************************************
*                   ** Run **** Statistics **                         *
***********************************************************************

从上面信息可以看出这个应该是在做表同步的时候，发现目标表数据不存在

2、logdump查看

通过logdump查看该操作是一个delete操作，目标表没有这个数据，那肯定是无法进行delete操作了，所以导致报错,如下是查出改行数据的相关信息

966370749177221120  2023-02-23:17:49:375    39  0  1078373077261225984  2023-12-26:15:5

3、目标表确认

select * from *****T.CF_**_AC**UNT_M***GAGE where id='966370749177221120'; 

查询结果显示为空，说明目标表数据确实不存在

4、处理

在目标表插入id为966370749177221120的一条数据
启动ogg进程，恢复正常