With a high number of due jobs, the RetryExcecutor is failing to query the database for the first due job:
DEBUG [org.jboss.soa.esb.services.jbpm.integration.msg.RetryExecutor] Unexpected error rescheduling jobs, extending idle period
org.jbpm.persistence.JbpmPersistenceException: could not get first due job owned by 'RetryExecutor' ignoring jobs [490518
6, 4673400, ---
a looong list--, 4895759]
... 2 more
Caused by: java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000
Although it does not affect the function of the RetryExecutor, an additional check should be added so that the query triggered by the RetryExecutor is not affected by such a backlog.