XA Datasource Error for Workflow database: JDBC driver does not support XA

Products

• CA Directory
• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• CA Risk Analytics
• CA Secure Cloud SaaS - Arcot A-OK (WebFort)
• CLOUDMINDER ADVANCED AUTHENTICATION
• CA Secure Cloud SaaS - Advanced Authentication
• CA Secure Cloud SaaS - Identity Management
• CA Secure Cloud SaaS - Single Sign On
• CA Security Command Center
• CA Data Protection (DataMinder)
• CA User Activity Reporting

Issue/Introduction

Description:

The Identity Manager environment is up and running but these error messages appear in the WebLogic server.log:

"JDBC driver does not support XA, hence cannot be a participant in two-phase
commit. To force this participation, set the GlobalTransactionsProtocol
attribute to LoggingLastResource (recommended) or EmulateTwoPhaseCommit for
the Data Source = Database-wf"

Solution:

The jdbc driver you selected is not XA compliant, however WebLogic is looking for an XA driver.

To remedy this error:

• Go to your WebLogic Admin Server console.
• Then follow the pages:
  • Home -> Summary of JDBC Data Sources -> myDatasource ->Transactions.
  • Uncheck: One-Phase Commit
  • Check: Emulate Two-Phase Commit

Environment

Release: CAPUEL99000-12.5-Identity Manager-Blended upgrade to Identity &-Access Mgmt Ente
Component: