org.hibernate.exception.SQLGrammarException: could not initialize a collection: [com.atlassian.crowd.integration.model.RemotePrincipal.groups#component[directoryID,name]{directoryID=32769, name=admin}]

Atlassian JIRA | Peter Neubauer | 8 years ago
  1. 0

    After setting up Crowd as a webapp, with HSQL embedded, and defining a default user "admin" I get the following stack trace upon trying to login via the console - any hints? 2008-08-06 11:30:31,900 http-8080-Processor17 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: -11, SQLState: 37000 2008-08-06 11:30:31,900 http-8080-Processor17 ERROR [org.hibernate.util.JDBCExceptionReporter] Unexpected token: AND in statement [select groups0_."REMOTEPRINCIPALDIRECTORYID" as REMOTEPR1_1_, groups0_."REMOTEPRINCIPALNAME" as REMOTEPR2_1_, groups0_."REMOTEGROUPDIRECTORYID" as REMOTEGR3_1_, groups0_."REMOTEGROUPNAME" as REMOTEGR4_1_, remotegrou1_."ID" as ID1_31_0_, remotegrou1_."NAME" as NAME2_31_0_, remotegrou1_."ACTIVE" as ACTIVE3_31_0_, remotegrou1_."CONCEPTION" as CONCEPTION4_31_0_, remotegrou1_."LASTMODIFIED" as LASTMODI5_31_0_, remotegrou1_."DESCRIPTION" as DESCRIPT6_31_0_, remotegrou1_.DIRECTORYID as DIRECTOR7_31_0_ from "REMOTEGROUPMEMBERS" groups0_ left outer join "REMOTEGROUP" remotegrou1_ on groups0_."REMOTEGROUPDIRECTORYID"=remotegrou1_."ID" and groups0_."REMOTEGROUPNAME"=remotegrou1_."NAME" where groups0_."REMOTEPRINCIPALDIRECTORYID"=32769 and groups0_."REMOTEPRINCIPALNAME"='admin'] 2008-08-06 11:30:31,901 http-8080-Processor17 ERROR [codehaus.xfire.handler.DefaultFaultHandler] Fault occurred! org.hibernate.exception.SQLGrammarException: could not initialize a collection: [com.atlassian.crowd.integration.model.RemotePrincipal.groups#component[directoryID,name]{directoryID=32769, name=admin}] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.loadCollection(Loader.java:2001) at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36) at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:565) at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60) at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1716) at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:344) at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:86) at org.hibernate.collection.AbstractPersistentCollection.readElementExistence(AbstractPersistentCollection.java:142) at org.hibernate.collection.PersistentSet.contains(PersistentSet.java:153) at com.atlassian.crowd.integration.directory.internal.InternalDirectory.isGroupMember(InternalDirectory.java:231) at com.atlassian.crowd.manager.GenericManager.hasAccess(GenericManager.java:263) at com.atlassian.crowd.manager.application.ApplicationManagerGeneric.authenticate(ApplicationManagerGeneric.java:570) at com.atlassian.crowd.manager.application.ApplicationManagerGeneric.authenticate(ApplicationManagerGeneric.java:528) at com.atlassian.crowd.manager.application.ApplicationManagerGeneric.authenticate(ApplicationManagerGeneric.java:522) at com.atlassian.crowd.service.soap.SecurityServerGeneric.authenticatePrincipal(SecurityServerGeneric.java:164) 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:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at com.atlassian.spring.interceptors.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:20) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy82.authenticatePrincipal(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:585) at org.codehaus.xfire.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:59) at org.codehaus.xfire.service.binding.ServiceInvocationHandler.sendMessage(ServiceInvocationHandler.java:320) at org.codehaus.xfire.service.binding.ServiceInvocationHandler$1.run(ServiceInvocationHandler.java:86) at org.codehaus.xfire.service.binding.ServiceInvocationHandler.execute(ServiceInvocationHandler.java:134) at org.codehaus.xfire.service.binding.ServiceInvocationHandler.invoke(ServiceInvocationHandler.java:109) at org.codehaus.xfire.handler.HandlerPipeline.invoke(HandlerPipeline.java:131) at org.codehaus.xfire.transport.DefaultEndpoint.onReceive(DefaultEndpoint.java:64) at org.codehaus.xfire.transport.AbstractChannel.receive(AbstractChannel.java:38) at org.codehaus.xfire.transport.http.XFireServletController.invoke(XFireServletController.java:304) at org.codehaus.xfire.transport.http.XFireServletController.doService(XFireServletController.java:129) at org.codehaus.xfire.transport.http.XFireServlet.doPost(XFireServlet.java:116) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) at com.atlassian.crowd.console.filter.CrowdOpenSessionInViewFilter.doFilterInternal(CrowdOpenSessionInViewFilter.java:26) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:88) at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:64) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:183) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at com.atlassian.crowd.console.filter.CrowdDelegatingFilterProxy.doFilter(CrowdDelegatingFilterProxy.java:38) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) Caused by: java.sql.SQLException: Unexpected token: AND in statement [select groups0_."REMOTEPRINCIPALDIRECTORYID" as REMOTEPR1_1_, groups0_."REMOTEPRINCIPALNAME" as REMOTEPR2_1_, groups0_."REMOTEGROUPDIRECTORYID" as REMOTEGR3_1_, groups0_."REMOTEGROUPNAME" as REMOTEGR4_1_, remotegrou1_."ID" as ID1_31_0_, remotegrou1_."NAME" as NAME2_31_0_, remotegrou1_."ACTIVE" as ACTIVE3_31_0_, remotegrou1_."CONCEPTION" as CONCEPTION4_31_0_, remotegrou1_."LASTMODIFIED" as LASTMODI5_31_0_, remotegrou1_."DESCRIPTION" as DESCRIPT6_31_0_, remotegrou1_.DIRECTORYID as DIRECTOR7_31_0_ from "REMOTEGROUPMEMBERS" groups0_ left outer join "REMOTEGROUP" remotegrou1_ on groups0_."REMOTEGROUPDIRECTORYID"=remotegrou1_."ID" and groups0_."REMOTEGROUPNAME"=remotegrou1_."NAME" where groups0_."REMOTEPRINCIPALDIRECTORYID"=32769 and groups0_."REMOTEPRINCIPALNAME"='admin'] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.<init>(Unknown Source) at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbcStatement.executeQuery(Unknown Source) at org.hsqldb.jdbcPreparedStatement.executeQuery(Unknown Source) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1787) at org.hibernate.loader.Loader.doQuery(Loader.java:674) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.loadCollection(Loader.java:1994) ... 76 more 2008-08-06 11:30:31,972 http-8080-Processor21 ERROR [crowd.console.action.Login] Could not invoke service.. Nested exception is org.codehaus.xfire.fault.XFireFault: could not initialize a collection: [com.atlassian.crowd.integration.model.RemotePrincipal.groups#component[directoryID,name]{directoryID=32769, name=admin}]; nested exception is org.codehaus.xfire.XFireRuntimeException: Could not invoke service.. Nested exception is org.codehaus.xfire.fault.XFireFault: could not initialize a collection: [com.atlassian.crowd.integration.model.RemotePrincipal.groups#component[directoryID,name]{directoryID=32769, name=admin}] org.acegisecurity.AuthenticationServiceException: Could not invoke service.. Nested exception is org.codehaus.xfire.fault.XFireFault: could not initialize a collection: [com.atlassian.crowd.integration.model.RemotePrincipal.groups#component[directoryID,name]{directoryID=32769, name=admin}]; nested exception is org.codehaus.xfire.XFireRuntimeException: Could not invoke service.. Nested exception is org.codehaus.xfire.fault.XFireFault: could not initialize a collection: [com.atlassian.crowd.integration.model.RemotePrincipal.groups#component[directoryID,name]{directoryID=32769, name=admin}] at com.atlassian.crowd.integration.acegi.CrowdAuthenticationProvider.translateException(CrowdAuthenticationProvider.java:212) at com.atlassian.crowd.integration.acegi.CrowdAuthenticationProvider.authenticateUsernamePassword(CrowdAuthenticationProvider.java:136) at com.atlassian.crowd.integration.acegi.CrowdAuthenticationProvider.authenticate(CrowdAuthenticationProvider.java:76) at org.acegisecurity.providers.ProviderManager.doAuthentication(ProviderManager.java:195) at org.acegisecurity.AbstractAuthenticationManager.authenticate(AbstractAuthenticationManager.java:45) at org.acegisecurity.ui.webapp.AuthenticationProcessingFilter.attemptAuthentication(AuthenticationProcessingFilter.java:71) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:252) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:183) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at com.atlassian.crowd.console.filter.CrowdDelegatingFilterProxy.doFilter(CrowdDelegatingFilterProxy.java:38) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) at com.atlassian.crowd.console.filter.CrowdOpenSessionInViewFilter.doFilterInternal(CrowdOpenSessionInViewFilter.java:26) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:88) at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:64) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:183) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at com.atlassian.crowd.console.filter.CrowdDelegatingFilterProxy.doFilter(CrowdDelegatingFilterProxy.java:38) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.crowd.console.filter.LicenceFilter.doFilterInternal(LicenceFilter.java:55) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:183) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at com.atlassian.crowd.console.filter.CrowdDelegatingFilterProxy.doFilter(CrowdDelegatingFilterProxy.java:38) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:33) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) Caused by: org.codehaus.xfire.XFireRuntimeException: Could not invoke service.. Nested exception is org.codehaus.xfire.fault.XFireFault: could not initialize a collection: [com.atlassian.crowd.integration.model.RemotePrincipal.groups#component[directoryID,name]{directoryID=32769, name=admin}] at org.codehaus.xfire.client.XFireProxy.handleRequest(XFireProxy.java:92) at org.codehaus.xfire.client.XFireProxy.invoke(XFireProxy.java:57) at $Proxy86.authenticatePrincipal(Unknown Source) at com.atlassian.crowd.integration.service.soap.client.SecurityServerClientImpl.authenticatePrincipal(SecurityServerClientImpl.java:223) at com.atlassian.crowd.integration.service.cache.AuthenticationManagerImpl.authenticate(AuthenticationManagerImpl.java:60) at com.atlassian.crowd.integration.http.HttpAuthenticatorImpl.verifyAuthentication(HttpAuthenticatorImpl.java:387) at com.atlassian.crowd.integration.acegi.CrowdAuthenticationProvider.authenticateUsernamePassword(CrowdAuthenticationProvider.java:122) ... 53 more Caused by: org.codehaus.xfire.fault.XFireFault: could not initialize a collection: [com.atlassian.crowd.integration.model.RemotePrincipal.groups#component[directoryID,name]{directoryID=32769, name=admin}] at org.codehaus.xfire.fault.Soap11FaultSerializer.readMessage(Soap11FaultSerializer.java:31) at org.codehaus.xfire.fault.SoapFaultSerializer.readMessage(SoapFaultSerializer.java:28) at org.codehaus.xfire.soap.handler.ReadHeadersHandler.checkForFault(ReadHeadersHandler.java:111) at org.codehaus.xfire.soap.handler.ReadHeadersHandler.invoke(ReadHeadersHandler.java:67) at org.codehaus.xfire.handler.HandlerPipeline.invoke(HandlerPipeline.java:131) at org.codehaus.xfire.client.Client.onReceive(Client.java:406) at org.codehaus.xfire.transport.http.HttpChannel.sendViaClient(HttpChannel.java:139) at org.codehaus.xfire.transport.http.HttpChannel.send(HttpChannel.java:48) at org.codehaus.xfire.handler.OutMessageSender.invoke(OutMessageSender.java:26) at org.codehaus.xfire.handler.HandlerPipeline.invoke(HandlerPipeline.java:131) at org.codehaus.xfire.client.Invocation.invoke(Invocation.java:79) at org.codehaus.xfire.client.Invocation.invoke(Invocation.java:114) at org.codehaus.xfire.client.Client.invoke(Client.java:336) at org.codehaus.xfire.client.XFireProxy.handleRequest(XFireProxy.java:77) ... 59 more

    Atlassian JIRA | 8 years ago | Peter Neubauer
    org.hibernate.exception.SQLGrammarException: could not initialize a collection: [com.atlassian.crowd.integration.model.RemotePrincipal.groups#component[directoryID,name]{directoryID=32769, name=admin}]
  2. 0

    After setting up Crowd as a webapp, with HSQL embedded, and defining a default user "admin" I get the following stack trace upon trying to login via the console - any hints? 2008-08-06 11:30:31,900 http-8080-Processor17 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: -11, SQLState: 37000 2008-08-06 11:30:31,900 http-8080-Processor17 ERROR [org.hibernate.util.JDBCExceptionReporter] Unexpected token: AND in statement [select groups0_."REMOTEPRINCIPALDIRECTORYID" as REMOTEPR1_1_, groups0_."REMOTEPRINCIPALNAME" as REMOTEPR2_1_, groups0_."REMOTEGROUPDIRECTORYID" as REMOTEGR3_1_, groups0_."REMOTEGROUPNAME" as REMOTEGR4_1_, remotegrou1_."ID" as ID1_31_0_, remotegrou1_."NAME" as NAME2_31_0_, remotegrou1_."ACTIVE" as ACTIVE3_31_0_, remotegrou1_."CONCEPTION" as CONCEPTION4_31_0_, remotegrou1_."LASTMODIFIED" as LASTMODI5_31_0_, remotegrou1_."DESCRIPTION" as DESCRIPT6_31_0_, remotegrou1_.DIRECTORYID as DIRECTOR7_31_0_ from "REMOTEGROUPMEMBERS" groups0_ left outer join "REMOTEGROUP" remotegrou1_ on groups0_."REMOTEGROUPDIRECTORYID"=remotegrou1_."ID" and groups0_."REMOTEGROUPNAME"=remotegrou1_."NAME" where groups0_."REMOTEPRINCIPALDIRECTORYID"=32769 and groups0_."REMOTEPRINCIPALNAME"='admin'] 2008-08-06 11:30:31,901 http-8080-Processor17 ERROR [codehaus.xfire.handler.DefaultFaultHandler] Fault occurred! org.hibernate.exception.SQLGrammarException: could not initialize a collection: [com.atlassian.crowd.integration.model.RemotePrincipal.groups#component[directoryID,name]{directoryID=32769, name=admin}] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.loadCollection(Loader.java:2001) at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36) at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:565) at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60) at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1716) at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:344) at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:86) at org.hibernate.collection.AbstractPersistentCollection.readElementExistence(AbstractPersistentCollection.java:142) at org.hibernate.collection.PersistentSet.contains(PersistentSet.java:153) at com.atlassian.crowd.integration.directory.internal.InternalDirectory.isGroupMember(InternalDirectory.java:231) at com.atlassian.crowd.manager.GenericManager.hasAccess(GenericManager.java:263) at com.atlassian.crowd.manager.application.ApplicationManagerGeneric.authenticate(ApplicationManagerGeneric.java:570) at com.atlassian.crowd.manager.application.ApplicationManagerGeneric.authenticate(ApplicationManagerGeneric.java:528) at com.atlassian.crowd.manager.application.ApplicationManagerGeneric.authenticate(ApplicationManagerGeneric.java:522) at com.atlassian.crowd.service.soap.SecurityServerGeneric.authenticatePrincipal(SecurityServerGeneric.java:164) 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:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at com.atlassian.spring.interceptors.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:20) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy82.authenticatePrincipal(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:585) at org.codehaus.xfire.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:59) at org.codehaus.xfire.service.binding.ServiceInvocationHandler.sendMessage(ServiceInvocationHandler.java:320) at org.codehaus.xfire.service.binding.ServiceInvocationHandler$1.run(ServiceInvocationHandler.java:86) at org.codehaus.xfire.service.binding.ServiceInvocationHandler.execute(ServiceInvocationHandler.java:134) at org.codehaus.xfire.service.binding.ServiceInvocationHandler.invoke(ServiceInvocationHandler.java:109) at org.codehaus.xfire.handler.HandlerPipeline.invoke(HandlerPipeline.java:131) at org.codehaus.xfire.transport.DefaultEndpoint.onReceive(DefaultEndpoint.java:64) at org.codehaus.xfire.transport.AbstractChannel.receive(AbstractChannel.java:38) at org.codehaus.xfire.transport.http.XFireServletController.invoke(XFireServletController.java:304) at org.codehaus.xfire.transport.http.XFireServletController.doService(XFireServletController.java:129) at org.codehaus.xfire.transport.http.XFireServlet.doPost(XFireServlet.java:116) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) at com.atlassian.crowd.console.filter.CrowdOpenSessionInViewFilter.doFilterInternal(CrowdOpenSessionInViewFilter.java:26) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:88) at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:64) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:183) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at com.atlassian.crowd.console.filter.CrowdDelegatingFilterProxy.doFilter(CrowdDelegatingFilterProxy.java:38) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) Caused by: java.sql.SQLException: Unexpected token: AND in statement [select groups0_."REMOTEPRINCIPALDIRECTORYID" as REMOTEPR1_1_, groups0_."REMOTEPRINCIPALNAME" as REMOTEPR2_1_, groups0_."REMOTEGROUPDIRECTORYID" as REMOTEGR3_1_, groups0_."REMOTEGROUPNAME" as REMOTEGR4_1_, remotegrou1_."ID" as ID1_31_0_, remotegrou1_."NAME" as NAME2_31_0_, remotegrou1_."ACTIVE" as ACTIVE3_31_0_, remotegrou1_."CONCEPTION" as CONCEPTION4_31_0_, remotegrou1_."LASTMODIFIED" as LASTMODI5_31_0_, remotegrou1_."DESCRIPTION" as DESCRIPT6_31_0_, remotegrou1_.DIRECTORYID as DIRECTOR7_31_0_ from "REMOTEGROUPMEMBERS" groups0_ left outer join "REMOTEGROUP" remotegrou1_ on groups0_."REMOTEGROUPDIRECTORYID"=remotegrou1_."ID" and groups0_."REMOTEGROUPNAME"=remotegrou1_."NAME" where groups0_."REMOTEPRINCIPALDIRECTORYID"=32769 and groups0_."REMOTEPRINCIPALNAME"='admin'] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.<init>(Unknown Source) at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbcStatement.executeQuery(Unknown Source) at org.hsqldb.jdbcPreparedStatement.executeQuery(Unknown Source) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1787) at org.hibernate.loader.Loader.doQuery(Loader.java:674) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.loadCollection(Loader.java:1994) ... 76 more 2008-08-06 11:30:31,972 http-8080-Processor21 ERROR [crowd.console.action.Login] Could not invoke service.. Nested exception is org.codehaus.xfire.fault.XFireFault: could not initialize a collection: [com.atlassian.crowd.integration.model.RemotePrincipal.groups#component[directoryID,name]{directoryID=32769, name=admin}]; nested exception is org.codehaus.xfire.XFireRuntimeException: Could not invoke service.. Nested exception is org.codehaus.xfire.fault.XFireFault: could not initialize a collection: [com.atlassian.crowd.integration.model.RemotePrincipal.groups#component[directoryID,name]{directoryID=32769, name=admin}] org.acegisecurity.AuthenticationServiceException: Could not invoke service.. Nested exception is org.codehaus.xfire.fault.XFireFault: could not initialize a collection: [com.atlassian.crowd.integration.model.RemotePrincipal.groups#component[directoryID,name]{directoryID=32769, name=admin}]; nested exception is org.codehaus.xfire.XFireRuntimeException: Could not invoke service.. Nested exception is org.codehaus.xfire.fault.XFireFault: could not initialize a collection: [com.atlassian.crowd.integration.model.RemotePrincipal.groups#component[directoryID,name]{directoryID=32769, name=admin}] at com.atlassian.crowd.integration.acegi.CrowdAuthenticationProvider.translateException(CrowdAuthenticationProvider.java:212) at com.atlassian.crowd.integration.acegi.CrowdAuthenticationProvider.authenticateUsernamePassword(CrowdAuthenticationProvider.java:136) at com.atlassian.crowd.integration.acegi.CrowdAuthenticationProvider.authenticate(CrowdAuthenticationProvider.java:76) at org.acegisecurity.providers.ProviderManager.doAuthentication(ProviderManager.java:195) at org.acegisecurity.AbstractAuthenticationManager.authenticate(AbstractAuthenticationManager.java:45) at org.acegisecurity.ui.webapp.AuthenticationProcessingFilter.attemptAuthentication(AuthenticationProcessingFilter.java:71) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:252) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:183) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at com.atlassian.crowd.console.filter.CrowdDelegatingFilterProxy.doFilter(CrowdDelegatingFilterProxy.java:38) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) at com.atlassian.crowd.console.filter.CrowdOpenSessionInViewFilter.doFilterInternal(CrowdOpenSessionInViewFilter.java:26) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:88) at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:64) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:183) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at com.atlassian.crowd.console.filter.CrowdDelegatingFilterProxy.doFilter(CrowdDelegatingFilterProxy.java:38) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.crowd.console.filter.LicenceFilter.doFilterInternal(LicenceFilter.java:55) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:183) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at com.atlassian.crowd.console.filter.CrowdDelegatingFilterProxy.doFilter(CrowdDelegatingFilterProxy.java:38) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:33) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) Caused by: org.codehaus.xfire.XFireRuntimeException: Could not invoke service.. Nested exception is org.codehaus.xfire.fault.XFireFault: could not initialize a collection: [com.atlassian.crowd.integration.model.RemotePrincipal.groups#component[directoryID,name]{directoryID=32769, name=admin}] at org.codehaus.xfire.client.XFireProxy.handleRequest(XFireProxy.java:92) at org.codehaus.xfire.client.XFireProxy.invoke(XFireProxy.java:57) at $Proxy86.authenticatePrincipal(Unknown Source) at com.atlassian.crowd.integration.service.soap.client.SecurityServerClientImpl.authenticatePrincipal(SecurityServerClientImpl.java:223) at com.atlassian.crowd.integration.service.cache.AuthenticationManagerImpl.authenticate(AuthenticationManagerImpl.java:60) at com.atlassian.crowd.integration.http.HttpAuthenticatorImpl.verifyAuthentication(HttpAuthenticatorImpl.java:387) at com.atlassian.crowd.integration.acegi.CrowdAuthenticationProvider.authenticateUsernamePassword(CrowdAuthenticationProvider.java:122) ... 53 more Caused by: org.codehaus.xfire.fault.XFireFault: could not initialize a collection: [com.atlassian.crowd.integration.model.RemotePrincipal.groups#component[directoryID,name]{directoryID=32769, name=admin}] at org.codehaus.xfire.fault.Soap11FaultSerializer.readMessage(Soap11FaultSerializer.java:31) at org.codehaus.xfire.fault.SoapFaultSerializer.readMessage(SoapFaultSerializer.java:28) at org.codehaus.xfire.soap.handler.ReadHeadersHandler.checkForFault(ReadHeadersHandler.java:111) at org.codehaus.xfire.soap.handler.ReadHeadersHandler.invoke(ReadHeadersHandler.java:67) at org.codehaus.xfire.handler.HandlerPipeline.invoke(HandlerPipeline.java:131) at org.codehaus.xfire.client.Client.onReceive(Client.java:406) at org.codehaus.xfire.transport.http.HttpChannel.sendViaClient(HttpChannel.java:139) at org.codehaus.xfire.transport.http.HttpChannel.send(HttpChannel.java:48) at org.codehaus.xfire.handler.OutMessageSender.invoke(OutMessageSender.java:26) at org.codehaus.xfire.handler.HandlerPipeline.invoke(HandlerPipeline.java:131) at org.codehaus.xfire.client.Invocation.invoke(Invocation.java:79) at org.codehaus.xfire.client.Invocation.invoke(Invocation.java:114) at org.codehaus.xfire.client.Client.invoke(Client.java:336) at org.codehaus.xfire.client.XFireProxy.handleRequest(XFireProxy.java:77) ... 59 more

    Atlassian JIRA | 8 years ago | Peter Neubauer
    org.hibernate.exception.SQLGrammarException: could not initialize a collection: [com.atlassian.crowd.integration.model.RemotePrincipal.groups#component[directoryID,name]{directoryID=32769, name=admin}]
  3. 0

    CMR One-to-Many problem

    Oracle Community | 1 decade ago | 342148
    java.sql.SQLException: Column not found: READER in statement [select USER_ACCOUNT.USERNAME, USER_ACCOUNT.PASSWORD, USER_ACCOUNT.ISSUE_DATE, USER_ACCOUNT.REVOKE_DATE, USER_ACCOUNT.STATUS, USER_ACCOUNT.reader from USER_ACCOUNT where (USER_ACCOUNT.ID = 1)]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Reverse Mapping Tutorial - Finder.java queries the wrong table?!

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: Table not found: S0002 Table not found: MAGAZINEX in statement [SELECT DISTINCT MAGAZINEX.JDOCLASSX FROM MAGAZINEX]
  6. 0

    Own classloader and Hsqldb

    hsqldb | 1 decade ago | templth
    java.sql.SQLException: Transfer corrupted

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Unexpected token: AND in statement [select groups0_."REMOTEPRINCIPALDIRECTORYID" as REMOTEPR1_1_, groups0_."REMOTEPRINCIPALNAME" as REMOTEPR2_1_, groups0_."REMOTEGROUPDIRECTORYID" as REMOTEGR3_1_, groups0_."REMOTEGROUPNAME" as REMOTEGR4_1_, remotegrou1_."ID" as ID1_31_0_, remotegrou1_."NAME" as NAME2_31_0_, remotegrou1_."ACTIVE" as ACTIVE3_31_0_, remotegrou1_."CONCEPTION" as CONCEPTION4_31_0_, remotegrou1_."LASTMODIFIED" as LASTMODI5_31_0_, remotegrou1_."DESCRIPTION" as DESCRIPT6_31_0_, remotegrou1_.DIRECTORYID as DIRECTOR7_31_0_ from "REMOTEGROUPMEMBERS" groups0_ left outer join "REMOTEGROUP" remotegrou1_ on groups0_."REMOTEGROUPDIRECTORYID"=remotegrou1_."ID" and groups0_."REMOTEGROUPNAME"=remotegrou1_."NAME" where groups0_."REMOTEPRINCIPALDIRECTORYID"=32769 and groups0_."REMOTEPRINCIPALNAME"='admin']

      at org.hsqldb.Trace.getError()
    2. HSQLDB
      jdbcPreparedStatement.executeQuery
      1. org.hsqldb.Trace.getError(Unknown Source)
      2. org.hsqldb.jdbcResultSet.<init>(Unknown Source)
      3. org.hsqldb.jdbcConnection.executeStandalone(Unknown Source)
      4. org.hsqldb.jdbcConnection.execute(Unknown Source)
      5. org.hsqldb.jdbcStatement.fetchResult(Unknown Source)
      6. org.hsqldb.jdbcStatement.executeQuery(Unknown Source)
      7. org.hsqldb.jdbcPreparedStatement.executeQuery(Unknown Source)
      7 frames
    3. c3p0:JDBC DataSources/Resource Pools
      NewProxyPreparedStatement.executeQuery
      1. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
      1 frame
    4. Hibernate
      AbstractCollectionPersister.initialize
      1. org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
      2. org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
      3. org.hibernate.loader.Loader.doQuery(Loader.java:674)
      4. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
      5. org.hibernate.loader.Loader.loadCollection(Loader.java:1994)
      6. org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36)
      7. org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:565)
      7 frames
    5. Hibernate
      PersistentSet.contains
      1. org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)
      2. org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1716)
      3. org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:344)
      4. org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:86)
      5. org.hibernate.collection.AbstractPersistentCollection.readElementExistence(AbstractPersistentCollection.java:142)
      6. org.hibernate.collection.PersistentSet.contains(PersistentSet.java:153)
      6 frames
    6. com.atlassian.crowd
      SecurityServerGeneric.authenticatePrincipal
      1. com.atlassian.crowd.integration.directory.internal.InternalDirectory.isGroupMember(InternalDirectory.java:231)
      2. com.atlassian.crowd.manager.GenericManager.hasAccess(GenericManager.java:263)
      3. com.atlassian.crowd.manager.application.ApplicationManagerGeneric.authenticate(ApplicationManagerGeneric.java:570)
      4. com.atlassian.crowd.manager.application.ApplicationManagerGeneric.authenticate(ApplicationManagerGeneric.java:528)
      5. com.atlassian.crowd.manager.application.ApplicationManagerGeneric.authenticate(ApplicationManagerGeneric.java:522)
      6. com.atlassian.crowd.service.soap.SecurityServerGeneric.authenticatePrincipal(SecurityServerGeneric.java:164)
      6 frames
    7. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:585)
      4 frames
    8. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
      3 frames
    9. com.atlassian.spring
      SpringProfilingInterceptor.invoke
      1. com.atlassian.spring.interceptors.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:20)
      1 frame
    10. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      1 frame
    11. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
      1 frame
    12. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      2 frames
    13. Unknown
      $Proxy82.authenticatePrincipal
      1. $Proxy82.authenticatePrincipal(Unknown Source)
      1 frame
    14. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:585)
      4 frames
    15. XFire
      XFireServlet.doPost
      1. org.codehaus.xfire.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:59)
      2. org.codehaus.xfire.service.binding.ServiceInvocationHandler.sendMessage(ServiceInvocationHandler.java:320)
      3. org.codehaus.xfire.service.binding.ServiceInvocationHandler$1.run(ServiceInvocationHandler.java:86)
      4. org.codehaus.xfire.service.binding.ServiceInvocationHandler.execute(ServiceInvocationHandler.java:134)
      5. org.codehaus.xfire.service.binding.ServiceInvocationHandler.invoke(ServiceInvocationHandler.java:109)
      6. org.codehaus.xfire.handler.HandlerPipeline.invoke(HandlerPipeline.java:131)
      7. org.codehaus.xfire.transport.DefaultEndpoint.onReceive(DefaultEndpoint.java:64)
      8. org.codehaus.xfire.transport.AbstractChannel.receive(AbstractChannel.java:38)
      9. org.codehaus.xfire.transport.http.XFireServletController.invoke(XFireServletController.java:304)
      10. org.codehaus.xfire.transport.http.XFireServletController.doService(XFireServletController.java:129)
      11. org.codehaus.xfire.transport.http.XFireServlet.doPost(XFireServlet.java:116)
      11 frames
    16. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      2 frames
    17. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2 frames
    18. Hibernate
      OpenSessionInViewFilter.doFilterInternal
      1. org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
      1 frame
    19. com.atlassian.crowd
      CrowdOpenSessionInViewFilter.doFilterInternal
      1. com.atlassian.crowd.console.filter.CrowdOpenSessionInViewFilter.doFilterInternal(CrowdOpenSessionInViewFilter.java:26)
      1 frame
    20. Spring
      OncePerRequestFilter.doFilter
      1. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
      1 frame
    21. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2 frames
    22. com.atlassian.gzipfilter
      GzipFilter.doFilter
      1. com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:88)
      2. com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:64)
      2 frames
    23. Spring
      DelegatingFilterProxy.doFilter
      1. org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:183)
      2. org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138)
      2 frames
    24. com.atlassian.crowd
      CrowdDelegatingFilterProxy.doFilter
      1. com.atlassian.crowd.console.filter.CrowdDelegatingFilterProxy.doFilter(CrowdDelegatingFilterProxy.java:38)
      1 frame
    25. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2 frames
    26. com.atlassian.johnson
      AbstractJohnsonFilter.doFilter
      1. com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72)
      1 frame
    27. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2 frames
    28. com.atlassian.johnson
      AbstractJohnsonFilter.doFilter
      1. com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72)
      1 frame
    29. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      5. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      6. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      7. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      8. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      8 frames
    30. Grizzly HTTP
      LeaderFollowerWorkerThread.runIt
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
      2. org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
      3. org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
      4. org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
      4 frames
    31. Tomcat Util
      ThreadPool$ControlRunnable.run
      1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
      1 frame
    32. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:595)
      1 frame