Hi Maduranga, It worked. Thanks for the help.
Thanks, Harshan Liyanage Software Engineer Mobile: *+94724423048* Email: [email protected] Blog : http://harshanliyanage.blogspot.com/ *WSO2, Inc. :** wso2.com <http://wso2.com/>* lean.enterprise.middleware. On Wed, Dec 9, 2015 at 12:15 PM, Maduranga Siriwardena <[email protected]> wrote: > Hi Harshan, > > Same kind of issue reported in [1]. Reason for this and a workaround is > provided in [2]. Can you please try the workaround provided in [2]. > > [1] https://wso2.org/jira/browse/REGISTRY-2276 > [2] > https://wso2.org/jira/browse/REGISTRY-2276?focusedCommentId=89279&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-89279 > > Thanks, > Maduranga. > > On Wed, Dec 9, 2015 at 11:57 AM, Harshan Liyanage <[email protected]> > wrote: > >> Hi, >> >> I have configured EMM server to run on Postgres database >> (postgresql-9.4). I'm getting the below exception mentioning that "Cannot >> change transaction isolation level in the middle of a transaction" when I >> try to get the service-provider information using getServiceProvider method >> defined in ApplicationManagementService. I'm using the carbon-identity >> 5.0.3 components. >> >> In some cases I'm getting "Error while loading service providers : Error >> when getting a database connection object from the Identity data source." >> error message when I try to list the service-providers in carbon console. >> But in that scenario there's no error trace in backend. >> >> Any assistance on this issue is highly appreciated. >> >> [2015-12-09 11:41:03,543] ERROR >> {org.wso2.carbon.dynamic.client.web.impl.RegistrationServiceImpl} - Error >> occurred while registering client 'emm' >> org.wso2.carbon.dynamic.client.registration.DynamicClientRegistrationException: >> Can not create OAuth application : emm >> at >> org.wso2.carbon.dynamic.client.registration.impl.DynamicClientRegistrationServiceImpl.registerOAuthApplication(DynamicClientRegistrationServiceImpl.java:80) >> at >> org.wso2.carbon.dynamic.client.web.impl.RegistrationServiceImpl.register(RegistrationServiceImpl.java:59) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:606) >> at >> org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:188) >> at >> org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:104) >> at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:204) >> at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:101) >> at >> org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58) >> at >> org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:94) >> at >> org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:272) >> at >> org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121) >> at >> org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:249) >> at >> org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:248) >> at >> org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:222) >> at >> org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:153) >> at >> org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:171) >> at >> org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:289) >> at >> org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:209) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) >> at >> org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:265) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> at >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) >> at >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) >> at >> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504) >> at >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) >> at >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) >> at >> org.wso2.carbon.tomcat.ext.valves.CompositeValve.continueInvocation(CompositeValve.java:99) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonTomcatValve$1.invoke(CarbonTomcatValve.java:47) >> at >> org.wso2.carbon.webapp.mgt.TenantLazyLoaderValve.invoke(TenantLazyLoaderValve.java:57) >> at >> org.wso2.carbon.webapp.authenticator.framework.WebappAuthenticationValve.invoke(WebappAuthenticationValve.java:43) >> at >> org.wso2.carbon.tomcat.ext.valves.TomcatValveContainer.invokeValves(TomcatValveContainer.java:47) >> at >> org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:62) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:159) >> at >> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:57) >> at >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) >> at >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) >> at >> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074) >> at >> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) >> at >> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1739) >> at >> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1698) >> at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) >> at >> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) >> at java.lang.Thread.run(Thread.java:745) >> Caused by: >> org.wso2.carbon.dynamic.client.registration.DynamicClientRegistrationException: >> Error occurred while creating OAuthApp admin_emm >> at >> org.wso2.carbon.dynamic.client.registration.impl.DynamicClientRegistrationServiceImpl.createOAuthApplication(DynamicClientRegistrationServiceImpl.java:279) >> at >> org.wso2.carbon.dynamic.client.registration.impl.DynamicClientRegistrationServiceImpl.registerOAuthApplication(DynamicClientRegistrationServiceImpl.java:78) >> ... 51 more >> Caused by: org.wso2.carbon.identity.base.IdentityRuntimeException: Error >> when getting a database connection object from the Identity data source. >> at >> org.wso2.carbon.identity.core.persistence.JDBCPersistenceManager.getDBConnection(JDBCPersistenceManager.java:129) >> at >> org.wso2.carbon.identity.core.util.IdentityDatabaseUtil.getDBConnection(IdentityDatabaseUtil.java:45) >> at >> org.wso2.carbon.identity.application.mgt.dao.impl.ApplicationDAOImpl.getApplication(ApplicationDAOImpl.java:1190) >> at >> org.wso2.carbon.identity.application.mgt.ApplicationManagementServiceImpl.getServiceProvider(ApplicationManagementServiceImpl.java:720) >> at >> org.wso2.carbon.dynamic.client.registration.impl.DynamicClientRegistrationServiceImpl.createOAuthApplication(DynamicClientRegistrationServiceImpl.java:162) >> ... 52 more >> >> Thanks, >> >> Harshan Liyanage >> Software Engineer >> Mobile: *+94724423048* >> Email: [email protected] >> Blog : http://harshanliyanage.blogspot.com/ >> *WSO2, Inc. :** wso2.com <http://wso2.com/>* >> lean.enterprise.middleware. >> > > > > -- > Maduranga Siriwardena > Software Engineer > WSO2 Inc. > > email: [email protected] > mobile: +94718990591 >
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
