Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR: XA-Datasource fails while deploying MDM EARs in JBoss/SQLServer Environment with an sqljdbc42 driver
Problem Description
​When Master Data Management (MDM) is deployed in a JBoss/SQL Server environment, there shouldn't be any errors when the datasource connections are correctly defined and the database is accessible. However,​ with the same datasource entries, it is seen that sqljdbc4 driver works and sqljdbc42 driver fails. ​​
Cause
​This issue is ca​used due to an additional property that is mentioned datasource definition:

statistics-enabled="true"/"false"

Solution
To resolve this issue, delete a​ll the instances of the property/attribute ​statistics-enabled, clear cache and restart the server while using the sqljdbc42 jar
More Information
Following is the trace from the logs:

​17:16:29,847 WARN  [org.jboss.jca.core.connectionmanager.listener.TxConnectionListener] (ServerService Thread Pool -- 89) IJ000305: Connection error occured: org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@32ef6274[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@385dc9a4 connection handles=0 lastUse=1549646186901 trackByTx=true pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@4e3d5368 pool internal context=SemaphoreArrayListManagedConnectionPool@5d250b5[pool=jdbc/siperian-cmx_system-ds] xaResource=XAResourceWrapperImpl@59550ab0[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@385dc9a4 pad=false overrideRmValue=false productName=Microsoft SQL Server productVersion=12.00.5546 jndiName=java:jboss/datasources/jdbc/siperian-cmx_system-ds] txSync=null]: javax.transaction.xa.XAException: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot continue the execution because the session is in the kill state.
at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:742)
at com.microsoft.sqlserver.jdbc.SQLServerXAResource.start(SQLServerXAResource.java:774)
at org.jboss.jca.adapters.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:259)
at org.jboss.jca.core.tx.jbossts.XAResourceWrapperImpl.start(XAResourceWrapperImpl.java:215)
at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:646)
at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:407)
at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener$TransactionSynchronization.enlist(TxConnectionListener.java:704)
at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener.enlist(TxConnectionListener.java:350)
at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.managedConnectionReconnected(TxConnectionManagerImpl.java:483)
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.reconnectManagedConnection(AbstractConnectionManager.java:645)
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:513)
at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:143)
at com.delos.cmx.server.datalayer.DataSourceConnectionData.getDatabaseConnection(DataSourceConnectionData.java:156) [siperian-server-10.2.1-SNAPSHOT.jar:10.2.2.0.0.0.6439620]
at com.delos.cmx.server.datalayer.access.DataAccessObjectDirectorForDatabaseAdapter.doCommit(DataAccessObjectDirectorForDatabaseAdapter.java:555) [siperian-server-10.2.1-SNAPSHOT.jar:10.2.2.0.0.0.6439620]
at com.delos.cmx.server.datalayer.access.DataAccessObjectDirectorAdapter.commit(DataAccessObjectDirectorAdapter.java:131) [siperian-server-10.2.1-SNAPSHOT.jar:10.2.2.0.0.0.6439620]
at com.delos.cmx.server.datalayer.access.DataAccessManager.commit(DataAccessManager.java:531) [siperian-server-10.2.1-SNAPSHOT.jar:10.2.2.0.0.0.6439620]
at com.siperian.sam.common.SAManager.validateIdentityByCertificate(SAManager.java:422) [siperian-server-10.2.1-SNAPSHOT.jar:10.2.2.0.0.0.6439620]
at com.siperian.sam.common.SAManager.validateIdentityByCertificate(SAManager.java:359) [siperian-server-10.2.1-SNAPSHOT.jar:10.2.2.0.0.0.6439620]
at com.siperian.sam.common.SAManager.validateIdentity(SAManager.java:351) [siperian-server-10.2.1-SNAPSHOT.jar:10.2.2.0.0.0.6439620]
at com.siperian.sif.server.RequestProcessorAdaptor.initializeDatabaseConnection(RequestProcessorAdaptor.java:445) [siperian-server-10.2.1-SNAPSHOT.jar:10.2.2.0.0.0.6439620]
at com.siperian.sif.server.RequestProcessorAdaptor.preProcess(RequestProcessorAdaptor.java:266) [siperian-server-10.2.1-SNAPSHOT.jar:10.2.2.0.0.0.6439620]
at com.siperian.sif.server.RequestRouter.process(RequestRouter.java:312) [siperian-server-10.2.1-SNAPSHOT.jar:10.2.2.0.0.0.6439620]
at com.siperian.sif.server.RequestRouter.process(RequestRouter.java:275) [siperian-server-10.2.1-SNAPSHOT.jar:10.2.2.0.0.0.6439620]
at com.siperian.sif.server.RequestRouter.process(RequestRouter.java:269) [siperian-server-10.2.1-SNAPSHOT.jar:10.2.2.0.0.0.6439620]
at com.siperian.sif.server.RequestRouter.process(RequestRouter.java:264) [siperian-server-10.2.1-SNAPSHOT.jar:10.2.2.0.0.0.6439620]
at com.siperian.sif.server.ejb.RequestEjbBean.processTxRequired(RequestEjbBean.java:98) [siperian-ejb.jar:10.2.2.0.0.0.6439620]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_152]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_152]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_152]
at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_152]
at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52) [jboss-as-ee-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63) [jboss-as-ee-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63) [jboss-as-ee-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43) [jboss-as-ejb3-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53) [jboss-as-ee-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51) [jboss-as-ejb3-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:280) [jboss-as-ejb3-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:345) [jboss-as-ejb3-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:243) [jboss-as-ejb3-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.as.ejb3.remote.EJBRemoteTransactionPropagatingInterceptor.processInvocation(EJBRemoteTransactionPropagatingInterceptor.java:79) [jboss-as-ejb3-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) [jboss-as-ejb3-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:43) [jboss-as-ejb3-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64) [jboss-as-ejb3-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59) [jboss-as-ejb3-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) [jboss-as-ee-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55) [jboss-as-ejb3-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45) [jboss-as-ee-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185) [jboss-as-ee-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.as.ejb3.remote.LocalEjbReceiver.processInvocation(LocalEjbReceiver.java:249) [jboss-as-ejb3-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:184) [jboss-ejb-client-1.0.30.Final-redhat-1.jar:1.0.30.Final-redhat-1]
at org.jboss.ejb.client.EJBObjectInterceptor.handleInvocation(EJBObjectInterceptor.java:58) [jboss-ejb-client-1.0.30.Final-redhat-1.jar:1.0.30.Final-redhat-1]
at org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:186) [jboss-ejb-client-1.0.30.Final-redhat-1.jar:1.0.30.Final-redhat-1]
at org.jboss.ejb.client.EJBHomeInterceptor.handleInvocation(EJBHomeInterceptor.java:83) [jboss-ejb-client-1.0.30.Final-redhat-1.jar:1.0.30.Final-redhat-1]
at org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:186) [jboss-ejb-client-1.0.30.Final-redhat-1.jar:1.0.30.Final-redhat-1]
at org.jboss.ejb.client.TransactionInterceptor.handleInvocation(TransactionInterceptor.java:42) [jboss-ejb-client-1.0.30.Final-redhat-1.jar:1.0.30.Final-redhat-1]
at org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:186) [jboss-ejb-client-1.0.30.Final-redhat-1.jar:1.0.30.Final-redhat-1]
at org.jboss.ejb.client.ReceiverInterceptor.handleInvocation(ReceiverInterceptor.java:125) [jboss-ejb-client-1.0.30.Final-redhat-1.jar:1.0.30.Final-redhat-1]
at org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:186) [jboss-ejb-client-1.0.30.Final-redhat-1.jar:1.0.30.Final-redhat-1]
at org.jboss.ejb.client.EJBInvocationHandler.sendRequestWithPossibleRetries(EJBInvocationHandler.java:255) [jboss-ejb-client-1.0.30.Final-redhat-1.jar:1.0.30.Final-redhat-1]
at org.jboss.ejb.client.EJBInvocationHandler.doInvoke(EJBInvocationHandler.java:200) [jboss-ejb-client-1.0.30.Final-redhat-1.jar:1.0.30.Final-redhat-1]
at org.jboss.ejb.client.EJBInvocationHandler.doInvoke(EJBInvocationHandler.java:183) [jboss-ejb-client-1.0.30.Final-redhat-1.jar:1.0.30.Final-redhat-1]
at org.jboss.ejb.client.EJBInvocationHandler.invoke(EJBInvocationHandler.java:146) [jboss-ejb-client-1.0.30.Final-redhat-1.jar:1.0.30.Final-redhat-1]
at com.sun.proxy.$Proxy206.processTxRequired(Unknown Source)
at com.siperian.sif.client.EjbSiperianClient._process(EjbSiperianClient.java:122) [siperian-api-10.2.1-SNAPSHOT.jar:10.2.2.0.0.0.6439620]
at com.siperian.sif.client.SiperianClient.process(SiperianClient.java:184) [siperian-api-10.2.1-SNAPSHOT.jar:10.2.2.0.0.0.6439620]
at com.siperian.dsapp.mde.datasource.metadata.SifMetadataService.synchronizeCustomResources(SifMetadataService.java:211)
at com.siperian.dsapp.mde.domain.metadata.MetadataService.synchronizeConfiguration(MetadataService.java:317)
at com.siperian.dsapp.mde.app.MDELifecycleService.deploy(MDELifecycleService.java:76)
at com.siperian.dsapp.mde.app.MDELifecycleService.deploy(MDELifecycleService.java:42)
at com.siperian.dsapp.app.LifecycleService.deploy(LifecycleService.java:24)
at com.siperian.dsapp.app.ApplicationRuntime.deploy(ApplicationRuntime.java:119)
at com.siperian.dsapp.domain.common.DSFManager.deployDSI(DSFManager.java:336)
at com.siperian.dsapp.domain.common.DSFManager.deployOneApplication(DSFManager.java:259)
at com.siperian.dsapp.domain.common.DSFManager.loadJMMs(DSFManager.java:246)
at com.siperian.dsapp.domain.common.DSFManager.start(DSFManager.java:387)
at com.siperian.dsapp.domain.common.DSFManager.startApplication(DSFManager.java:377)
at com.siperian.dsapp.jsf.server.DSUIServlet.startIDD(DSUIServlet.java:116)
at com.siperian.dsapp.jsf.server.DSUIServlet$1.run(DSUIServlet.java:86)
at com.siperian.sif.client.JEEContainer.execute(JEEContainer.java:39) [siperian-api-10.2.1-SNAPSHOT.jar:10.2.2.0.0.0.6439620]
at com.siperian.sif.client.Jboss7.execute(Jboss7.java:37) [siperian-api-10.2.1-SNAPSHOT.jar:10.2.2.0.0.0.6439620]
at com.siperian.sif.client.EjbSiperianClient.execute(EjbSiperianClient.java:251) [siperian-api-10.2.1-SNAPSHOT.jar:10.2.2.0.0.0.6439620]
at com.siperian.dsapp.jsf.server.DSUIServlet.init(DSUIServlet.java:83)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1194)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1100)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3593)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:3802)
at org.jboss.as.web.deployment.WebDeploymentService.doStart(WebDeploymentService.java:163)
at org.jboss.as.web.deployment.WebDeploymentService.access$000(WebDeploymentService.java:61)
at org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:96)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [rt.jar:1.8.0_152]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_152]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [rt.jar:1.8.0_152]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [rt.jar:1.8.0_152]
at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_152]
at org.jboss.threads.JBossThread.run(JBossThread.java:122)

Applies To
Product: MDM Multidomain
Problem Type: Configuration
User Type: Administrator
Project Phase: Implement
Product Version:
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:6/18/2019 12:25 AMID:572715
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)