[DM_SESSION_E_TRANSACTION_ERROR]error: "Transaction invalid due to errors, please abort transaction

Hi there.

I have an xCP stateful workflow that triggers stateless sub-workflow. But the sub-workflow task fails and becomes paused. Hereunder the java method server logs corresponding to this failure, and the sub-workflow. It just counts the attachments referenced in an XML package, loops to insert them (from the repository using DQL) in the workflow attachments,and then links the workflows attachments to a given (new) folder in the repository.

Analysing the logs does not help much. It just more or less says to me that it fails because there has been an error. But maybe I dont' know how to read that properly... So how can I identify the error? Are there other logs I can look at (bpm.log does not contain anything)? Or is it possible to increase the log level to get more details? If you need more info to help, don't hesitate to ask.

Thanks for your help.

Screenshot - 19_04_2013 , 14_37_59.jpg

2013-04-19 14:12:31,964 ERROR [STDERR] (http-0.0.0.0-9080-6) DfException:: THREAD: http-0.0.0.0-9080-6; MSG: Could not invoke child process <RDR - Store Attachments By Message>; ERRORCODE: ff; NEXT: null

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.bps.syncsubproc.StartSubProcessUtils.startStatelessWorkflow(StartSubProcessUtils.java:46)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.bps.syncsubproc.runtime.StartSubProcessService.execute(StartSubProcessService.java:126)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.bpm.services.BPSIntegrationFramework.executeService(BPSIntegrationFramework.java:252)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.bpm.services.BPSIntegrationFramework.executeMethod(BPSIntegrationFramework.java:84)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.bpm.services.BPSIntegrationMethod.executeMethod(BPSIntegrationMethod.java:26)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.bpm.rtutil.GenericWorkflowMethod.execute(GenericWorkflowMethod.java:124)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.bpm.rtutil.GenericWorkflowMethod.execute(GenericWorkflowMethod.java:65)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.mthdservlet.DfMethodRunner.runIt(Unknown Source)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.mthdservlet.AMethodRunner.runAndReturnStatus(Unknown Source)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.mthdservlet.DoMethod.invokeMethod(Unknown Source)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.mthdservlet.DoMethod.doPost(Unknown Source)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at java.lang.Thread.run(Thread.java:662)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) Caused by: DfException:: THREAD: http-0.0.0.0-9080-6; MSG: [DM_SESSION_E_TRANSACTION_ERROR]error: "Transaction invalid due to errors, please abort transaction."; ERRORCODE: 100; NEXT: null

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.fc.client.impl.docbase.DocbaseExceptionMapper.newException(DocbaseExceptionMapper.java:57)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.fc.client.impl.connection.docbase.MessageEntry.getException(MessageEntry.java:39)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.fc.client.impl.connection.docbase.DocbaseMessageManager.getException(DocbaseMessageManager.java:137)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.fc.client.impl.connection.docbase.netwise.NetwiseDocbaseRpcClient.checkForMessages(NetwiseDocbaseRpcClient.java:310)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.fc.client.impl.connection.docbase.netwise.NetwiseDocbaseRpcClient.applyForInt(NetwiseDocbaseRpcClient.java:581)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.fc.client.impl.connection.docbase.DocbaseConnection$6.evaluate(DocbaseConnection.java:1254)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.fc.client.impl.connection.docbase.DocbaseConnection.evaluateRpc(DocbaseConnection.java:1056)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.fc.client.impl.connection.docbase.DocbaseConnection.applyForInt(DocbaseConnection.java:1247)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.fc.client.impl.docbase.DocbaseApi.parameterizedSave(DocbaseApi.java:768)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.fc.client.DfSysObject$1.evaluate(DfSysObject.java:373)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.fc.client.impl.util.TransactionalFunctorWithRetry.evaluateUnderTransactionWithDeadlockRetry(TransactionalFunctorWithRetry.java:38)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.fc.client.impl.util.TransactionalFunctorWithRetry.evaluate(TransactionalFunctorWithRetry.java:25)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.fc.client.DfSysObject.evaluateUnderTransactionWithDeadlockRetry(DfSysObject.java:929)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.fc.client.DfSysObject.doSaveImpl(DfSysObject.java:401)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.fc.client.DfSysObject.doSave(DfSysObject.java:206)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.fc.client.DfPersistentObject.saveEx(DfPersistentObject.java:912)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.fc.client.DfPersistentObject.save(DfPersistentObject.java:907)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.fc.client.DfDocument___PROXY.save(DfDocument___PROXY.java)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.bpm.rtutil.GenericWorkflowMethod.printStackTrace(GenericWorkflowMethod.java:193)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.bpm.rtutil.GenericWorkflowMethod.execute(GenericWorkflowMethod.java:155)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.bpm.rtutil.GenericWorkflowMethod.execute(GenericWorkflowMethod.java:84)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.bpm.engine.utils.InvokeWfMethodService.execute(InvokeWfMethodService.java:96)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.bpm.engine.model.activity.WorkflowMethodActivityTaskHandler.executeWorkitem(WorkflowMethodActivityTaskHandler.java:43)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.bpm.engine.runtime.AutomaticWorkitemHandler.executeService(AutomaticWorkitemHandler.java:256)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.bpm.engine.runtime.AutomaticWorkitemHandler.execute(AutomaticWorkitemHandler.java:119)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.bpm.engine.runtime.ProcessEngineImpl.recursiveAutomaticWorkitemExecution(ProcessEngineImpl.java:411)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.bpm.engine.runtime.ProcessEngineImpl.recursiveAutomaticWorkitemExecution(ProcessEngineImpl.java:418)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.bpm.engine.runtime.ProcessEngineImpl.executeSync(ProcessEngineImpl.java:292)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.bpm.engine.runtime.ProcessEngineImpl.startWorkflowSynchronously(ProcessEngineImpl.java:245)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.bpm.engine.StatelessEngine.executeInternal(StatelessEngine.java:89)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.bpm.engine.StatelessEngine.execute(StatelessEngine.java:66)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) at com.documentum.bps.syncsubproc.StartSubProcessUtils.startStatelessWorkflow(StartSubProcessUtils.java:42)

2013-04-19 14:12:31,979 ERROR [STDERR] (http-0.0.0.0-9080-6) ... 32 more

2013-04-19 14:12:32,198 INFO [STDOUT] (http-0.0.0.0-9080-6) 2013-04-19 14:12:32,198 ERROR [http-0.0.0.0-9080-6] [com.documentum.mthdservlet.DoMethod] - Exception invoking com.documentum.bpm.services.BPSIntegrationMethod.

DfException:: THREAD: http-0.0.0.0-9080-6; MSG: Could not invoke child process <RDR - Store Attachments By Message>; ERRORCODE: ff; NEXT: null

at com.documentum.bps.syncsubproc.StartSubProcessUtils.startStatelessWorkflow(StartSubProcessUtils.java:46)

at com.documentum.bps.syncsubproc.runtime.StartSubProcessService.execute(StartSubProcessService.java:126)

at com.documentum.bpm.services.BPSIntegrationFramework.executeService(BPSIntegrationFramework.java:252)

at com.documentum.bpm.services.BPSIntegrationFramework.executeMethod(BPSIntegrationFramework.java:84)

at com.documentum.bpm.services.BPSIntegrationMethod.executeMethod(BPSIntegrationMethod.java:26)

at com.documentum.bpm.rtutil.GenericWorkflowMethod.execute(GenericWorkflowMethod.java:124)

at com.documentum.bpm.rtutil.GenericWorkflowMethod.execute(GenericWorkflowMethod.java:65)

at com.documentum.mthdservlet.DfMethodRunner.runIt(Unknown Source)

at com.documentum.mthdservlet.AMethodRunner.runAndReturnStatus(Unknown Source)

at com.documentum.mthdservlet.DoMethod.invokeMethod(Unknown Source)

at com.documentum.mthdservlet.DoMethod.doPost(Unknown Source)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)

at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)

at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)

at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

at java.lang.Thread.run(Thread.java:662)

Caused by: DfException:: THREAD: http-0.0.0.0-9080-6; MSG: [DM_SESSION_E_TRANSACTION_ERROR]error: "Transaction invalid due to errors, please abort transaction."; ERRORCODE: 100; NEXT: null

at com.documentum.fc.client.impl.docbase.DocbaseExceptionMapper.newException(DocbaseExceptionMapper.java:57)

at com.documentum.fc.client.impl.connection.docbase.MessageEntry.getException(MessageEntry.java:39)

at com.documentum.fc.client.impl.connection.docbase.DocbaseMessageManager.getException(DocbaseMessageManager.java:137)

at com.documentum.fc.client.impl.connection.docbase.netwise.NetwiseDocbaseRpcClient.checkForMessages(NetwiseDocbaseRpcClient.java:310)

at com.documentum.fc.client.impl.connection.docbase.netwise.NetwiseDocbaseRpcClient.applyForInt(NetwiseDocbaseRpcClient.java:581)

at com.documentum.fc.client.impl.connection.docbase.DocbaseConnection$6.evaluate(DocbaseConnection.java:1254)

at com.documentum.fc.client.impl.connection.docbase.DocbaseConnection.evaluateRpc(DocbaseConnection.java:1056)

at com.documentum.fc.client.impl.connection.docbase.DocbaseConnection.applyForInt(DocbaseConnection.java:1247)

at com.documentum.fc.client.impl.docbase.DocbaseApi.parameterizedSave(DocbaseApi.java:768)

at com.documentum.fc.client.DfSysObject$1.evaluate(DfSysObject.java:373)

at com.documentum.fc.client.impl.util.TransactionalFunctorWithRetry.evaluateUnderTransactionWithDeadlockRetry(TransactionalFunctorWithRetry.java:38)

at com.documentum.fc.client.impl.util.TransactionalFunctorWithRetry.evaluate(TransactionalFunctorWithRetry.java:25)

at com.documentum.fc.client.DfSysObject.evaluateUnderTransactionWithDeadlockRetry(DfSysObject.java:929)

at com.documentum.fc.client.DfSysObject.doSaveImpl(DfSysObject.java:401)

at com.documentum.fc.client.DfSysObject.doSave(DfSysObject.java:206)

at com.documentum.fc.client.DfPersistentObject.saveEx(DfPersistentObject.java:912)

at com.documentum.fc.client.DfPersistentObject.save(DfPersistentObject.java:907)

at com.documentum.fc.client.DfDocument___PROXY.save(DfDocument___PROXY.java)

at com.documentum.bpm.rtutil.GenericWorkflowMethod.printStackTrace(GenericWorkflowMethod.java:193)

at com.documentum.bpm.rtutil.GenericWorkflowMethod.execute(GenericWorkflowMethod.java:155)

at com.documentum.bpm.rtutil.GenericWorkflowMethod.execute(GenericWorkflowMethod.java:84)

at com.documentum.bpm.engine.utils.InvokeWfMethodService.execute(InvokeWfMethodService.java:96)

at com.documentum.bpm.engine.model.activity.WorkflowMethodActivityTaskHandler.executeWorkitem(WorkflowMethodActivityTaskHandler.java:43)

at com.documentum.bpm.engine.runtime.AutomaticWorkitemHandler.executeService(AutomaticWorkitemHandler.java:256)

at com.documentum.bpm.engine.runtime.AutomaticWorkitemHandler.execute(AutomaticWorkitemHandler.java:119)

at com.documentum.bpm.engine.runtime.ProcessEngineImpl.recursiveAutomaticWorkitemExecution(ProcessEngineImpl.java:411)

at com.documentum.bpm.engine.runtime.ProcessEngineImpl.recursiveAutomaticWorkitemExecution(ProcessEngineImpl.java:418)

at com.documentum.bpm.engine.runtime.ProcessEngineImpl.executeSync(ProcessEngineImpl.java:292)

at com.documentum.bpm.engine.runtime.ProcessEngineImpl.startWorkflowSynchronously(ProcessEngineImpl.java:245)

at com.documentum.bpm.engine.StatelessEngine.executeInternal(StatelessEngine.java:89)

at com.documentum.bpm.engine.StatelessEngine.execute(StatelessEngine.java:66)

at com.documentum.bps.syncsubproc.StartSubProcessUtils.startStatelessWorkflow(StartSubProcessUtils.java:42)

... 32 more

2013-04-19 14:12:32,198 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/bpm].[DoMethod]] (http-0.0.0.0-9080-6) Servlet.service() for servlet DoMethod threw exception

javax.servlet.ServletException: DfException:: THREAD: http-0.0.0.0-9080-6; MSG: Could not invoke child process <RDR - Store Attachments By Message>; ERRORCODE: ff; NEXT: null