Hi All,
Messages are not flowing from IBM MQ to Oracle AQ.
I could see the following error in MGW log.
>>2015-02-05 05:30:55 MGW Engine 0 410 worker3
Errors occurred during processing of job JOB_WEB_MSG
oracle.mgw.common.GatewayException: [417] Missing log records in sending log queue for job JOB_WEB_MSG
at oracle.mgw.common.MgwUtil.GatewayException(MgwUtil.java:733)
at oracle.mgw.engine.Worker.commitMessages(Worker.java:852)
at oracle.mgw.engine.Worker.processJob(Worker.java:1912)
at oracle.mgw.engine.Worker.myRun(Worker.java:96)
at oracle.mgw.engine.ManagedThr.run(ManagedThr.java:58)
>>2015-02-05 06:17:31 MGW Engine 0 51 ConfigNotifier
No missing logs for job JOB_WEB_MSG to process
>>2015-02-05 05:35:50 MGW Notif Handler 0 200 ConfigNotifier
I have done the below. Still the error persists.
begin
DBMS_MGWADM.CLEANUP_GATEWAY (action => DBMS_MGWADM.RESET_SUB_MISSING_LOG_REC,sarg => 'JOB_WEB_MSG');
end;
Please help me.
Thanks.