[ODE-457] DeploymentService undeploy error

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.3.2
• Component/s: BPEL Runtime
• Assignee: Matthieu Riou
• Reporter: Sean Ahn
• Created: 09/Dec/08 06:08
• Updated: 24/Apr/09 00:54
• Resolved: 12/Dec/08 23:30

Description

When un-deploying a process, a multi-table targetting delete query is generated on mysql/openjpa and fails.

ERROR - GeronimoLog.error(108) | DbError
<openjpa-1.2.0-r422266:683325 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Unknown table 't0' in MULTI DELETE

{prepstmnt 11114689 DELETE t0, t1 FROM ODE_EVENT WHERE EVENT_ID IN (SELECT DISTINCT t0.EVENT_ID FROM ODE_EVENT t0 INNER JOIN ODE_PROCESS_INSTANCE t1 ON t0.INSTANCE_ID = t1.ID WHERE (t1.PROCESS_ID =?)) [params=(long) 51]}

[code=1109, state=42S02] FailedObject: DELETE t0, t1 FROM ODE_EVENT WHERE EVENT_ID IN (SELECT DISTINCT t0.EVENT_ID FROM ODE_EVENT t0 INNER JOIN ODE_PROCESS_INSTANCE t1 ON t0.INSTANCE_ID = t1.ID WHERE (t1.PROCESS_ID = ?)) [java.lang.String]