[
https://issues.apache.org/jira/browse/ODE-457?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sean Ahn updated ODE-457:
-------------------------
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]
was:
When un-deploying a process, a multi-table targetting delete query is generated
on mysql 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]
> DeploymentService undeploy error
> --------------------------------
>
> Key: ODE-457
> URL: https://issues.apache.org/jira/browse/ODE-457
> Project: ODE
> Issue Type: Bug
> Components: BPEL Runtime
> Reporter: Sean Ahn
>
> 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]
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
