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

book

Article ID: 51295

calendar_today

Updated On:

Products

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 SECURITY MISC CODES SINGLE SIGN ON - LEGACY 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: