Error while starting the case!

Q&A
1

Hi All,

I am getting an error on Bonita portal when trying to submit a form (starting the process).
Bonita 7.8.3
This is the Tomcat bundle used with Postgres.

On the Studio, everything is working fine when starting the process.

below is the log from the server:

2019-04-06 00:03:22.455 +0300 SEVERE: org.restlet.Component.BonitaRestletApplication Exception or error caught in server resource
org.bonitasoft.engine.exception.BonitaRuntimeException: USERNAME=ebrahim | org.bonitasoft.engine.transaction.STransactionCommitException: bitronix.tm.internal.BitronixRollbackException: transaction failed to prepare: a Bitronix Transaction with GTRID [626F6E6974612D746F6D6361742D62746D2D6E6F646530000000001A212484000016DA], status=ROLLEDBACK, 2 resource(s) enlisted (started Tue Jan 06 04:46:19 AST 1970)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.wrapThrowable(ServerAPIImpl.java:148)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:136)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:86)
at com.sun.proxy.$Proxy74.startProcessWithInputs(Unknown Source)
at org.bonitasoft.web.rest.server.api.bpm.process.ProcessInstantiationResource.instantiateProcess(ProcessInstantiationResource.java:73)
at sun.reflect.GeneratedMethodAccessor128.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.restlet.resource.ServerResource.doHandle(ServerResource.java:508)
at org.restlet.resource.ServerResource.post(ServerResource.java:1341)
at org.restlet.resource.ServerResource.doHandle(ServerResource.java:606)
at org.bonitasoft.web.rest.server.api.resource.CommonResource.doHandle(CommonResource.java:206)
at org.restlet.resource.ServerResource.doNegotiatedHandle(ServerResource.java:662)
at org.restlet.resource.ServerResource.doConditionalHandle(ServerResource.java:348)
at org.restlet.resource.ServerResource.handle(ServerResource.java:1020)
at org.restlet.resource.Finder.handle(Finder.java:236)
at org.restlet.routing.Filter.doHandle(Filter.java:150)
at org.restlet.routing.Filter.handle(Filter.java:197)
at org.restlet.routing.Router.doHandle(Router.java:422)
at org.restlet.routing.Router.handle(Router.java:641)
at org.restlet.routing.Filter.doHandle(Filter.java:150)
at org.restlet.routing.Filter.handle(Filter.java:197)
at org.restlet.routing.Filter.doHandle(Filter.java:150)
at org.restlet.routing.Filter.handle(Filter.java:197)
at org.restlet.routing.Filter.doHandle(Filter.java:150)
at org.restlet.engine.application.StatusFilter.doHandle(StatusFilter.java:140)
at org.restlet.routing.Filter.handle(Filter.java:197)
at org.restlet.routing.Filter.doHandle(Filter.java:150)
at org.restlet.routing.Filter.handle(Filter.java:197)
at org.restlet.engine.CompositeHelper.handle(CompositeHelper.java:202)
at org.restlet.engine.application.ApplicationHelper.handle(ApplicationHelper.java:77)
at org.restlet.Application.handle(Application.java:385)
at org.bonitasoft.web.rest.server.BonitaRestletApplication.handle(BonitaRestletApplication.java:191)
at org.restlet.routing.Filter.doHandle(Filter.java:150)
at org.restlet.routing.Filter.handle(Filter.java:197)
at org.restlet.routing.Router.doHandle(Router.java:422)
at org.restlet.routing.Router.handle(Router.java:641)
at org.restlet.routing.Filter.doHandle(Filter.java:150)
at org.restlet.routing.Filter.handle(Filter.java:197)
at org.restlet.routing.Router.doHandle(Router.java:422)
at org.restlet.routing.Router.handle(Router.java:641)
at org.restlet.routing.Filter.doHandle(Filter.java:150)
at org.restlet.routing.Filter.handle(Filter.java:197)
at org.restlet.engine.CompositeHelper.handle(CompositeHelper.java:202)
at org.restlet.Component.handle(Component.java:408)
at org.restlet.Server.handle(Server.java:507)
at org.restlet.engine.connector.ServerHelper.handle(ServerHelper.java:63)
at org.restlet.engine.adapter.HttpServerHelper.handle(HttpServerHelper.java:143)
at org.restlet.ext.servlet.ServerServlet.service(ServerServlet.java:1117)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.bonitasoft.console.common.server.login.filter.AbstractAuthorizationFilter.doFilter(AbstractAuthorizationFilter.java:61)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.bonitasoft.console.common.server.filter.NoCacheFilter.doFilter(NoCacheFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:728)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:470)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:316)
at org.bonitasoft.console.common.server.page.CustomPageRequestModifier.forwardIfRequestIsAuthorized(CustomPageRequestModifier.java:61)
at org.bonitasoft.console.common.server.page.PageServlet.service(PageServlet.java:91)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.bonitasoft.console.common.server.filter.CacheFilter.proceedWithFiltering(CacheFilter.java:74)
at org.bonitasoft.console.common.server.filter.ExcludingPatternFilter.doFilter(ExcludingPatternFilter.java:37)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.bonitasoft.console.common.server.filter.ExcludingPatternFilter.excludePatternFiltering(ExcludingPatternFilter.java:42)
at org.bonitasoft.console.common.server.filter.ExcludingPatternFilter.doFilter(ExcludingPatternFilter.java:35)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.bonitasoft.console.common.server.login.filter.AbstractAuthorizationFilter.doFilter(AbstractAuthorizationFilter.java:61)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
Caused by: org.bonitasoft.engine.transaction.STransactionCommitException: bitronix.tm.internal.BitronixRollbackException: transaction failed to prepare: a Bitronix Transaction with GTRID [626F6E6974612D746F6D6361742D62746D2D6E6F646530000000001A212484000016DA], status=ROLLEDBACK, 2 resource(s) enlisted (started Tue Jan 06 04:46:19 AST 1970)
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.complete(JTATransactionServiceImpl.java:180)
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:284)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIInTransaction(ServerAPIImpl.java:438)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:272)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:124)
… 110 more
Caused by: bitronix.tm.internal.BitronixRollbackException: transaction failed to prepare: a Bitronix Transaction with GTRID [626F6E6974612D746F6D6361742D62746D2D6E6F646530000000001A212484000016DA], status=ROLLEDBACK, 2 resource(s) enlisted (started Tue Jan 06 04:46:19 AST 1970)
at bitronix.tm.BitronixTransaction.commit(BitronixTransaction.java:283)
at bitronix.tm.BitronixTransactionManager.commit(BitronixTransactionManager.java:143)
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.complete(JTATransactionServiceImpl.java:176)
… 114 more
Caused by: bitronix.tm.internal.BitronixRollbackException: transaction failed during prepare of a Bitronix Transaction with GTRID [626F6E6974612D746F6D6361742D62746D2D6E6F646530000000001A212484000016DA], status=PREPARING, 2 resource(s) enlisted (started Tue Jan 06 04:46:19 AST 1970): resource(s) [jdbc/bonitaDSXA, jdbc/BusinessDataDSXA] threw unexpected exception
at bitronix.tm.twopc.Preparer.throwException(Preparer.java:130)
at bitronix.tm.twopc.Preparer.prepare(Preparer.java:91)
at bitronix.tm.BitronixTransaction.commit(BitronixTransaction.java:275)
… 116 more
Caused by: bitronix.tm.twopc.PhaseException: collected 2 exception(s):
[jdbc/bonitaDSXA - org.postgresql.xa.PGXAException(XAER_RMFAIL) - Error preparing transaction. prepare xid=a Bitronix XID [626F6E6974612D746F6D6361742D62746D2D6E6F646530000000001A212484000016DA : 626F6E6974612D746F6D6361742D62746D2D6E6F646530000000001A212484000016DB]]
[jdbc/BusinessDataDSXA - org.postgresql.xa.PGXAException(XAER_RMFAIL) - Error preparing transaction. prepare xid=a Bitronix XID [626F6E6974612D746F6D6361742D62746D2D6E6F646530000000001A212484000016DA : 626F6E6974612D746F6D6361742D62746D2D6E6F646530000000001A212489000016DC]]
at bitronix.tm.twopc.AbstractPhaseEngine.executePhase(AbstractPhaseEngine.java:104)
at bitronix.tm.twopc.Preparer.prepare(Preparer.java:88)
… 117 more

Thanks for you help.

1 Like
2

Hello,

You should:

  • Check that the max_prepared_transactions is defined in the postgresql.conf
  • Check the error messages generated in the PostGreSQL log files

Details

XAER_RMFAIL means that the RM, at database server side, did send back an error: Error preparing transaction

There is no information in the error messages which would explain why PostGreSQL server failed at the Prepare phase.

PostGreSQL needs to be configured to accept the Prepare phase, which is mandatory for XA transactions.

The max_prepared_transactions property should be added to the postgresql.confconfiguration file. The value must be the same as the one used with the max_connections property.
Please have a look to the Customize RDBMS to make it work with Bonita section in the Database creation and settings to work with Bonita documentation page.

XA transaction

Bonita is using XA transactions. There are ACID-like global transactions which can be used to update two or more databases.

A XA transaction starts with a Prepare phase: the databases (XAresources) that should be accessed during the transaction are enlisted. The final commit (if any) is a 2 phases commit (2PC).

Part of the transaction life-cycle is managed at client side (java) thanks to a transaction manager ™. The other part is managed at database server side thanks to the resource manager (RM).

Bitronix is the TM that had been added to tomcat to enable bonita to use XA transactions.

3

Dear all,
I met exactly the same issue as ebrahim.hammad
I use Bonita Engine 7.8.4 / tomcat / postgres

My process is working perfectly in Studio mode, but in Engine I get “Error while starting the case.” error message and I cannot initiate the process.

Please help… These are my log files from the server today:

bonita.2019-04-22.log
I see 3 SEVERE issues also but I do not understand what I am supposed to do.
Please help!

2019-04-22 02:34:21.202 +0000 SEVERE: org.bonitasoft.engine.api.impl.ServerAPIImpl THREAD_ID=42 | HOSTNAME=bonita-$
2019-04-22 02:34:21.209 +0000 SEVERE: org.bonitasoft.engine.api.impl.ServerAPIImpl THREAD_ID=45 | HOSTNAME=bonita-$
2019-04-22 02:34:21.211 +0000 SEVERE: org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet USERNAME=atsTec$
org.bonitasoft.engine.exception.TenantStatusException: USERNAME=atsTechUser | Tenant with ID 1 is in pause, no API$
at org.bonitasoft.engine.api.impl.ServerAPIImpl.methodCannotBeCalledOnPausedTenant(ServerAPIImpl.java:337)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.checkIsValidModeFor(ServerAPIImpl.java:322)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.checkTenantIsInAValidModeFor(ServerAPIImpl.java:309)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.checkMethodAccessibility(ServerAPIImpl.java:294)
at org.bonitasoft.engine.api.impl.ServerAPIImpl$2.call(ServerAPIImpl.java:430)
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceI$
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIInTransaction(ServerAPIImpl.java:438)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:272)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:124)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:86)
at com.sun.proxy.$Proxy56.searchApplications(Unknown Source)
at org.bonitasoft.web.rest.server.datastore.application.ApplicationDataStore.runSearch(ApplicationDataStor$
at org.bonitasoft.web.rest.server.datastore.application.ApplicationDataStore.search(ApplicationDataStore.j$
at org.bonitasoft.web.rest.server.api.application.APIApplication.search(APIApplication.java:80)
at org.bonitasoft.web.rest.server.framework.API.runSearch(API.java:240)
at org.bonitasoft.web.rest.server.framework.APIServletCall.doGet(APIServletCall.java:172)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:208)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:76)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:251)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.bonitasoft.console.common.server.login.filter.AbstractAuthorizationFilter.doFilter(AbstractAuthoriz$
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

And the catalina log…
catalina.2019-04-22.log

2019-04-22 02:33:57.652 +0000 INFO: java.sql.DatabaseMetaData HHH000262: Table not found: CUSTOMERORDER
2019-04-22 02:33:57.655 +0000 INFO: java.sql.DatabaseMetaData HHH000262: Table not found: CUSTOMERORDER
2019-04-22 02:33:57.657 +0000 INFO: java.sql.DatabaseMetaData HHH000262: Table not found: CUSTOMERORDER
2019-04-22 04:26:51.939 +0000 WARNING: org.apache.tomcat.jdbc.pool.PooledConnection Unable to clear Warnings, conn$
org.postgresql.util.PSQLException: This connection has been closed.
at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:843)
at org.postgresql.jdbc2.AbstractJdbc2Connection.clearWarnings(AbstractJdbc2Connection.java:721)
at org.apache.tomcat.jdbc.pool.PooledConnection.clearWarnings(PooledConnection.java:813)
at org.apache.tomcat.jdbc.pool.ConnectionPool.returnConnection(ConnectionPool.java:934)
at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:100)
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStateme$
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81)
at com.sun.proxy.$Proxy6.close(Unknown Source)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.closeConnection(JobStoreSupport.java:3625)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanupConnection(JobStoreSupport.java:3601)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3819)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTriggers(JobStoreSupport.java:2756)
at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:272)

4

Hello,

The message below means that the default tenant with ID 1 is paused:
Tenant with ID 1 is in pause, no API …

  • Once started use the portal to connect as tenant administrator. The default credentials are install/install.
  • Resume the tenant 1 execution from the portal

Regards,
Jerome

5

Sorry one more log files which I think is linked to the issue…

2019-04-22 02:00:49.643 +0000 SEVERE: bitronix.tm.twopc.AbstractPhaseEngine resource jdbc/bonitaDSXA failed on a B$
org.postgresql.xa.PGXAException: Error preparing transaction. prepare xid=a Bitronix XID [626F6E6974612D746F6D6361$
at org.postgresql.xa.PGXAConnection.prepare(PGXAConnection.java:360)
at bitronix.tm.twopc.Preparer$PrepareJob.execute(Preparer.java:154)
at bitronix.tm.twopc.executor.Job.run(Job.java:72)
at bitronix.tm.twopc.executor.SyncExecutor.submit(SyncExecutor.java:31)
at bitronix.tm.twopc.AbstractPhaseEngine.runJobsForPosition(AbstractPhaseEngine.java:121)
at bitronix.tm.twopc.AbstractPhaseEngine.executePhase(AbstractPhaseEngine.java:85)
at bitronix.tm.twopc.Preparer.prepare(Preparer.java:88)
at bitronix.tm.BitronixTransaction.commit(BitronixTransaction.java:275)
at bitronix.tm.BitronixTransactionManager.commit(BitronixTransactionManager.java:143)
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.complete(JTATransactionServiceImpl.java:176)
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceI$
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIInTransaction(ServerAPIImpl.java:438)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:272)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:124)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:86)
at com.sun.proxy.$Proxy75.startProcessWithInputs(Unknown Source)
at org.bonitasoft.web.rest.server.api.bpm.process.ProcessInstantiationResource.instantiateProcess(ProcessI$
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.restlet.resource.ServerResource.doHandle(ServerResource.java:508)
at org.restlet.resource.ServerResource.post(ServerResource.java:1341)
at org.restlet.resource.ServerResource.doHandle(ServerResource.java:606)
at org.bonitasoft.web.rest.server.api.resource.CommonResource.doHandle(CommonResource.java:206)
at org.restlet.resource.ServerResource.doNegotiatedHandle(ServerResource.java:662)
at org.restlet.resource.ServerResource.doConditionalHandle(ServerResource.java:348)
at org.restlet.resource.ServerResource.handle(ServerResource.java:1020)
at org.restlet.resource.Finder.handle(Finder.java:236)
at org.restlet.routing.Filter.doHandle(Filter.java:150)
at org.restlet.routing.Filter.handle(Filter.java:197)
at org.restlet.routing.Router.doHandle(Router.java:422)
at org.restlet.routing.Router.handle(Router.java:641)
at org.restlet.routing.Filter.doHandle(Filter.java:150)
at org.restlet.routing.Filter.handle(Filter.java:197)
at org.restlet.routing.Filter.doHandle(Filter.java:150)

6

Hi,

Same answer, in other words:

  • If not present, add the max_prepared_transactions property in the postgresql.conf file and set the same value than the one used with max_connections
  • Stop Tomcat server
  • Restart PostGreSQL server
  • Start Tomcat server

If the error messages are still the same then, look in the PostGreSQL log files for the reason why the Prepare phase is failing.

Regards,
Jerome