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

hibernate sql exception when clicking in the openid server

    XMLWordPrintable

Details

    • Bug
    • Resolution: Obsolete
    • Medium
    • None
    • 1.1.2
    • OpenID
    • None

    Description

      When a user visits the Crowd openid server and changes his/her password all works fine. But if I click another link there, I get the following error.

      I get it when i click one of the following: 'administration', 'profiles', 'approved sites', 'history'.

      I don't get the error when i click 'My OpenId', although there it says 'nullusers/USERNAME' (with my own username as USERNAME).

      System Error System Error

      A system error has occured please contact your administrator.
      If this problem continues to occur please contact Atlassian by opening a support request with the following information:

      • A description of your problem and what you were doing at the time it occurred
      • Cut & paste the error and system information found below
      • Attach the application server log file (if possible).
        Cause :
        javax.servlet.ServletException: Hibernate operation: could not execute query; bad SQL grammar [select this_.ID as ID22_0_, this_.NAME as NAME22_0_, this_.VALUE as VALUE22_0_ from SERVERPROPERTY this_ where this_.NAME=?]; nested exception is java.sql.SQLException: Table not found in statement [select this_.ID as ID22_0_, this_.NAME as NAME22_0_, this_.VALUE as VALUE22_0_ from SERVERPROPERTY this_ where this_.NAME=?]
        Stack Trace :
        javax.servlet.ServletException: Hibernate operation: could not execute query; bad SQL grammar [select this_.ID as ID22_0_, this_.NAME as NAME22_0_, this_.VALUE as VALUE22_0_ from SERVERPROPERTY this_ where this_.NAME=?]; nested exception is java.sql.SQLException: Table not found in statement [select this_.ID as ID22_0_, this_.NAME as NAME22_0_, this_.VALUE as VALUE22_0_ from SERVERPROPERTY this_ where this_.NAME=?]
        at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:236)
        at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
        at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
        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:174)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:88)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at com.atlassian.crowd.integration.http.VerifyTokenFilter.doFilter(VerifyTokenFilter.java:131)
        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:37)
        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)
        Referer : https://crowd.luminis.net/openidserver/secure/profile/viewidentity.action
        Build Information :
        Version : 1.1.2 (Build:#185 - Sep 03, 2007)
        Memory Information :
        Total Memory : 33 MB
        Free Memory : 9 MB
        Used Memory : 24 MB
        Request Information :
      • Request URL : http://localhost:8095/openidserver/500.jsp
      • Scheme : http
      • Server : localhost
      • Port : 8095
      • URI : /openidserver/500.jsp
      • Context Path : /openidserver
      • - Servlet Path : /500.jsp
      • - Path Info : null
      • - Query String :

      Request Attributes :

      • javax.servlet.forward.request_uri : /openidserver/secure/admin/viewoptions.action
      • javax.servlet.forward.context_path : /openidserver
      • javax.servlet.forward.servlet_path : /secure/admin/viewoptions.action
      • javax.servlet.forward.path_info : /500.jsp
      • javax.servlet.error.servlet_name : default
      • crowd.token_key : fdX4H3OhmmwuRzm8bsOZYA00
      • javax.servlet.error.message :
      • javax.servlet.error.exception : javax.servlet.ServletException: Hibernate operation: could not execute query; bad SQL grammar [select this_.ID as ID22_0_, this_.NAME as NAME22_0_, this_.VALUE as VALUE22_0_ from SERVERPROPERTY this_ where this_.NAME=?]; nested exception is java.sql.SQLException: Table not found in statement [select this_.ID as ID22_0_, this_.NAME as NAME22_0_, this_.VALUE as VALUE22_0_ from SERVERPROPERTY this_ where this_.NAME=?]
      • webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@3f0e71
      • javax.servlet.error.request_uri : /openidserver/secure/admin/viewoptions.action
      • __cleanup_counter : 0
      • javax.servlet.error.status_code : 500
      • com.atlassian.crowd.integration.http.VerifyTokenFilter.FILTER_RUN : true
      • _sitemesh_filterapplied : true
      • sessioninview.FILTERED : true

      Attachments

        Activity

          People

            justen.stepka@atlassian.com Justen Stepka [Atlassian]
            d4c8a201-bb6e-413a-92aa-4b2a881c9777 Deleted Account (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: