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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s