Not able to update the Workpoint processes from Identity Governance UI

Products

• CA Identity Suite

Issue/Introduction

When trying to update the Workpoint processes it generates an error in the Identity Governance log file

-------------------------

WARN  [org.jboss.jca.core.connectionmanager.listener.TxConnectionListener] (Timer-4) IJ000305: Connection error occured: org[email protected]1779ca27[state=NORMAL managed [email protected]69dcf connection handles=0 lastUse=1649856284953 trackByTx=true pool=o[email protected]2c721016 [email protected][pool=WPDS] [email protected][[email protected]69dcf pad=false overrideRmValue=null productName=Microsoft SQL Server productVersion=13.00.5698 jndiName=java:/jdbc/WPDS] txSync=null]: javax.transaction.xa.XAException: com.microsoft.sqlserver.jdbc.SQLServerException: Failed to create the XA control connection. Error: "The EXECUTE permission was denied on the object 'xp_sqljdbc_xa_init_ex', database 'master', schema 'dbo'."
 at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:732)

-------------------------

Cause

It is missing permission in the SQL Server

Environment

Identity Governance 14.3.x

SQL Server as database

Resolution

Grant permission to the user as follows.

Example:
use [master]
GO
GRANT EXECUTE ON [dbo].[xp_sqljdbc_xa_start] TO [UserName]

Additional Information

https://www.ibm.com/support/pages/error-when-upgrading-process-engine-execute-permission-was-denied-object-xpsqljdbcxastartdatabase-master-schema-dbo

https://stackoverflow.com/questions/4043859/exception-with-ms-sql-server-jdbc-and-xa-transactions