Bug 779760 (SOA-2122)

Summary:	JbpmPersistenceException in RetryExecutor with high number of due jobs
Product:	[JBoss] JBoss Enterprise SOA Platform 4	Reporter:	Martin Weiler <mweiler>
Component:	JBPM - within SOA	Assignee:	Nobody <nobody>
Status:	NEW ---	QA Contact:
Severity:	high	Docs Contact:
Priority:	high
Version:	4.3 CP04 GA	CC:	rwagner
Target Milestone:	---
Target Release:	FUTURE
Hardware:	Unspecified
OS:	Unspecified
URL:	http://jira.jboss.org/jira/browse/SOA-2122
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:	jBPM configured with JMS/JCA-Inflow based scheduler and message services
Last Closed:		Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:

Description Martin Weiler 2010-06-12 07:32:18 UTC

Help Desk Ticket Reference: https://enterprise.redhat.com/issue-tracker/917023
project_key: SOA

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]
    at org.jbpm.db.JobSession.getFirstDueJob(JobSession.java:101)
    at org.jbpm.db.JobSession.getFirstDueJob(JobSession.java:98)
    ... 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.

Comment 1 Kevin Conner 2010-06-12 07:33:29 UTC

Link: Added: This issue is related to SOA-2102

Comment 2 Kevin Conner 2010-06-12 07:39:35 UTC

Link: Added: This issue depends JBESB-3348

Comment 3 Rick Wagner 2011-12-05 20:54:06 UTC

Rick reviewing old JIRAs.  jBPM bug, old version so maybe fixed today.  But not sure, so left Open.