Identity Governance Missing Essential Workpoint Process
search cancel

Identity Governance Missing Essential Workpoint Process


Article ID: 187834


Updated On:


CA Identity Manager CA Identity Governance CA Identity Portal CA Identity Suite


When setting up the universe, to include IDM, I saw the following error in the connectivity tab: "The Workpoint adapter is not responding, perform a Workpoint checkup"

 I went to perform the Workpoint checkup and I get this error:

The following message was seen in the logs:

WARN  [com.######] (default task-50) <######>: TransactionImple.enlistResource - XAResource.start returned: XAException.XAER_RMERR for < formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:#########:321, node_name=1, branch_uid=0:############, subordinatenodename=null, eis_name=java:/jdbc/WPDS >: javax.transaction.xa.XAException: Failed to create the XA control connection. Error: "The connection is closed."

When reviewing the WPDS database, there were no tables.


Release : 14.X



If you are using a SQL database server, XA Transactions must be enabled prior to installing Identity Governance. 
If XA transactions are enabled, but still no tables exists in the WPDS database, ensure you have the correct permissions on the user that is connecting to the database.  Once correct permissions are granted, restart Identity Governance and the tables will be created. 
The correct permissions are as follows:
  • System Admin (SA) — Required during install if the installer is creating the database.
  • Dbo — Required during install if the database administrator manually created the database before install.
  • Datareader, Datawriter, BulkAdmin, DDLAdmin — minimum required privileges after installation. 
What if I didn't install with XA transactions and my permissions were incorrect?
Perform the following steps to correct the issue:
  1. Configure XA transactions on the database side
  2. Set the database user as SA. 
  3. Once we set the user to SA the WPDS tables will be built successfully. I do recommend restarting Identity Governance.
  4. Roll back database permissions to either DBO or datareader, datawriter, BulkAdmin, DDLAdmin

And also to grant permissions to a specific user to participate in distributed transactions with the JDBC driver, add the user to the SqlJDBCXAUser role. Please refers to

Additional Information