Unable to create SAP ME 6.1 Global site

[Former Member]

We are facing issue while performing "SAP ME Configuration for Installation" in SAP Netweaver.

Please find below the detailed error trace

Exception Class: com.visiprise.frame.service.ext.ExtensionExecutionException

Exception Message: 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)").

Stack Trace

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 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at com.sap.engine.services.ejb3.runtime.impl.RequestInvocationContext.proceedFinal(RequestInvocationContext.java:47)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:166)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatesTransition.invoke(Interceptors_StatesTransition.java:19)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Resource.invoke(Interceptors_Resource.java:47)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.doWorkWithAttribute(Interceptors_Transaction.java:37)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.invoke(Interceptors_Transaction.java:21)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_MethodRetry.invoke(Interceptors_MethodRetry.java:46)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:189)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatelessInstanceGetter.invoke(Interceptors_StatelessInstanceGetter.java:16)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_SecurityCheck.invoke(Interceptors_SecurityCheck.java:25)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_ExceptionTracer.invoke(Interceptors_ExceptionTracer.java:17)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.DefaultInvocationChainsManager.startChain(DefaultInvocationChainsManager.java:138)

at com.sap.engine.services.ejb3.runtime.impl.DefaultEJBProxyInvocationHandler.invoke(DefaultEJBProxyInvocationHandler.java:164)

at com.sun.proxy.$Proxy887.execute(Unknown Source)

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 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

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 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at com.sap.engine.services.ejb3.runtime.impl.RequestInvocationContext.proceedFinal(RequestInvocationContext.java:47)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:166)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatesTransition.invoke(Interceptors_StatesTransition.java:19)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Resource.invoke(Interceptors_Resource.java:47)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.doWorkWithAttribute(Interceptors_Transaction.java:37)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.invoke(Interceptors_Transaction.java:21)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_MethodRetry.invoke(Interceptors_MethodRetry.java:46)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:189)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatelessInstanceGetter.invoke(Interceptors_StatelessInstanceGetter.java:16)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_SecurityCheck.invoke(Interceptors_SecurityCheck.java:25)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_ExceptionTracer.invoke(Interceptors_ExceptionTracer.java:17)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.DefaultInvocationChainsManager.startChain(DefaultInvocationChainsManager.java:138)

at com.sap.engine.services.ejb3.runtime.impl.DefaultEJBProxyInvocationHandler.invoke(DefaultEJBProxyInvocationHandler.java:164)

at com.sun.proxy.$Proxy887.execute(Unknown Source)

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)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at com.sap.tc.lm.ctc.provider.javaServiceProvider.JavaMethodExecuter.invoke(JavaMethodExecuter.java:259)

at com.sap.tc.lm.ctc.provider.javaServiceProvider.JavaServiceExecuter.executeService(JavaServiceExecuter.java:86)

at com.sap.tc.lm.ctc.cul.broker.BrokerServiceExecuter.executeService(BrokerServiceExecuter.java:59)

at com.sap.tc.lm.ctc.cul.serviceimpl.executor.CULServiceExecutor.executeService(CULServiceExecutor.java:36)

at com.sap.tc.lm.ctc.cul.serviceimpl.process.InvokeServiceControllerDefault.execute(InvokeServiceControllerDefault.java:133)

at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.remoteOrLocalExecution(ProcessControllerImpl.java:740)

at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.execute(ProcessControllerImpl.java:286)

at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessExecuter.run(ProcessExecuter.java:156)

at java.lang.Thread.run(Thread.java:743)

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 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

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 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at com.sap.engine.services.ejb3.runtime.impl.RequestInvocationContext.proceedFinal(RequestInvocationContext.java:47)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:166)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatesTransition.invoke(Interceptors_StatesTransition.java:19)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Resource.invoke(Interceptors_Resource.java:47)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.doWorkWithAttribute(Interceptors_Transaction.java:37)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.invoke(Interceptors_Transaction.java:21)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_MethodRetry.invoke(Interceptors_MethodRetry.java:46)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:189)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatelessInstanceGetter.invoke(Interceptors_StatelessInstanceGetter.java:16)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_SecurityCheck.invoke(Interceptors_SecurityCheck.java:25)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_ExceptionTracer.invoke(Interceptors_ExceptionTracer.java:17)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.DefaultInvocationChainsManager.startChain(DefaultInvocationChainsManager.java:138)

at com.sap.engine.services.ejb3.runtime.impl.DefaultEJBProxyInvocationHandler.invoke(DefaultEJBProxyInvocationHandler.java:164)

at com.sun.proxy.$Proxy887.execute(Unknown Source)

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 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

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 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at com.sap.engine.services.ejb3.runtime.impl.RequestInvocationContext.proceedFinal(RequestInvocationContext.java:47)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:166)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatesTransition.invoke(Interceptors_StatesTransition.java:19)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Resource.invoke(Interceptors_Resource.java:47)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.doWorkWithAttribute(Interceptors_Transaction.java:37)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.invoke(Interceptors_Transaction.java:21)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_MethodRetry.invoke(Interceptors_MethodRetry.java:46)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:189)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatelessInstanceGetter.invoke(Interceptors_StatelessInstanceGetter.java:16)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_SecurityCheck.invoke(Interceptors_SecurityCheck.java:25)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_ExceptionTracer.invoke(Interceptors_ExceptionTracer.java:17)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.DefaultInvocationChainsManager.startChain(DefaultInvocationChainsManager.java:138)

at com.sap.engine.services.ejb3.runtime.impl.DefaultEJBProxyInvocationHandler.invoke(DefaultEJBProxyInvocationHandler.java:164)

at com.sun.proxy.$Proxy887.execute(Unknown Source)

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 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

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 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at com.sap.engine.services.ejb3.runtime.impl.RequestInvocationContext.proceedFinal(RequestInvocationContext.java:47)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:166)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatesTransition.invoke(Interceptors_StatesTransition.java:19)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Resource.invoke(Interceptors_Resource.java:47)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.doWorkWithAttribute(Interceptors_Transaction.java:37)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.invoke(Interceptors_Transaction.java:21)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_MethodRetry.invoke(Interceptors_MethodRetry.java:46)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:189)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatelessInstanceGetter.invoke(Interceptors_StatelessInstanceGetter.java:16)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_SecurityCheck.invoke(Interceptors_SecurityCheck.java:25)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_ExceptionTracer.invoke(Interceptors_ExceptionTracer.java:17)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.DefaultInvocationChainsManager.startChain(DefaultInvocationChainsManager.java:138)

at com.sap.engine.services.ejb3.runtime.impl.DefaultEJBProxyInvocationHandler.invoke(DefaultEJBProxyInvocationHandler.java:164)

at com.sun.proxy.$Proxy887.execute(Unknown Source)

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.$Proxy1669.createExtensionByCreateExtensionRequest(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:57)

at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:260)

at java.beans.Statement.invokeInternal(Statement.java:239)

at java.beans.Statement.access$000(Statement.java:39)

at java.beans.Statement$2.run(Statement.java:140)

at java.security.AccessController.doPrivileged(Native Method)

at java.beans.Statement.invoke(Statement.java:137)

at java.beans.Expression.getValue(Expression.java:98)

at com.sap.me.common.impl.DynamicInvocationService.invoke(DynamicInvocationService.java:64)

... 184 more

[sergiy_katerinich · Accepted solution]

Hi,

It looks as if you have WIP/ODS on MSSQL but they are not configured properly. Maybe XA is not set up. Please check section 3.1.2 of SAP ME Component Installation Guide.

Regards,

Sergiy

[Former Member · Accepted solution]

Dear Sergiy,

Yes i have WIP/ODS on MS SQL Server 2008. I did follow 3.1.2 of SAP ME Component Installation guide to configure XA. But still facing the same error.

Kind Regards

Suhas

[sergiy_katerinich · Accepted solution]

The execution fails at the attempt to create Audit Log record. You can try to login to WIP database with WIP user by means of MSSQL Management Studio and execute "SELECT count(*) FROM AL_SITE". If it fails, then please check if your WIP has valid views to ODS tables (they should have been created by the previous CTC task).

Check if you ever have AL_* tables in ODS database.

[alexander_teslyuk · Accepted solution]

Also, make sure you configured DB and DB users according to SAP Note 1405261.

[Former Member · Accepted solution]

Dear Sergiy,

I tried the above steps and was able to run the query as wip user with output count as '0'.

WIP has all the views with dbo.AL_* , dbo.AR_* , dbo.ODS_*

In the ODS database we found tables dbo.AL_* , dbo.AR_* , dbo.ODS_* and also dbo.TRANSACTION_LOG*

Any other help will be appreciated

Regards

Suahs

[Former Member · Accepted solution]

Dear Alexander,

We have followed the steps mentioned in the above note.

Since this is test environment we have setup WIP and ODS on the same server.

Regards

Suhas

[sergiy_katerinich · Accepted solution]

Hi Suhas,

Please let me know if you are testing this on the latest ME 6.1.3.x. There were some changes after CTC 6.1.3.0 to fix issues with db links and views.

Regards,

Sergiy

[sergiy_katerinich · Accepted solution]

Another point to check is step 4 of section 4.1.3 which is usually skipped by users. After that, before proceeding with section 4.1.4, it is good to check if me~ear application is up and running and all *Pool resources are in green state.

Somethings, re-starting me~ear helps (even if all statuses are green).

[sergiy_katerinich · Accepted solution]

In fact, the check of connection between WIP and ODS above is not enough for proving the correctness of installation of XA driver - sometimes it does silently fail. Please refer to this MSDN blog. Before proceeding with the instructions from the blog, you can simply repeat all the steps of configuring XA transaction as described within section 3.1.2 of SAP ME Component Installation guide - this will just overwrite the current XA setup.

[Former Member · Accepted solution]

Thanks Sergiy for all your help.

But we are facing another issue now. We did complete the step "SAP ME Configuration for Installation" in SAP Netweaver sucessfully. But when we login to the SAP ME site using site_admin the activity groups do not load by the splash screen or the welcome page loads sucessfully.

we get the below error in log\system server_00 file

#2.0 #2013 10 18 19:46:09:344#+0530#Error#/System/Server/WebRequests#

com.sap.ASJ.web.000137##sap.com/me~ear#C000AC1D32B7007600000000000018F4#26990850000000004#sap.com/me~ear#com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl#235453#7##D5A72C3A37FF11E392D20000019BD902#898ef8de37ff11e3826d0000019bd902#898ef8de37ff11e3826d0000019bd902#0#Thread[HTTP Worker [@2087614803],5,Dedicated_Application_Thread]#Plain#com.sap.engine.services.monitor.mbeans.MonitorResourceBundle#

Cannot process an HTTP request to servlet [jsp] in [manufacturing] web application.

Regards

Suhas

[sergiy_katerinich · Accepted solution]

It would be good if you share the solution for the original issue and post the new issue to a separate thread. Please add records from defaultTrace for the new issue. You might find ME Troubleshooting Guide useful in this situation.

[Former Member · Accepted solution]

Dear Sergiy,

I changed the sqljdbc_xa.dll file and repeated all the steps of configuring XA transaction as described within section 3.1.2 of SAP ME Component Installation guide and resolved the issue.

Thanks.

Kind Regards

Suhas