If you use non tagged version (which may fail some tests), it's better to get for example hudson latest stable artifacts. http://hudson.zones.apache.org/hudson/view/ODE/
However 1x branch is currently disabled, so you can try 2.0 one. Regards Julio Cesar Damasceno wrote: > > 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 > org.apache.axis2.description.inoutaxisoperat...@c26c8f > 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 org.apache.ode.bpel.epr.wsaendpo...@131767b > 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 org.apache.ode.bpel.epr.wsaendpo...@e56328 > 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 org.apache.ode.bpel.epr.wsaendpo...@1e61582 > 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 > org.apache.axis2.description.inoutaxisoperat...@c05c2 > 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 > org.apache.axis2.description.inoutaxisoperat...@c05c2 > 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 > org.apache.axis2.description.inoutaxisoperat...@c05c2 > 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 > org.apache.axis2.description.inoutaxisoperat...@1e4d960 > 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 > > -- View this message in context: http://www.nabble.com/DeploymentService-undeploy-error-tp20876003p21510274.html Sent from the Apache Ode User mailing list archive at Nabble.com.
