BPEL instance recovery is not picking up all eligible messages (Doc ID 2158084.1)

Last updated on OCTOBER 21, 2021

Applies to:

Symptoms

BPEL Auto-Recovery is not working as expected after enabling recurring recovery.

The SQL which represent undelivered messages (state=0) shows a large count:

- Invoke messages with recover count < 3

Select COUNT(MESSAGE_GUID), COMPOSITE_NAME from DLV_MESSAGE where state =0 AND DLV_TYPE = 1 AND recover_count > 3 AND RECEIVE_DATE < (SYSDATE- INTERVAL '30' MINUTE) GROUP BY COMPOSITE_NAME

- Invoke messages with recover count > 3
Select COUNT(MESSAGE_GUID), COMPOSITE_NAME from DLV_MESSAGE where state =0 AND DLV_TYPE = 1 AND recover_count < 3 AND RECEIVE_DATE < (SYSDATE- INTERVAL '30' MINUTE) GROUP BY COMPOSITE_NAME

- Callback messages with recover count < 3

Select COUNT(MESSAGE_GUID), COMPOSITE_NAME from DLV_MESSAGE where state =0 AND DLV_TYPE = 2 AND recover_count < 3 AND RECEIVE_DATE < (SYSDATE- INTERVAL '30' MINUTE) GROUP BY COMPOSITE_NAME

- Recoverable Activity messages

SELECT COUNT (*) , CI.COMPOSITE_NAME FROM WORK_ITEM WI, CUBE_INSTANCE CI WHERE CI.CIKEY = WI.CIKEY AND CI.STATE <= 3 AND WI.STATE = 1 AND WI.EXP_DATE IS NULL AND WI.EXP_FLAG = 0 AND WI.EXECUTION_TYPE != 1 AND WI.MODIFY_DATE < (SYSDATE- INTERVAL '30' MINUTE) AND WI.EXT_INT1 < 3 GROUP BY CI.COMPOSITE_NAME

- Recoverable expirable count

SELECT COUNT(*) ,COMPOSITE_NAME FROM WI_EXPIRABLE WHERE EXP_DATE < (SYSDATE- INTERVAL '30' MINUTE) GROUP BY COMPOSITE_NAME

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.