Bonita BPM 7.0.1 + Tomcat Bundle + Postgres

Q&A
1

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

2

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.

3

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.

4

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!!!

5

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.

6

I finally solved my problem by restarting the postgres service.

7

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.