# Bonita BPM 7.0.1 + Tomcat Bundle + Postgres **URL:** \ **Category:** Q&A\ **Created:** [24 July 2015 17:58 UTC](https://community.ofelia.com/t/bonita-bpm-7-0-1-tomcat-bundle-postgres/6183 "2015-07-24T17:58:44Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![jose.siu](https://avatars.discourse-cdn.com/v4/letter/j/439d5e/32.png) [@jose.siu](https://community.ofelia.com/u/jose.siu)\ **Post date:** [24 July 2015 17:58 UTC](https://community.ofelia.com/t/bonita-bpm-7-0-1-tomcat-bundle-postgres/6183/1 "2015-07-24T17:58:44Z")
Bonita BPM 7.0.1 + Tomcat Bundle + Postgres 9.3 + Windows Server 2012 R2 We have the following error trying to query the data using the BDM REST API: ` {"exception":"class org.bonitasoft.engine.exception.BonitaRuntimeException","message":"USERNAME=bird | org.bonitasoft.engine.transaction.STransactionCommitException: bitronix.tm.internal.BitronixRollbackException: transaction failed to prepare: a Bitronix Transaction with GTRID [626F6E6974612D746F6D6361742D62746D2D6E6F6465300000000000D577C8000003E0], status=ROLLEDBACK, 2 resource(s) enlisted (started Wed Dec 31 19:53:09 PST 1969)"} ` The URL we are trying is: ` http://localhost:8080/bonita/API/bdm/businessData/com.company.model.Proveedor?q=findByBonitaID&p=0&c=1&f=idUsuarioBonita=29 ` We have a similar environment at Dev using Mysql 5.3 and it works fine. In both, mysql and postgres the bonita database and the business\_data are created correctly. Help please. Jose ---
**Author:** ![rubendelvillar](https://avatars.discourse-cdn.com/v4/letter/r/a698b9/32.png) [@rubendelvillar](https://community.ofelia.com/u/rubendelvillar)\ **Post date:** [7 October 2015 18:18 UTC](https://community.ofelia.com/t/bonita-bpm-7-0-1-tomcat-bundle-postgres/6183/2 "2015-10-07T18:18:48Z")
I have the same issue. I’m using Bonita BPM 7.1.0 + Tomcat Bundle + Postgres 9.3 + Windows Server 2012 Error : Caused by: bitronix.tm.internal.BitronixRollbackException: transaction failed to prepare: a Bitronix Transaction with GTRID [626F6E6974612D746F6D6361742D62746D2D6E6F646530000000000094C70300000289], status=ROLLEDBACK, 2 resource(s) enlisted (started Wed Dec 31 20:42:30 CST 1969) at bitronix.tm.BitronixTransaction.commit(BitronixTransaction.java:283) at bitronix.tm.BitronixTransactionManager.commit(BitronixTransactionManager.java:143) at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.commit(JTATransactionServiceImpl.java:227) … 115 more Help please. ---
**Author:** ![yousif\_1](https://dub1.discourse-cdn.com/flex013/user_avatar/community.ofelia.com/yousif_1/32/1341_2.png) [@yousif\_1](https://community.ofelia.com/u/yousif_1)\ **Post date:** [18 July 2018 13:39 UTC](https://community.ofelia.com/t/bonita-bpm-7-0-1-tomcat-bundle-postgres/6183/3 "2018-07-18T13:39:28Z")
Just you need to enable the “max\_prepared\_transactions” on postgresql.conf file if you work by postgresql then restart postgresql, edit the file: /etc/postgresql/9.5/main/postgresql.conf got to “max\_prepared\_transactions” as follows: max\_prepared\_transactions = 30 Good luck. ---
**Author:** ![dijifo](https://avatars.discourse-cdn.com/v4/letter/d/c2a13f/32.png) [@dijifo](https://community.ofelia.com/u/dijifo)\ **Post date:** [6 October 2015 18:18 UTC](https://community.ofelia.com/t/bonita-bpm-7-0-1-tomcat-bundle-postgres/6183/4 "2015-10-06T18:18:54Z")
Did this error get fixed? I have the same using posgres Error : { “exception”: “class org.bonitasoft.engine.exception.BonitaRuntimeException”, “message”: “USERNAME=client1 | org.bonitasoft.engine.transaction.STransactionCommitException: bitronix.tm.internal.BitronixRollbackException: transaction failed to prepare: a Bitronix Transaction with GTRID [626F6E6974612D746F6D6361742D62746D2D6E6F64653000000000005CAB620000076B], status=ROLLEDBACK, 2 resource(s) enlisted (started Wed Dec 31 20:41:13 EST 1969)” } HELP ANYONE!!! ---
**Author:** ![harlynton.castano](https://avatars.discourse-cdn.com/v4/letter/h/bbe5ce/32.png) [@harlynton.castano](https://community.ofelia.com/u/harlynton.castano)\ **Post date:** [23 March 2017 15:24 UTC](https://community.ofelia.com/t/bonita-bpm-7-0-1-tomcat-bundle-postgres/6183/5 "2017-03-23T15:24:13Z")
I have exactly the same issue using Bonita 7.4.3 + Tomcat Bundle + Postgres 9.3 + Windows Server 2012, and I don’t see any answer from the Bonita Staff. ---
**Author:** ![harlynton.castano](https://avatars.discourse-cdn.com/v4/letter/h/bbe5ce/32.png) [@harlynton.castano](https://community.ofelia.com/u/harlynton.castano)\ **Post date:** [23 March 2017 16:07 UTC](https://community.ofelia.com/t/bonita-bpm-7-0-1-tomcat-bundle-postgres/6183/6 "2017-03-23T16:07:18Z")
I finally solved my problem by restarting the postgres service. ---
**Author:** ![jovian.hersemeule\_13](https://avatars.discourse-cdn.com/v4/letter/j/df788c/32.png) [@jovian.hersemeule\_13](https://community.ofelia.com/u/jovian.hersemeule_13)\ **Post date:** [6 May 2019 15:09 UTC](https://community.ofelia.com/t/bonita-bpm-7-0-1-tomcat-bundle-postgres/6183/7 "2019-05-06T15:09:22Z")
On windows server the path is : `C:\Program Files\PostgreSQL\11\data` According to the Bonita documentation : > The value should be at least as large as the value set for max\_connections So you can write `max_prepared_transactions = 100`. Do not forget to remove the `#` at the beginning of the line.