Saturday, October 15, 2011

Missing log records in receiving log queue for subscriber SUB_BILLPLAN_QUEUE errorcode = 416

Solution ( Below scripts needs to be run against each subscriber id having error)

begin
DBMS_MGWADM.CLEANUP_GATEWAY (action => DBMS_MGWADM.RESET_SUB_MISSING_LOG_REC,sarg => '<SUBSCRIBER_ID>');
end;

begin
dbms_mgwadm.reset_subscriber('<SUBSCRIBER_ID>');
end;


***********************************************
Refer mgw_subscibers for subscriber_id
***********************************************

No comments:

Post a Comment