I'm using the lasted build, from
https://svn.apache.org/repos/asf/ode/branches/APACHE_ODE_1.X/, when I try do
use use the DeploymentService, the deploy works fine, but the undeploy give
an error:
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]
The log file is attached.
I'm using tomcat 5.5.27 and mysql-connector-java-5.1.6 and MySQL Server
5.0.51b.
--
Julio
C:\Java\tomcat55\bin>catalina.bat run
Using CATALINA_BASE: C:\Java\tomcat55
Using CATALINA_HOME: C:\Java\tomcat55
Using CATALINA_TMPDIR: C:\Java\tomcat55\temp
Using JRE_HOME: C:\Program Files\Java\jdk1.5.0_14
06/12/2008 20:14:22 org.apache.catalina.core.AprLifecycleListener lifecycleEvent
INFO: The Apache Tomcat Native library which allows optimal performance in
production environments was not found on the java.library.path: C:\Program
Files\Java\jdk1.5.0_
14\bin;.;C:\Windows\system32;C:\Windows;c:\ruby\bin;C:\Program Files\PC
Connectivity Solution\;C:\Perl\bin\;C:\Program Files\MiKTeX
2.7\miktex\bin;C:\Windows\system32;C:\
Windows;C:\Windows\System32\Wbem;C:\Program Files\MySQL\MySQL Server
5.0\bin;C:\Program Files\Common Files\Symbian\tools;C:\Program Files\CSL Arm
Toolchain\bin;C:\Program
Files\NTRU Cryptosystems\NTRU TCG Software Stack\bin\;C:\Program Files\Wave
Systems Corp\Gemalto\Access Client\v5\;C:\Program Files\Gemplus\GemSafe
Libraries\BIN;C:\Prog
ram Files\TortoiseSVN\bin;C:\Program
Files\QuickTime\QTSystem\;c:\maven2\bin;C:\apache-ode-1.1.1\bin;C:\Program
Files\Java\jdk1.5.0_14\bin;C:\Program Files\Java\J2EE5_05\
bin
06/12/2008 20:14:22 org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
06/12/2008 20:14:22 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1373 ms
06/12/2008 20:14:22 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
06/12/2008 20:14:22 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.27
06/12/2008 20:14:22 org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
DEBUG - GeronimoLog.debug(66) | Loading properties
DEBUG - GeronimoLog.debug(66) | Initializing transaction manager
DEBUG - GeronimoLog.debug(66) | Initializing transaction manager using
org.apache.ode.il.EmbeddedGeronimoFactory
DEBUG - GeronimoLog.debug(66) | Creating data source.
DEBUG - GeronimoLog.debug(66) | Starting DAO.
INFO - GeronimoLog.info(79) | Using DAO Connection Factory class
org.apache.ode.dao.jpa.BPELDAOConnectionFactoryImpl.
DEBUG - GeronimoLog.debug(66) | Initializing BPEL process store.
DEBUG - GeronimoLog.debug(66) | Initializing BPEL server.
DEBUG - GeronimoLog.debug(66) | ODE initializing
DEBUG - GeronimoLog.debug(66) | BPEL SERVER initializing
DEBUG - GeronimoLog.debug(66) | BPEL SERVER starting.
INFO - GeronimoLog.info(79) | BPEL Server Started.
DEBUG - GeronimoLog.debug(66) | Initializing JCA adapter.
INFO - GeronimoLog.info(79) | Poller started.
INFO - GeronimoLog.info(79) | Process deployment polling started on path
C:\Java\tomcat55\webapps\ode\WEB-INF\processes.
INFO - GeronimoLog.info(79) | ODE Service Engine has been started.
06/12/2008 20:14:38 org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
06/12/2008 20:14:38 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
06/12/2008 20:14:38 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/61 config=null
06/12/2008 20:14:38 org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
06/12/2008 20:14:38 org.apache.catalina.startup.Catalina start
INFO: Server startup in 16636 ms
DEBUG - GeronimoLog.debug(66) | The system is checking for the operation using
the following WSAAction: urn:anonOutInOp
DEBUG - GeronimoLog.debug(66) | Checking for Operation using SOAP message
body's first child's local name : deploy
DEBUG - GeronimoLog.debug(66) | Found operation [EMAIL PROTECTED]
DEBUG - GeronimoLog.debug(66) | Extracting file: deploy.xml
DEBUG - GeronimoLog.debug(66) | Extracting file: DynPartnerMain.bpel
DEBUG - GeronimoLog.debug(66) | Extracting file: DynPartnerResponder.bpel
DEBUG - GeronimoLog.debug(66) | Extracting file: Main.wsdl
DEBUG - GeronimoLog.debug(66) | Extracting file: Responder.wsdl
DEBUG - GeronimoLog.debug(66) | Extracting file: testRequest.soap
DEBUG - GeronimoLog.debug(66) | Process store event:
{ProcessStoreEvent#DEPLOYED:{http://ode/bpel/unit-test}DynPartnerMain-1}
DEBUG - GeronimoLog.debug(66) | Ignoring store event:
{ProcessStoreEvent#DEPLOYED:{http://ode/bpel/unit-test}DynPartnerMain-1}
DEBUG - GeronimoLog.debug(66) | Process store event:
{ProcessStoreEvent#ACTVIATED:{http://ode/bpel/unit-test}DynPartnerMain-1}
DEBUG - GeronimoLog.debug(66) | register:
{http://ode/bpel/unit-test}DynPartnerMain-1
DEBUG - GeronimoLog.debug(66) | Registering process
{http://ode/bpel/unit-test}DynPartnerMain-1 with server.
DEBUG - GeronimoLog.debug(66) | Register process:
serviceId={http://ode/bpel/unit-test.wsdl}DynMainService:DynMainPort,
process=BpelProcess[{http://ode/bpel/unit-test}Dyn
PartnerMain-1]
DEBUG - GeronimoLog.debug(66) | Activating
{http://ode/bpel/unit-test}DynPartnerMain-1
DEBUG - GeronimoLog.debug(66) | Destroying service DynMainService port
DynMainPort
DEBUG - GeronimoLog.debug(66) | Couldn't find service DynMainService port
DynMainPort to destroy.
DEBUG - GeronimoLog.debug(66) | Create AxisService:
service={http://ode/bpel/unit-test.wsdl}DynMainService port=DynMainPort
WSDL=Main.wsdl BPEL=DynPartnerMain.bpel
DEBUG - GeronimoLog.debug(66) | Get import: import=Responder.wsdl
parent=file:/C:/Java/tomcat55/webapps/ode/WEB-INF/processes/DynPartner-1/Main.wsdl
DEBUG - GeronimoLog.debug(66) | Looking for Axis2 service configuration file:
file:/C:/Java/tomcat55/webapps/ode/WEB-INF/processes/DynPartner-1/DynMainService.axis2
DEBUG - GeronimoLog.debug(66) | Axis2 service configuration not found:
file:/C:/Java/tomcat55/webapps/ode/WEB-INF/processes/DynPartner-1/DynMainService.axis2
DEBUG - GeronimoLog.debug(66) | Created Axis2 service
{http://ode/bpel/unit-test.wsdl}DynMainService
DEBUG - GeronimoLog.debug(66) | Activated
{http://ode/bpel/unit-test}DynPartnerMain-1 myrole initiatorPartnerLink: EPR is
[EMAIL PROTECTED]
DEBUG - GeronimoLog.debug(66) | Activated
{http://ode/bpel/unit-test}DynPartnerMain-1
DEBUG - GeronimoLog.debug(66) | Rehydrating process
{http://ode/bpel/unit-test}DynPartnerMain-1
DEBUG - GeronimoLog.debug(66) | Processing <invoke> element for process
{http://ode/bpel/unit-test}DynPartnerMain-1: partnerlink responderPartnerLink
--> {http://ode/bpel
/responder.wsdl}DynResponderService:DynResponderPort
DEBUG - GeronimoLog.debug(66) | Creating SOAP-bound external service
{http://ode/bpel/responder.wsdl}DynResponderService
DEBUG - GeronimoLog.debug(66) | Created external service
{http://ode/bpel/responder.wsdl}DynResponderService
DEBUG - GeronimoLog.debug(66) | Activated
{http://ode/bpel/unit-test}DynPartnerMain-1 partnerrole responderPartnerLink:
EPR is [EMAIL PROTECTED]
DEBUG - GeronimoLog.debug(66) | Creating process DAO for
{http://ode/bpel/unit-test}DynPartnerMain-1 (guid=hqejbhcnphr3t3uro9kno7)
INFO - GeronimoLog.info(79) | Registered process
{http://ode/bpel/unit-test}DynPartnerMain-1.
DEBUG - GeronimoLog.debug(66) | Process store event:
{ProcessStoreEvent#DEPLOYED:{http://ode/bpel/responder}DynPartnerResponder-1}
DEBUG - GeronimoLog.debug(66) | Ignoring store event:
{ProcessStoreEvent#DEPLOYED:{http://ode/bpel/responder}DynPartnerResponder-1}
DEBUG - GeronimoLog.debug(66) | Process store event:
{ProcessStoreEvent#ACTVIATED:{http://ode/bpel/responder}DynPartnerResponder-1}
DEBUG - GeronimoLog.debug(66) | register:
{http://ode/bpel/responder}DynPartnerResponder-1
DEBUG - GeronimoLog.debug(66) | Registering process
{http://ode/bpel/responder}DynPartnerResponder-1 with server.
DEBUG - GeronimoLog.debug(66) | Register process:
serviceId={http://ode/bpel/responder.wsdl}DynResponderService:DynResponderPort,
process=BpelProcess[{http://ode/bpel/res
ponder}DynPartnerResponder-1]
DEBUG - GeronimoLog.debug(66) | Activating
{http://ode/bpel/responder}DynPartnerResponder-1
DEBUG - GeronimoLog.debug(66) | Destroying service DynResponderService port
DynResponderPort
DEBUG - GeronimoLog.debug(66) | Couldn't find service DynResponderService port
DynResponderPort to destroy.
DEBUG - GeronimoLog.debug(66) | Create AxisService:
service={http://ode/bpel/responder.wsdl}DynResponderService
port=DynResponderPort WSDL=Responder.wsdl BPEL=DynPartnerR
esponder.bpel
DEBUG - GeronimoLog.debug(66) | Looking for Axis2 service configuration file:
file:/C:/Java/tomcat55/webapps/ode/WEB-INF/processes/DynPartner-1/DynResponderService.axis2
DEBUG - GeronimoLog.debug(66) | Axis2 service configuration not found:
file:/C:/Java/tomcat55/webapps/ode/WEB-INF/processes/DynPartner-1/DynResponderService.axis2
DEBUG - GeronimoLog.debug(66) | Created Axis2 service
{http://ode/bpel/responder.wsdl}DynResponderService
DEBUG - GeronimoLog.debug(66) | Activated
{http://ode/bpel/responder}DynPartnerResponder-1 myrole mainPartnerLink: EPR is
[EMAIL PROTECTED]
DEBUG - GeronimoLog.debug(66) | Activated
{http://ode/bpel/responder}DynPartnerResponder-1
DEBUG - GeronimoLog.debug(66) | Rehydrating process
{http://ode/bpel/responder}DynPartnerResponder-1
DEBUG - GeronimoLog.debug(66) | Creating process DAO for
{http://ode/bpel/responder}DynPartnerResponder-1 (guid=hqejbhcnphr3t3uro9kno8)
INFO - GeronimoLog.info(79) | Registered process
{http://ode/bpel/responder}DynPartnerResponder-1.
INFO - GeronimoLog.info(79) | Deployment of artifact DynPartner-1 successful.
DEBUG - GeronimoLog.debug(66) | Deployed package: DynPartner-1
DEBUG - GeronimoLog.debug(66) | Deployed PID:
{http://ode/bpel/unit-test}DynPartnerMain-1
DEBUG - GeronimoLog.debug(66) | Deployed PID:
{http://ode/bpel/responder}DynPartnerResponder-1
DEBUG - GeronimoLog.debug(66) | The system is checking for the operation using
the following WSAAction: urn:anonOutInOp
DEBUG - GeronimoLog.debug(66) | Checking for Operation using SOAP message
body's first child's local name : listProcesses
DEBUG - GeronimoLog.debug(66) | Found operation [EMAIL PROTECTED]
DEBUG - GeronimoLog.debug(66) | The system is checking for the operation using
the following WSAAction: urn:anonOutInOp
DEBUG - GeronimoLog.debug(66) | Checking for Operation using SOAP message
body's first child's local name : listProcesses
DEBUG - GeronimoLog.debug(66) | Found operation [EMAIL PROTECTED]
DEBUG - GeronimoLog.debug(66) | The system is checking for the operation using
the following WSAAction: urn:anonOutInOp
DEBUG - GeronimoLog.debug(66) | Checking for Operation using SOAP message
body's first child's local name : listProcesses
DEBUG - GeronimoLog.debug(66) | Found operation [EMAIL PROTECTED]
DEBUG - GeronimoLog.debug(66) | The system is checking for the operation using
the following WSAAction: urn:anonOutInOp
DEBUG - GeronimoLog.debug(66) | Checking for Operation using SOAP message
body's first child's local name : undeploy
DEBUG - GeronimoLog.debug(66) | Found operation [EMAIL PROTECTED]
DEBUG - GeronimoLog.debug(66) | Process store event:
{ProcessStoreEvent#UNDEPLOYED:{http://ode/bpel/unit-test}DynPartnerMain-1}
DEBUG - GeronimoLog.debug(66) | Deactivating process
{http://ode/bpel/unit-test}DynPartnerMain-1
DEBUG - GeronimoLog.debug(66) | deactivating non-shared endpoint
{http://ode/bpel/unit-test.wsdl}DynMainService:DynMainPort
DEBUG - GeronimoLog.debug(66) | Destroying service
{http://ode/bpel/unit-test.wsdl}DynMainService port DynMainPort
DEBUG - GeronimoLog.debug(66) | Couldn't find service
{http://ode/bpel/unit-test.wsdl}DynMainService port DynMainPort to destroy.
INFO - GeronimoLog.info(79) | Unregistered process
{http://ode/bpel/unit-test}DynPartnerMain-1.
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 t
0, 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 W
HERE (t1.PROCESS_ID = ?)) [java.lang.String]
at
org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4238)
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4203)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:72)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBulkOperation(JDBCStoreQuery.java:515)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeDelete(JDBCStoreQuery.java:433)
at
org.apache.openjpa.kernel.ExpressionStoreQuery$DataStoreExecutor.executeDelete(ExpressionStoreQuery.java:686)
at org.apache.openjpa.kernel.QueryImpl.delete(QueryImpl.java:1008)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:850)
at org.apache.openjpa.kernel.QueryImpl.deleteAll(QueryImpl.java:876)
at
org.apache.openjpa.kernel.DelegatingQuery.deleteAll(DelegatingQuery.java:557)
at
org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:329)
at
org.apache.ode.dao.jpa.ProcessDAOImpl.deleteEvents(ProcessDAOImpl.java:166)
at org.apache.ode.dao.jpa.ProcessDAOImpl.delete(ProcessDAOImpl.java:129)
at
org.apache.ode.bpel.engine.BpelServerImpl$2.run(BpelServerImpl.java:362)
at
org.apache.ode.bpel.engine.BpelServerImpl$2.run(BpelServerImpl.java:359)
at org.apache.ode.bpel.engine.BpelDatabase$1.call(BpelDatabase.java:76)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:208)
at org.apache.ode.bpel.engine.BpelDatabase.exec(BpelDatabase.java:74)
at
org.apache.ode.bpel.engine.BpelServerImpl.deleteProcessDAO(BpelServerImpl.java:358)
at
org.apache.ode.bpel.engine.BpelServerImpl.cleanupProcess(BpelServerImpl.java:322)
at org.apache.ode.axis2.ODEServer.handleEvent(ODEServer.java:607)
at org.apache.ode.axis2.ODEServer.access$100(ODEServer.java:86)
at
org.apache.ode.axis2.ODEServer$ProcessStoreListenerImpl.onProcessStoreEvent(ODEServer.java:588)
at
org.apache.ode.store.ProcessStoreImpl.fireEvent(ProcessStoreImpl.java:509)
at
org.apache.ode.store.ProcessStoreImpl.undeploy(ProcessStoreImpl.java:334)
at
org.apache.ode.axis2.service.DeploymentWebService$DeploymentMessageReceiver.invokeBusinessLogic(DeploymentWebService.java:184)
at
org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:96)
at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:145)
at
org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
at
org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:120)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Unknown table
't0' in MULTI DELETE {prepstmnt 11114689 DELETE t0, t1 FROM ODE_EVENT WHERE
EVENT_ID IN (SELEC
T 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=42S
02]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:57)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:866)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1504)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeUpdate(JDBCStoreQuery.java:671)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBulkOperation(JDBCStoreQuery.java:513)
... 42 more
NestedThrowables:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown table 't0' in
MULTI DELETE
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3176)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1153)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1404)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1318)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1303)
at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:864)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1504)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeUpdate(JDBCStoreQuery.java:671)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBulkOperation(JDBCStoreQuery.java:513)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeDelete(JDBCStoreQuery.java:433)
at
org.apache.openjpa.kernel.ExpressionStoreQuery$DataStoreExecutor.executeDelete(ExpressionStoreQuery.java:686)
at org.apache.openjpa.kernel.QueryImpl.delete(QueryImpl.java:1008)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:850)
at org.apache.openjpa.kernel.QueryImpl.deleteAll(QueryImpl.java:876)
at
org.apache.openjpa.kernel.DelegatingQuery.deleteAll(DelegatingQuery.java:557)
at
org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:329)
at
org.apache.ode.dao.jpa.ProcessDAOImpl.deleteEvents(ProcessDAOImpl.java:166)
at org.apache.ode.dao.jpa.ProcessDAOImpl.delete(ProcessDAOImpl.java:129)
at
org.apache.ode.bpel.engine.BpelServerImpl$2.run(BpelServerImpl.java:362)
at
org.apache.ode.bpel.engine.BpelServerImpl$2.run(BpelServerImpl.java:359)
at org.apache.ode.bpel.engine.BpelDatabase$1.call(BpelDatabase.java:76)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:208)
at org.apache.ode.bpel.engine.BpelDatabase.exec(BpelDatabase.java:74)
at
org.apache.ode.bpel.engine.BpelServerImpl.deleteProcessDAO(BpelServerImpl.java:358)
at
org.apache.ode.bpel.engine.BpelServerImpl.cleanupProcess(BpelServerImpl.java:322)
at org.apache.ode.axis2.ODEServer.handleEvent(ODEServer.java:607)
at org.apache.ode.axis2.ODEServer.access$100(ODEServer.java:86)
at
org.apache.ode.axis2.ODEServer$ProcessStoreListenerImpl.onProcessStoreEvent(ODEServer.java:588)
at
org.apache.ode.store.ProcessStoreImpl.fireEvent(ProcessStoreImpl.java:509)
at
org.apache.ode.store.ProcessStoreImpl.undeploy(ProcessStoreImpl.java:334)
at
org.apache.ode.axis2.service.DeploymentWebService$DeploymentMessageReceiver.invokeBusinessLogic(DeploymentWebService.java:184)
at
org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:96)
at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:145)
at
org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
at
org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:120)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:595)
WARN - GeronimoLog.warn(96) | Invocation of operation undeploy failed
org.apache.ode.bpel.iapi.BpelEngineException: DbError
at
org.apache.ode.bpel.engine.BpelServerImpl.deleteProcessDAO(BpelServerImpl.java:371)
at
org.apache.ode.bpel.engine.BpelServerImpl.cleanupProcess(BpelServerImpl.java:322)
at org.apache.ode.axis2.ODEServer.handleEvent(ODEServer.java:607)
at org.apache.ode.axis2.ODEServer.access$100(ODEServer.java:86)
at
org.apache.ode.axis2.ODEServer$ProcessStoreListenerImpl.onProcessStoreEvent(ODEServer.java:588)
at
org.apache.ode.store.ProcessStoreImpl.fireEvent(ProcessStoreImpl.java:509)
at
org.apache.ode.store.ProcessStoreImpl.undeploy(ProcessStoreImpl.java:334)
at
org.apache.ode.axis2.service.DeploymentWebService$DeploymentMessageReceiver.invokeBusinessLogic(DeploymentWebService.java:184)
at
org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:96)
at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:145)
at
org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
at
org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:120)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:595)
Caused by: <openjpa-1.2.0-r422266:683325 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Unknown table 't0' in
MULTI DELETE {prepstmnt 111146
89 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.PR
OCESS_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 W
HERE (t1.PROCESS_ID = ?)) [java.lang.String]
at
org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4238)
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4203)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:72)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBulkOperation(JDBCStoreQuery.java:515)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeDelete(JDBCStoreQuery.java:433)
at
org.apache.openjpa.kernel.ExpressionStoreQuery$DataStoreExecutor.executeDelete(ExpressionStoreQuery.java:686)
at org.apache.openjpa.kernel.QueryImpl.delete(QueryImpl.java:1008)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:850)
at org.apache.openjpa.kernel.QueryImpl.deleteAll(QueryImpl.java:876)
at
org.apache.openjpa.kernel.DelegatingQuery.deleteAll(DelegatingQuery.java:557)
at
org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:329)
at
org.apache.ode.dao.jpa.ProcessDAOImpl.deleteEvents(ProcessDAOImpl.java:166)
at org.apache.ode.dao.jpa.ProcessDAOImpl.delete(ProcessDAOImpl.java:129)
at
org.apache.ode.bpel.engine.BpelServerImpl$2.run(BpelServerImpl.java:362)
at
org.apache.ode.bpel.engine.BpelServerImpl$2.run(BpelServerImpl.java:359)
at org.apache.ode.bpel.engine.BpelDatabase$1.call(BpelDatabase.java:76)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:208)
at org.apache.ode.bpel.engine.BpelDatabase.exec(BpelDatabase.java:74)
at
org.apache.ode.bpel.engine.BpelServerImpl.deleteProcessDAO(BpelServerImpl.java:358)
... 27 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Unknown table
't0' in MULTI DELETE {prepstmnt 11114689 DELETE t0, t1 FROM ODE_EVENT WHERE
EVENT_ID IN (SELEC
T 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=42S
02]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:57)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:866)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1504)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeUpdate(JDBCStoreQuery.java:671)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBulkOperation(JDBCStoreQuery.java:513)
... 42 more
