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)
-------------------------
Identity Governance 14.3.x
SQL Server as database
It is missing permission in the SQL Server
Grant permission to the user as follows.
Example:
use [master]
GO
GRANT EXECUTE ON [dbo].[xp_sqljdbc_xa_start] TO [UserName]
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