New Identity Manager Environment has startup error: Failed to initialize the stored procedure xp_sqljdbc_xa_init. The status is: -3. Error:

Products

• CA Identity Suite

Issue/Introduction

We have installed and configured a new Identity Manger Environment and we are getting the following error below on startup.  And note that we have configured that the MS SQL Database has XA Transactions is enabled on the SQL Server and the scripts xa_install.sql and xa_CreateUser.sql has been executed.

 

[9/14/22 8:39:52:649 EDT] 000000ba XATransaction E   J2CA0027E: An exception occurred while invoking start on an XA Resource Adapter from DataSource WPDS, within transaction ID {XidImpl: formatId(57415344), gtrid_length(36), bqual_length(54),
data(000001833c034bf800000001700d2fc85469968c55bdb8bec218a54859bad392409e8399000001833c034bf800000001700d2fc85469968c55bdb8bec218a54859bad392409e8399000000010000000000000000000000000001)} : javax.transaction.xa.XAException: Failed to initialize the stored procedure xp_sqljdbc_xa_init. The status is: -3. Error: "*** SQLJDBC_XA DTC_ERROR Context: FInitializeTransactionManager, state=1, StatusCode:-3 (0xFFFFFFFD) ***"
 at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:426)
 at com.microsoft.sqlserver.jdbc.SQLServerXAResource.start(SQLServerXAResource.java:766)
 at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.start(WSRdbXaResourceImpl.java:1531)

.
<SERVERNAME>1/logs/ffdc/<SERVERNAME>1_81676bdc_22.09.14_08.39.52.6938379519566165513499.txt com.ibm.ejs.j2c.XATransactionWrapper.enlist 546
[9/14/22 8:39:52:701 EDT] 000000ba XATransaction E   J2CA0030E: Method enlist caught javax.transaction.SystemException: XAResource start association error:XAER_RMERR
 at com.ibm.tx.jta.impl.RegisteredResources.startRes(RegisteredResources.java:1088)
 at com.ibm.ws.tx.jta.RegisteredResources.enlistResource(RegisteredResources.java:1161)
 at com.ibm.ws.tx.jta.TransactionImpl.enlistResource(TransactionImpl.java:2289)

Caused by: javax.transaction.xa.XAException: Failed to initialize the stored procedure xp_sqljdbc_xa_init. The status is: -3. Error: "*** SQLJDBC_XA DTC_ERROR Context: FInitializeTransactionManager, state=1, StatusCode:-3 (0xFFFFFFFD) ***"
 at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:426)
 at com.microsoft.sqlserver.jdbc.SQLServerXAResource.start(SQLServerXAResource.java:766)
 at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.start(WSRdbXaResourceImpl.java:1531)
 at com.ibm.ejs.j2c.XATransactionWrapper.start(XATransactionWrapper.java:1479)
 at com.ibm.ws.Transaction.JTA.JTAResourceBase.start(JTAResourceBase.java:157)
 at com.ibm.tx.jta.impl.RegisteredResources.startRes(RegisteredResources.java:1037)

 

 

Environment

Component : IdentityManager

Resolution

The Websphere Application Server was re-started and the cache was cleared which fixed the issue.