Uploaded image for project: 'Crowd Data Center'
  1. Crowd Data Center
  2. CWD-1197

Strange exception when logging in with correct password to the console

    XMLWordPrintable

Details

    • Bug
    • Resolution: Handled by Support
    • Medium
    • None
    • 1.4.4
    • None
    • None

    Description

      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

      Attachments

        Activity

          People

            doflynn David O'Flynn [Atlassian]
            f68d219a1ff1 Peter Neubauer
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: