1959687 - Incorrect configuration of XA transactions causes different issues

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)

• SAP ME WIP and ODS databases running on MS SQL Server.
• SAP Manufacturing Execution 15.1
• SAP Manufacturing Execution 15.2
• SAP Manufacturing Execution 15.3
• SAP Manufacturing Execution 15.4
• SAP Manufacturing Execution 15.5

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