Still getting an XA transactions error even after enabling XA transactions

Discussion created by Andy_Thompson Employee on Jul 19, 2012
CA Process Automation Tech Tip by Andy Thompson, Sr. Support Engineer, July 19, 2012

XA transactions are enabled at the database level (following the install guide) but errors occur when logging into ITPAM. Also the following is seen in the c2o.log:

javax.transaction.xa.XAException: Failed to create the XA control connection. Error: "Could not find stored procedure 'master..xp_sqljdbc_xa_init_ex'."

This can occur when the driver installed and the database and not both 32 or 64 bit. See the following tech doc for more information: