normal | wide

Signup for Training


More trainings...

Intalio|BPMS Webinars

Latest Posts


Show last 6 hrs - 24 hrs - 7 days

Forum tags


Top Posters

Last 30 days

  • ravinderjit.singh (29)
  • Antoine (26)
  • danielandross (17)
  • venkaiah.k (16)
  • sirswendu.ganapati (13)
  • eva.das (13)
  • shao (13)
  • metabyte (9)
  • milos.vacek (7)
  • cristiano.quintao (7)

All time

  • Antoine (1492)
  • Shivanand (1194)
  • cshekhar (928)
  • psq (796)
  • jag (391)
  • metabyte (380)
  • arnaud (328)
  • jalateras (325)
  • dfrench (271)
  • venkaiah.k (214)

Show last 4 hrs - 12 hrs - 24 hrs

POLL

We are looking for more information to tailor our training to better meet the needs of our customers. Please indicate all options that apply.

I would like to attend specialized training from Intalio on BPM as it relates to my application area:

I would like to attend specialized training from Intalio on BPM as it relates to my job function:

I would like to attend specialized training from Intalio on BPM as it relates to my industry:

Login

Who's online?

MAIN arrow FORUMS
Intalio|BPMS Community Edition General Questions
Problems with BPMS engine (0 viewing) 
Go to bottom Post Reply Favoured: 0
TOPIC: Problems with BPMS engine
#16889
jose.mendoza (User)
Fresh Boarder
User Offline Click here to see the profile of this user
Problems with BPMS engine 1 Month, 3 Weeks ago Karma: 0  
Hello !!

I'm having this error and I do not know why.

Can somebody help?

Thanks in advance.

13:46:26,498 WARN [org.hibernate.util.JDBCExceptionReporter] [ODEServer-2] SQL Error: 30000, SQLState: 40001
13:49:04,013 ERROR [org.apache.ode.bpel.runtime.INVOKE] [ODEServer-9] Failure during invoke: Dangling invocation (mexId=6094850), forcing it into a failed state.
13:48:05,763 ERROR [org.apache.ode.axis2.ODEService] [DefaultThreadPool 458] Timeout or execution error when waiting for response to MEX {MyRoleMex#6094851 [Client 9e67a4e6-68dc-420f-be62-5375966fb4a4-1] calling {http://www.intalio.com/bpms/workflow/ib4p_20051115}UserBusinessProcessService.createTask(...)} java.util.concurrent.TimeoutException: Message exchange org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@197c173 timed out when waiting for a response!
13:47:05,576 ERROR [org.apache.ode.axis2.SoapExternalService] [ODEServer-4] Error sending message (mex={PartnerRoleMex#6094850 [PID {http://example.com/ControlExchangesDNB_loop/BPMLAYER}BPMLAYER-59] calling (...)}): Read timed out
org.apache.axis2.AxisFault: Read timed out
at org.apache.axis2.AxisFault.makeFault(AxisFault.java:417)
at org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:195)
at org.apache.axis2.transport.http.HTTPSender.send(HTTPSender.java:77)
at org.apache.axis2.transport.http.CommonsHTTPTransportSender.writeMessageWithCommons(CommonsHTTPTransportSender.java:327)
at org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:206)
at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:396)
at org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:374)
at org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:211)
at org.apache.axis2.client.OperationClient.execute(OperationClient.java:163)
at org.apache.ode.axis2.SoapExternalService$1$1.call(SoapExternalService.java:162)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.net.SocketTimeoutException: Read timed out
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:129)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)
at java.io.BufferedInputStream.read(BufferedInputStream.java:237)
at org.apache.commons.httpclient.HttpParser.readRawLine(HttpParser.java:77)
at org.apache.commons.httpclient.HttpParser.readLine(HttpParser.java:105)
at org.apache.commons.httpclient.HttpConnection.readLine(HttpConnection.java:1115)
at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.readLine(MultiThreadedHttpConnectionManager.java:1373)
at org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMethodBase.java:1832)
at org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodBase.java:1590)
at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:995)
at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:397)
at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:170)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:396)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:346)
at org.apache.axis2.transport.http.AbstractHTTPSender.executeMethod(AbstractHTTPSender.java:520)
at org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:191)
... 13 more
13:49:47,466 ERROR [org.hibernate.util.JDBCExceptionReporter] [ODEServer-2] A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, BPEL_CORRELATION_SET, (2,23)
Waiting XID : {162115, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=?
Granted XID : {162118, X}
Lock : ROW, BPEL_CORRELATION_SET, (2,24)
Waiting XID : {162118, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=?
Granted XID : {162115, X}
. The selected victim is XID : 162115.
13:49:48,357 ERROR [org.apache.ode.jacob.vpu.JacobVPU] [ODEServer-2] Method "run" in class "org.apache.ode.bpel.runtime.REPLY" threw an unexpected exception.
org.hibernate.exception.LockAcquisitionException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:82)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2223)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.apache.ode.daohib.bpel.ScopeDaoImpl.getCorrelationSet(ScopeDaoImpl.java:75)
at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.writeCorrelation(BpelRuntimeContextImpl.java:572)
at org.apache.ode.bpel.runtime.BpelJacobRunnable.initializeCorrelation(BpelJacobRunnable.java:101)
at org.apache.ode.bpel.runtime.REPLY.run(REPLY.java:59)
at sun.reflect.GeneratedMethodAccessor263.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.ode.jacob.vpu.JacobVPU$JacobThreadImpl.run(JacobVPU.java:451)
at org.apache.ode.jacob.vpu.JacobVPU.execute(JacobVPU.java:139)
at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.execute(BpelRuntimeContextImpl.java:848)
at org.apache.ode.bpel.engine.PartnerLinkMyRoleImpl.invokeNewInstance(PartnerLinkMyRoleImpl.java:197)
at org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:199)
at org.apache.ode.bpel.engine.BpelProcess.handleWorkEvent(BpelProcess.java:367)
at org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:331)
at org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl.java:373)
at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:337)
at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:336)
at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:174)
at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:335)
at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:332)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, BPEL_CORRELATION_SET, (2,23)
Waiting XID : {162115, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=?
Granted XID : {162118, X}
Lock : ROW, BPEL_CORRELATION_SET, (2,24)
Waiting XID : {162118, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=?
Granted XID : {162115, X}
. The selected victim is XID : 162115.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.closeOnTransactionError(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
at org.tranql.connector.jdbc.ResultSetHandle.next(ResultSetHandle.java:791)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
... 32 more
Caused by: java.sql.SQLException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, BPEL_CORRELATION_SET, (2,23)
Waiting XID : {162115, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=?
Granted XID : {162118, X}
Lock : ROW, BPEL_CORRELATION_SET, (2,24)
Waiting XID : {162118, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=?
Granted XID : {162115, X}
. The selected victim is XID : 162115.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 45 more
13:49:48,388 ERROR [org.intalio.tempo.workflow.fds.core.UserProcessMessageConvertor] [DefaultThreadPool 453] Fault in response:
<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><soapenv:Fault xmlns:axis2ns1="http://incubator.apache.org/ode"><faultcode>axis2ns1:Fault</faultcode><faultstring>Timeout or execution error when waiting for response to MEX {MyRoleMex#6094851 [Client 9e67a4e6-68dc-420f-be62-5375966fb4a4-1] calling {http://www.intalio.com/bpms/workflow/ib4p_20051115}UserBusinessProcessService.createTask(...)} java.util.concurrent.TimeoutException: Message exchange org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@197c173 timed out when waiting for a response!</faultstring><detail><Exception>org.apache.ode.axis2.OdeFault: Timeout or execution error when waiting for response to MEX {MyRoleMex#6094851 [Client 9e67a4e6-68dc-420f-be62-5375966fb4a4-1] calling {http://www.intalio.com/bpms/workflow/ib4p_20051115}UserBusinessProcessService.createTask(...)} java.util.concurrent.TimeoutException: Message exchange org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@197c173 timed out when waiting for a response!
at org.apache.ode.axis2.ODEService.onAxisMessageExchange(ODEService.java:154)
at org.apache.ode.axis2.hooks.ODEMessageReceiver.invokeBusinessLogic(ODEMessageReceiver.java:67)
at org.apache.ode.axis2.hooks.ODEMessageReceiver.invokeBusinessLogic(ODEMessageReceiver.java:50)
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:713)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:806)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at org.apache.geronimo.jetty6.InternalJettyServletHolder.handle(InternalJettyServletHolder.java:65)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:362)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.apache.geronimo.jetty6.handler.ThreadClassloaderHandler.handle(ThreadClassloaderHandler.java:46)
at org.apache.geronimo.jetty6.handler.InstanceContextHandler.handle(InstanceContextHandler.java:58)
at org.apache.geronimo.jetty6.handler.UserTransactionHandler.handle(UserTransactionHandler.java:48)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:712)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
at org.apache.geronimo.jetty6.handler.ComponentContextHandler.handle(ComponentContextHandler.java:47)
at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:211)
at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)
at org.mortbay.jetty.Server.handle(Server.java:313)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:506)
at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:844)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:644)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:381)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:396)
at org.apache.geronimo.pool.ThreadPool$1.run(ThreadPool.java:201)
at org.apache.geronimo.pool.ThreadPool$ContextClassLoaderRunnable.run(ThreadPool.java:331)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
at java.lang.Thread.run(Thread.java:619)
</Exception></detail></soapenv:Fault></soapenv:Body></soapenv:Envelope>
13:49:48,670 ERROR [org.apache.ode.bpel.engine.BpelEngineImpl] [ODEServer-2] Scheduled job failed; jobDetail={mexid=6094851, pid={http://example.com/TMP/TaskManagementProcess}TaskManagementProcess-3, type=INVOKE_INTERNAL}
java.lang.RuntimeException: org.hibernate.exception.LockAcquisitionException: could not execute query
at org.apache.ode.jacob.vpu.JacobVPU$JacobThreadImpl.run(JacobVPU.java:464)
at org.apache.ode.jacob.vpu.JacobVPU.execute(JacobVPU.java:139)
at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.execute(BpelRuntimeContextImpl.java:848)
at org.apache.ode.bpel.engine.PartnerLinkMyRoleImpl.invokeNewInstance(PartnerLinkMyRoleImpl.java:197)
at org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:199)
at org.apache.ode.bpel.engine.BpelProcess.handleWorkEvent(BpelProcess.java:367)
at org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:331)
at org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl.java:373)
at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:337)
at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:336)
at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:174)
at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:335)
at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:332)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.hibernate.exception.LockAcquisitionException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:82)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2223)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.apache.ode.daohib.bpel.ScopeDaoImpl.getCorrelationSet(ScopeDaoImpl.java:75)
at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.writeCorrelation(BpelRuntimeContextImpl.java:572)
at org.apache.ode.bpel.runtime.BpelJacobRunnable.initializeCorrelation(BpelJacobRunnable.java:101)
at org.apache.ode.bpel.runtime.REPLY.run(REPLY.java:59)
at sun.reflect.GeneratedMethodAccessor263.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.ode.jacob.vpu.JacobVPU$JacobThreadImpl.run(JacobVPU.java:451)
... 17 more
Caused by: java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, BPEL_CORRELATION_SET, (2,23)
Waiting XID : {162115, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=?
Granted XID : {162118, X}
Lock : ROW, BPEL_CORRELATION_SET, (2,24)
Waiting XID : {162118, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=?
Granted XID : {162115, X}
. The selected victim is XID : 162115.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.closeOnTransactionError(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
at org.tranql.connector.jdbc.ResultSetHandle.next(ResultSetHandle.java:791)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
... 32 more
Caused by: java.sql.SQLException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, BPEL_CORRELATION_SET, (2,23)
Waiting XID : {162115, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=?
Granted XID : {162118, X}
Lock : ROW, BPEL_CORRELATION_SET, (2,24)
Waiting XID : {162118, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=?
Granted XID : {162115, X}
. The selected victim is XID : 162115.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 45 more
13:49:49,263 WARN [Transaction] [ODEServer-2] Error ending association for XAResource org.apache.geronimo.transaction.manager.WrapperNamedXAResource@1ce2c0c; transaction will roll back. XA error code: 102
javax.transaction.xa.XAException
at org.apache.derby.jdbc.EmbedXAResource.end(Unknown Source)
at org.apache.geronimo.transaction.manager.WrapperNamedXAResource.end(WrapperNamedXAResource.java:51)
at org.apache.geronimo.transaction.manager.TransactionImpl.endResources(TransactionImpl.java:563)
at org.apache.geronimo.transaction.manager.TransactionImpl.endResources(TransactionImpl.java:542)
at org.apache.geronimo.transaction.manager.TransactionImpl.rollback(TransactionImpl.java:473)
at org.apache.geronimo.transaction.manager.TransactionManagerImpl.rollback(TransactionManagerImpl.java:250)
at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:183)
at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:335)
at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:332)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
at java.lang.Thread.run(Thread.java:619)
13:49:49,341 ERROR [org.apache.ode.scheduler.simple.SimpleScheduler] [ODEServer-2] Error while processing transaction, retrying.
org.apache.ode.bpel.iapi.Scheduler$JobProcessorException: java.lang.RuntimeException: org.hibernate.exception.LockAcquisitionException: could not execute query
at org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:341)
at org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl.java:373)
at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:337)
at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:336)
at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:174)
at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:335)
at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:332)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.RuntimeException: org.hibernate.exception.LockAcquisitionException: could not execute query
at org.apache.ode.jacob.vpu.JacobVPU$JacobThreadImpl.run(JacobVPU.java:464)
at org.apache.ode.jacob.vpu.JacobVPU.execute(JacobVPU.java:139)
at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.execute(BpelRuntimeContextImpl.java:848)
at org.apache.ode.bpel.engine.PartnerLinkMyRoleImpl.invokeNewInstance(PartnerLinkMyRoleImpl.java:197)
at org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:199)
at org.apache.ode.bpel.engine.BpelProcess.handleWorkEvent(BpelProcess.java:367)
at org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:331)
... 11 more
Caused by: org.hibernate.exception.LockAcquisitionException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:82)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2223)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.apache.ode.daohib.bpel.ScopeDaoImpl.getCorrelationSet(ScopeDaoImpl.java:75)
at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.writeCorrelation(BpelRuntimeContextImpl.java:572)
at org.apache.ode.bpel.runtime.BpelJacobRunnable.initializeCorrelation(BpelJacobRunnable.java:101)
at org.apache.ode.bpel.runtime.REPLY.run(REPLY.java:59)
at sun.reflect.GeneratedMethodAccessor263.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.ode.jacob.vpu.JacobVPU$JacobThreadImpl.run(JacobVPU.java:451)
... 17 more
Caused by: java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, BPEL_CORRELATION_SET, (2,23)
Waiting XID : {162115, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=?
Granted XID : {162118, X}
Lock : ROW, BPEL_CORRELATION_SET, (2,24)
Waiting XID : {162118, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=?
Granted XID : {162115, X}
. The selected victim is XID : 162115.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.closeOnTransactionError(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
at org.tranql.connector.jdbc.ResultSetHandle.next(ResultSetHandle.java:791)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
... 32 more
Caused by: java.sql.SQLException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, BPEL_CORRELATION_SET, (2,23)
Waiting XID : {162115, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=?
Granted XID : {162118, X}
Lock : ROW, BPEL_CORRELATION_SET, (2,24)
Waiting XID : {162118, S} , APP, select hcorrelati0_.ID as ID11_, hcorrelati0_.VALUE as VALUE11_, hcorrelati0_.CORR_SET_NAME as CORR3_11_, hcorrelati0_.SCOPE_ID as SCOPE4_11_, hcorrelati0_.PIID as PIID11_, hcorrelati0_.PROCESS_ID as PROCESS6_11_, hcorrelati0_.INSERT_TIME as INSERT7_11_, hcorrelati0_.MLOCK as MLOCK11_ from BPEL_CORRELATION_SET hcorrelati0_ where hcorrelati0_.CORR_SET_NAME=? and hcorrelati0_.SCOPE_ID=?
Granted XID : {162115, X}
. The selected victim is XID : 162115.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 45 more
File Attachment:
File Name: ControlExchangesDNB.zip
File Size: 149087
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#16892
Antoine (Admin)
Admin
User Offline Click here to see the profile of this user
Re:Problems with BPMS engine 1 Month, 3 Weeks ago Karma: 28  
You have a deadlock.

The problem comes from ODE + Derby. Derby doesn't have a transaction engine like InnoDB for Mysql, and ODE does parallel processing, so that ends up in deadlocks. ODE could be handling this in a better way, but that requires some work.

In the mean time, you need to move away from Derby and use Mysql. All instructions related to the change of database are available in the reference guides of the help section.

Thanks,

Antoine
 
Report to moderator   Logged Logged  
 
Intalio, the Open Source BPMS company
www.intalio.com
  The administrator has disabled public write access.
#17137
jose.mendoza (User)
Fresh Boarder
User Offline Click here to see the profile of this user
Re:Problems with BPMS engine 1 Month ago Karma: 0  
Hello Antoine,

Sorry for my late reply, I took some holidays in the meantime.

Regarding your reply I only have one extra question, can we do use SQL server instead of MySQL.

Thanks in advance
Jose
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#17141
jose.mendoza (User)
Fresh Boarder
User Offline Click here to see the profile of this user
Re:Problems with BPMS engine 1 Month ago Karma: 0  
Hello Antoine,

I did all the step required for installation on MySQL (creation of DB etc etc) and I'm getting
this message (underneath)

Is this an error or just a warning?

Thanks a lot for your help.
Regards
jose
================ // ========================

C:\Intalio\intalio_server_bpms_5_2_0_050\bin>deploy.bat --offline redeploy ..\repository\org\tranql\tranql-connector-ra\1.3\tranql-connector-ra-1
.3.rar ..\databases\MySQL\geronimo-ds.xml
Using GERONIMO_BASE: C:\Intalio\intalio_server_bpms_5_2_0_050
Using GERONIMO_HOME: C:\Intalio\intalio_server_bpms_5_2_0_050
Using GERONIMO_TMPDIR: var\temp
Using JRE_HOME: C:\Program Files\Java\jdk1.6.0_04\jre
No ModuleID or TargetModuleID provided. Attempting to guess based
on the content of the plan.
Attempting to use ModuleID 'com.intalio.bpms/BPMSDS/1.0/rar'
10:29:17,038 WARN [ConnectorPlanRectifier] Your connector plan has obsolete elements or attributes in it. Please remove version attributes, glo
bal-jndi-name elements, and credential-interface elements
Uninstalled com.intalio.bpms/BPMSDS/1.0/rar
Deployed com.intalio.bpms/BPMSDS/1.0/rar
Started com.intalio.bpms/BPMSDS/1.0/rar
Redeployed com.intalio.bpms/BPMSDS/1.0/rar
[] received stop signal
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#17145
ravinderjit.singh (User)
Expert Boarder
User Offline Click here to see the profile of this user
Re:Problems with BPMS engine 1 Month ago Karma: 1  
Hi Jose,

These are just warning messages, your server is successfully configured with MySQ now you can start your server and execute the processes successfully.

Thanks,
Ravinderjit.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#17149
Antoine (Admin)
Admin
User Offline Click here to see the profile of this user
Re:Problems with BPMS engine 1 Month ago Karma: 28  
I'm asking my coworkers.

Stay put!

Thanks,

Antoine
 
Report to moderator   Logged Logged  
 
Intalio, the Open Source BPMS company
www.intalio.com
  The administrator has disabled public write access.
Go to top Post Reply
get the latest posts directly to your desktop