Details
-
Bug
-
Resolution: Obsolete
-
Medium
-
None
-
1.1.2
-
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