You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ode.apache.org by "Sean Ahn (JIRA)" <ji...@apache.org> on 2008/12/09 07:11:44 UTC
[jira] Updated: (ODE-457) DeploymentService undeploy error
[ 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.