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.jboss.jca.core.connectionmanager.listener.TxConnectionListener@1779ca27[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@3669dcf connection handles=0 lastUse=1649856284953 trackByTx=true pool=org.jboss.jca.core.connectionmanager.pool.strategy.PoolBySubject@2c721016 mcp=SemaphoreArrayListManagedConnectionPool@76d19335[pool=WPDS] xaResource=XAResourceWrapperImpl@32330791[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@3669dcf 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)

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

Environment

Identity Governance 14.3.x

SQL Server as database

Cause

It is missing permission in the SQL Server

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