1959687 - Incorrect configuration of XA transactions causes different issues | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1959687 - Incorrect configuration of XA transactions causes different issues

Symptom

Issue #1

SAP ME CTC task "SAP ME Configuration for Installation" fails with the following error:

com.visiprise.frame.service.ext.ExtensionExecutionException: com.sap.me.frame.domain.BusinessRuntimeException: javax.ejb.EJBException: nested exception is: com.sap.engine.services.dbpool.exceptions.BaseSQLException: ResourceException occurred in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.connector.exceptions.BaseResourceException: Error in ResourceSet.addAndEnlist("com.sap.engine.services.connector.resource.impl.HandleWrapper@3a9f2f21[com.sap.engine.services.dbpool.cci.ConnectionHandle@3ff62b75](delisted:false) -> com.sap.engine.services.connector.resource.impl.MCEventHandler@6c169a73 --> 1047(locTrSupp:false)").
at com.visiprise.frame.service.ext.GenericServiceExecutionProcess.handleExtensionException(GenericServiceExecutionProcess.java:174)
at com.visiprise.frame.service.ext.GenericServiceExecutionProcess.executeExtension(GenericServiceExecutionProcess.java:158)
at com.visiprise.frame.service.ext.GenericServiceExecutionProcess.executeExtensions(GenericServiceExecutionProcess.java:125)
at com.visiprise.frame.service.ext.GenericServiceExecutionProcess.execute(GenericServiceExecutionProcess.java:97)
at com.visiprise.frame.service.ext.TransactionDecoratorSupport.execute(TransactionDecoratorSupport.java:86)
at com.sap.me.frame.service.BaseTransactionExecutionProcess.execute(BaseTransactionExecutionProcess.java:95)
...
at com.visiprise.frame.service.ext.ServiceExecutionInterceptor.intercept(ServiceExecutionInterceptor.java:44)
at com.sap.me.frame.service.BusinessServiceExecutionInterceptor.intercept(BusinessServiceExecutionInterceptor.java:58)
at com.visiprise.frame.proxy.InterceptorChain.process(InterceptorChain.java:48)
at com.visiprise.frame.proxy.GenericSOProxy.invoke(GenericSOProxy.java:81)
at com.sun.proxy.$Proxy1551.loadInitialData(Unknown Source)
at com.sap.me.plant.impl.SiteConfigurationService.createGlobalSite(SiteConfigurationService.java:397)
...
at com.visiprise.frame.proxy.DefaultInterceptor.intercept(DefaultInterceptor.java:31)
at com.visiprise.frame.proxy.InterceptorChain.process(InterceptorChain.java:48)
at com.visiprise.frame.proxy.ProxyContext.process(ProxyContext.java:67)
at com.visiprise.frame.service.ext.MethodInvocationActivity.execute(MethodInvocationActivity.java:34)
at com.visiprise.frame.service.ext.GenericServiceExecutionProcess.executeActivity(GenericServiceExecutionProcess.java:202)
at com.visiprise.frame.service.ext.GenericServiceExecutionProcess.executeService(GenericServiceExecutionProcess.java:136)
at com.visiprise.frame.service.ext.GenericServiceExecutionProcess.execute(GenericServiceExecutionProcess.java:94)
at com.visiprise.frame.service.ext.TransactionDecoratorSupport.execute(TransactionDecoratorSupport.java:86)
at com.sap.me.frame.service.BaseTransactionExecutionProcess.execute(BaseTransactionExecutionProcess.java:95)
...
at com.visiprise.frame.service.ext.ServiceExecutionInterceptor.intercept(ServiceExecutionInterceptor.java:44)
at com.sap.me.frame.service.BusinessServiceExecutionInterceptor.intercept(BusinessServiceExecutionInterceptor.java:58)
at com.visiprise.frame.proxy.InterceptorChain.process(InterceptorChain.java:48)
at com.visiprise.frame.proxy.GenericSOProxy.invoke(GenericSOProxy.java:81)
at com.sun.proxy.$Proxy1551.createGlobalSite(Unknown Source)
at com.sap.me.ctc.services.idat.GlobalSiteConfiguration.createAndUpdateGlobalSite(GlobalSiteConfiguration.java:191)
...
Caused by: com.sap.me.frame.domain.BusinessRuntimeException: javax.ejb.EJBException: nested exception is: com.sap.engine.services.dbpool.exceptions.BaseSQLException: ResourceException occurred in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.connector.exceptions.BaseResourceException: Error in ResourceSet.addAndEnlist("com.sap.engine.services.connector.resource.impl.HandleWrapper@3a9f2f21[com.sap.engine.services.dbpool.cci.ConnectionHandle@3ff62b75](delisted:false) -> com.sap.engine.services.connector.resource.impl.MCEventHandler@6c169a73 --> 1047(locTrSupp:false)").
at com.sap.me.common.impl.DynamicInvocationService.invoke(DynamicInvocationService.java:76)
...
at com.visiprise.frame.proxy.DefaultInterceptor.intercept(DefaultInterceptor.java:31)
at com.visiprise.frame.proxy.InterceptorChain.process(InterceptorChain.java:48)
at com.visiprise.frame.proxy.ProxyContext.process(ProxyContext.java:67)
at com.visiprise.frame.service.ext.MethodInvocationActivity.execute(MethodInvocationActivity.java:34)
at com.visiprise.frame.service.ext.GenericServiceExecutionProcess.executeActivity(GenericServiceExecutionProcess.java:202)
at com.visiprise.frame.service.ext.GenericServiceExecutionProcess.executeService(GenericServiceExecutionProcess.java:136)
at com.visiprise.frame.service.ext.GenericServiceExecutionProcess.execute(GenericServiceExecutionProcess.java:94)
at com.visiprise.frame.service.ext.TransactionDecoratorSupport.execute(TransactionDecoratorSupport.java:86)
at com.sap.me.frame.service.BaseTransactionExecutionProcess.execute(BaseTransactionExecutionProcess.java:95)
...
at com.visiprise.frame.service.ext.ServiceExecutionInterceptor.intercept(ServiceExecutionInterceptor.java:44)
at com.sap.me.frame.service.BusinessServiceExecutionInterceptor.intercept(BusinessServiceExecutionInterceptor.java:58)
at com.visiprise.frame.proxy.InterceptorChain.process(InterceptorChain.java:48)
at com.visiprise.frame.proxy.GenericSOProxy.invoke(GenericSOProxy.java:81)
at com.sun.proxy.$Proxy1666.invoke(Unknown Source)
at com.sap.me.common.impl.XmlInvocationService.invokeConfigLoad(XmlInvocationService.java:682)
at com.sap.me.common.impl.XmlInvocationService.loadApplicationConfiguration(XmlInvocationService.java:166)
...
at com.visiprise.frame.proxy.DefaultInterceptor.intercept(DefaultInterceptor.java:31)
at com.visiprise.frame.proxy.InterceptorChain.process(InterceptorChain.java:48)
at com.visiprise.frame.proxy.ProxyContext.process(ProxyContext.java:67)
at com.visiprise.frame.service.ext.MethodInvocationActivity.execute(MethodInvocationActivity.java:34)
at com.visiprise.frame.service.ext.GenericServiceExecutionProcess.executeActivity(GenericServiceExecutionProcess.java:202)
at com.visiprise.frame.service.ext.GenericServiceExecutionProcess.executeService(GenericServiceExecutionProcess.java:136)
at com.visiprise.frame.service.ext.GenericServiceExecutionProcess.execute(GenericServiceExecutionProcess.java:94)
at com.visiprise.frame.service.ext.TransactionDecoratorSupport.execute(TransactionDecoratorSupport.java:86)
at com.sap.me.frame.service.BaseTransactionExecutionProcess.execute(BaseTransactionExecutionProcess.java:95)
...
at com.visiprise.frame.service.ext.ServiceExecutionInterceptor.intercept(ServiceExecutionInterceptor.java:44)
at com.sap.me.frame.service.BusinessServiceExecutionInterceptor.intercept(BusinessServiceExecutionInterceptor.java:58)
at com.visiprise.frame.proxy.InterceptorChain.process(InterceptorChain.java:48)
at com.visiprise.frame.proxy.GenericSOProxy.invoke(GenericSOProxy.java:81)
at com.sun.proxy.$Proxy1546.loadApplicationConfiguration(Unknown Source)
at com.sap.me.plant.impl.ConfigDataLoader.execute(ConfigDataLoader.java:99)
at com.sap.me.plant.impl.ConfigDataLoader.execute(ConfigDataLoader.java:73)
at com.visiprise.frame.service.ext.GenericServiceExecutionProcess.executeActivity(GenericServiceExecutionProcess.java:202)
at com.visiprise.frame.service.ext.GenericServiceExecutionProcess.executeExtension(GenericServiceExecutionProcess.java:153)
... 92 more
Caused by: javax.ejb.EJBException: nested exception is: com.sap.engine.services.dbpool.exceptions.BaseSQLException: ResourceException occurred in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.connector.exceptions.BaseResourceException: Error in ResourceSet.addAndEnlist("com.sap.engine.services.connector.resource.impl.HandleWrapper@3a9f2f21[com.sap.engine.services.dbpool.cci.ConnectionHandle@3ff62b75](delisted:false) -> com.sap.engine.services.connector.resource.impl.MCEventHandler@6c169a73 --> 1047(locTrSupp:false)").
at com.sap.me.frame.AbstractDataSource.getDBConnection(AbstractDataSource.java:418)
at com.sap.me.frame.AbstractDataSource.executeQuery(AbstractDataSource.java:142)
at com.sap.me.frame.BaseDataSource.executeQuery(BaseDataSource.java:182)
at com.sap.me.frame.BaseDataSource.recordExists(BaseDataSource.java:798)
at com.sap.me.frame.AuditLogHandler.createAL(AuditLogHandler.java:129)
at com.sap.me.frame.AuditLogHandler.performAuditLogWork(AuditLogHandler.java:953)
at com.sap.me.frame.dao.AuditLogListener.performAuditLog(AuditLogListener.java:62)
at com.sap.me.frame.dao.AuditLogListener.afterCreate(AuditLogListener.java:29)
at com.sap.me.frame.dao.CompositeLifeCycleListener.afterCreate(CompositeLifeCycleListener.java:83)
at com.sap.me.frame.dao.ProductionDataAccessService.create(ProductionDataAccessService.java:193)
at com.sap.me.frame.dao.DomainDataAccessService.create(DomainDataAccessService.java:65)
at com.sap.me.frame.dao.DomainDataAccessService.create(DomainDataAccessService.java:30)
at com.sap.me.frame.domain.DefaultDomainService.create(DefaultDomainService.java:96)
at com.sap.me.activity.impl.ExtensionConfigurationService.createExtensionPoint(ExtensionConfigurationService.java:242)
at com.sap.me.activity.impl.ExtensionConfigurationService.createExtensionLocal(ExtensionConfigurationService.java:961)
at com.sap.me.activity.impl.ExtensionConfigurationService.createExtensionByCreateExtensionRequest(ExtensionConfigurationService.java:229)
...
at com.visiprise.frame.proxy.DefaultInterceptor.intercept(DefaultInterceptor.java:31)
at com.visiprise.frame.proxy.InterceptorChain.process(InterceptorChain.java:48)
at com.visiprise.frame.proxy.ProxyContext.process(ProxyContext.java:67)
at com.visiprise.frame.service.ext.MethodInvocationActivity.execute(MethodInvocationActivity.java:34)
at com.visiprise.frame.service.ext.GenericServiceExecutionProcess.executeActivity(GenericServiceExecutionProcess.java:202)
at com.visiprise.frame.service.ext.GenericServiceExecutionProcess.executeService(GenericServiceExecutionProcess.java:136)
at com.visiprise.frame.service.ext.GenericServiceExecutionProcess.execute(GenericServiceExecutionProcess.java:94)
at com.visiprise.frame.service.ext.TransactionDecoratorSupport.execute(TransactionDecoratorSupport.java:86)
at com.sap.me.frame.service.BaseTransactionExecutionProcess.execute(BaseTransactionExecutionProcess.java:95)
...
at com.visiprise.frame.service.ext.ServiceExecutionInterceptor.intercept(ServiceExecutionInterceptor.java:44)
at com.sap.me.frame.service.BusinessServiceExecutionInterceptor.intercept(BusinessServiceExecutionInterceptor.java:58)
at com.visiprise.frame.proxy.InterceptorChain.process(InterceptorChain.java:48)
at com.visiprise.frame.proxy.GenericSOProxy.invoke(GenericSOProxy.java:81)
...
at com.sap.me.common.impl.DynamicInvocationService.invoke(DynamicInvocationService.java:64)

Issue #2

SAP ME CTC task "SAP ME Configuration for Upgrade" fails with the following error:

Error: com.sap.me.frame.domain.BusinessRuntimeException: javax.ejb.EJBException: nested exception is: com.sap.engine.services.dbpool.exceptions.BaseSQLException:
ResourceException occurred in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.connector.exceptions.BaseResourceException:
Error in ResourceSet.addAndEnlist("com.sap.engine.services.connector.resource.impl.HandleWrapper@1c50eb36[com.sap.engine.services.dbpool.cci.ConnectionHandle@51c9df05](delisted:false) -> com.sap.engine.services.connector.resource.impl.MCEventHandler@7836bd5b --> 0(locTrSupp:false)"). 

Issue #3

RMA SFC Receipt fails with the following error:

com.sap.engine.services.dbpool.exceptions.BaseSQLException: ResourceException occurred in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.connector.exceptions.BaseResourceException: Error in ResourceSet.addAndEnlist("com.sap.engine.services.connector.resource.impl.HandleWrapper@63afed6[com.sap.engine.services.dbpool.cci.ConnectionHandle@5f427d76](delisted:false) -> com.sap.engine.services.connector.resource.impl.MCEventHandler@1c7d3196 --> 7(locTrSupp:false)").
                at com.sap.engine.services.dbpool.cci.ConnectionFactoryImpl.getConnection(ConnectionFactoryImpl.java:59)
                at com.sap.me.frame.BaseDataSource.getDBConnection(BaseDataSource.java:201)
                at com.sap.me.frame.BaseDataSource.executeQuery(BaseDataSource.java:381)
                at com.sap.me.frame.BaseDataSource.executeQuery(BaseDataSource.java:283)
                at com.sap.me.demand.RMANumberBOBean.addSFC(RMANumberBOBean.java:826)
...
                at $Proxy405.addSFC(Unknown Source)
                at com.sap.me.demand.RMASFCReceiptApplicationBean.done(RMASFCReceiptApplicationBean.java:232)
...
                at com.sap.me.coral.core.controller.EJBServiceProxy.invoke(EJBServiceProxy.java:111)
                at $Proxy1526.done(Unknown Source)
                at com.sap.me.demand.client.RMASFCReceiptCommand$DoneCommand.handleCmd(RMASFCReceiptCommand.java:143)
                at com.sap.me.coral.core.command.AbstractCommand.execute(AbstractCommand.java:217)
                at com.sap.me.coral.core.controller.ActivityServlet.processExistingApplicationRequest(ActivityServlet.java:519)
                at com.sap.me.coral.core.controller.ActivityServlet.handleRequest(ActivityServlet.java:137)
                at com.sap.me.coral.core.controller.BaseServlet.processRequest(BaseServlet.java:122)
                at com.sap.me.coral.core.controller.BaseServlet.doPost(BaseServlet.java:228)
...
                at com.sap.me.alarm.client.RTEDSessionInvalidateFilter.doFilter(RTEDSessionInvalidateFilter.java:66)
                at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.doFilter(FilterChainImpl.java:73)
                at com.sap.me.coral.core.filter.ActivityAuthenticationFilter.doFilter(ActivityAuthenticationFilter.java:868)
                at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.doFilter(FilterChainImpl.java:73)
                at com.sap.me.security.client.SecurityFilter.doFilter(SecurityFilter.java:151)
                at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.doFilter(FilterChainImpl.java:73)
                at com.sap.me.coral.core.filter.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:57)
...
Caused by: com.sap.engine.services.connector.exceptions.BaseResourceException: Error in ResourceSet.addAndEnlist("com.sap.engine.services.connector.resource.impl.HandleWrapper@63afed6[com.sap.engine.services.dbpool.cci.ConnectionHandle@5f427d76](delisted:false) -> com.sap.engine.services.connector.resource.impl.MCEventHandler@1c7d3196 --> 7(locTrSupp:false)").
                at com.sap.engine.services.connector.jca.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:340)
                at com.sap.engine.services.connector.jca.ShareableConnectionManager.allocateConnection(ShareableConnectionManager.java:54)
                at com.sap.engine.services.dbpool.cci.ConnectionFactoryImpl.getConnection(ConnectionFactoryImpl.java:51)
                ... 111 more
Caused by: com.sap.engine.services.ts.exceptions.BaseSystemException: Cannot enlist resource:com.sap.sql.jdbc.vendor.VendorXAResource@4c4ae00 into jta transaction because of XAException from xaResource.start(xid, XAResource.TMNOFLAGS)
                at com.sap.engine.services.ts.jta.impl.TransactionImpl.enlistResource(TransactionImpl.java:604)
                at com.sap.engine.services.connector.resource.impl.ResourceSetImpl.addAndEnlist(ResourceSetImpl.java:327)
                at com.sap.engine.services.connector.jca.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:337)
                ... 113 more
Caused by: javax.transaction.xa.XAException: com.microsoft.sqlserver.jdbc.SQLServerException: Failed to create the XA control connection. Error: "Could not find stored procedure 'master..xp_sqljdbc_xa_init_ex'."
                at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:642)
                at com.microsoft.sqlserver.jdbc.SQLServerXAResource.start(SQLServerXAResource.java:674)
                at com.sap.sql.jdbc.vendor.VendorXAResource.start(VendorXAResource.java:66)
                at com.sap.engine.services.ts.jta.impl.XAResourceWrapper.<init>(XAResourceWrapper.java:46)
                at com.sap.engine.services.ts.jta.impl.RMMap.enlistResource(RMMap.java:125)
                at com.sap.engine.services.ts.jta.impl.TransactionImpl.enlistResource(TransactionImpl.java:594) 


Read more...

Environment

SAP ME WIP and ODS databases running on MS SQL Server.

Product

SAP Manufacturing Execution 15.0 ; SAP Manufacturing Execution 15.1 ; SAP Manufacturing Execution 2.1B ; SAP Manufacturing Execution 2.2 ; SAP Manufacturing Execution 3.0 ; SAP Manufacturing Execution 3.1 ; SAP Manufacturing Execution 3.2 ; SAP Manufacturing Execution 4.0 ; SAP Manufacturing Execution 4.1 ; SAP Manufacturing Execution 4.2 ; SAP Manufacturing Execution 4.3 ; SAP Manufacturing Execution 5.1 ; SAP Manufacturing Execution 5.2 ; SAP Manufacturing Execution 6.0 ; SAP Manufacturing Execution 6.1

Keywords

KBA , MFG-ME-IM , Installation and Migration , MFG-ME , SAP Manufacturing Execution , MFG-ME-PRD , Production Activities , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.