Fix TIBCO BPM error: RecoveryController – Recovery error javax.transaction.xa.XAException

Error details:

[TxRecoveryThread: java:DataSourceBDS] [ERROR] RecoveryController – Recovery error javax.transaction.xa.XAException at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:709)

This is caused by Post-Installation task to configure transaction recovery has not bee completed.

Procedure 1. Connect to the Oracle database server as a user that has SYSDBA system privilege. For example: SQL > connect sys/password as sysdba 2. Execute the following SQL statements: GRANT SELECT ON sys.dba_pending_transactions TO user GRANT EXECUTE ON sys.dbms_xa TO user GRANT SELECT ON sys.dba_2pc_pending TO user where user is the name of the BPM database user