You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ode.apache.org by Julio Cesar Damasceno <xj...@jheat.org> on 2008/12/07 00:37:05 UTC
DeploymentService undeploy error
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
Re: DeploymentService undeploy error
Posted by Rafal Rusin <ra...@gmail.com>.
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.InOutAxisOperation@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.WSAEndpoint@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.WSAEndpoint@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.WSAEndpoint@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.InOutAxisOperation@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.InOutAxisOperation@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.InOutAxisOperation@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.InOutAxisOperation@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.