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=?]

Atlassian JIRA | Ronald Spierenburg | 10 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    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

    Atlassian JIRA | 10 years ago | Ronald Spierenburg
    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=?]
  2. 0

    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

    Atlassian JIRA | 10 years ago | Ronald Spierenburg
    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=?]
  3. 0

    Clicked on "Approved Sites" in my OpenId profile, got 500 page: Cause : javax.servlet.ServletException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query Stack Trace : javax.servlet.ServletException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:284) at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:202) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) 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:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:88) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.crowd.integration.http.VerifyTokenFilter.doFilter(VerifyTokenFilter.java:172) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:183) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:33) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) Referer : https://openid.atlassian.com/secure/profile/editprofiles!update.action Build Information : Version : 1.5-SNAPSHOT (Build:#320 - Aug 07, 2008) Memory Information : Total Memory : 88 MB Free Memory : 18 MB Used Memory : 69 MB Request Information : - Request URL : https://openid.atlassian.com/500.jsp - Scheme : https - Server : openid.atlassian.com - Port : 443 - URI : /500.jsp - Context Path : - - Servlet Path : /500.jsp - - Path Info : null - - Query String : Request Attributes : - javax.servlet.forward.request_uri : /secure/interaction/editallowalways!default.action - javax.servlet.forward.context_path : - javax.servlet.forward.servlet_path : /secure/interaction/editallowalways!default.action - javax.servlet.forward.path_info : /500.jsp - javax.servlet.error.message : - interface com.atlassian.crowd.integration.http.HttpAuthenticator.REQUEST_SSO_COOKIE_COMMITTED : true - javax.servlet.error.status_code : 500 - javax.servlet.error.servlet_name : default - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@73400a - sessioninview.FILTERED : true - __sitemesh__filterapplied : true - javax.servlet.error.exception : javax.servlet.ServletException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query - __cleanup_counter : 0 - javax.servlet.error.request_uri : /secure/interaction/editallowalways!default.action - com.atlassian.crowd.integration.http.VerifyTokenFilter.FILTER_RUN : true - crowd.token_key : KAcCaMllsaSnXltDlE0O8g00

    Atlassian JIRA | 9 years ago | Charles Miller [Atlassian]
    javax.servlet.ServletException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Clicked on "Approved Sites" in my OpenId profile, got 500 page: Cause : javax.servlet.ServletException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query Stack Trace : javax.servlet.ServletException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:284) at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:202) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) 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:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:88) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.crowd.integration.http.VerifyTokenFilter.doFilter(VerifyTokenFilter.java:172) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:183) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:33) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) Referer : https://openid.atlassian.com/secure/profile/editprofiles!update.action Build Information : Version : 1.5-SNAPSHOT (Build:#320 - Aug 07, 2008) Memory Information : Total Memory : 88 MB Free Memory : 18 MB Used Memory : 69 MB Request Information : - Request URL : https://openid.atlassian.com/500.jsp - Scheme : https - Server : openid.atlassian.com - Port : 443 - URI : /500.jsp - Context Path : - - Servlet Path : /500.jsp - - Path Info : null - - Query String : Request Attributes : - javax.servlet.forward.request_uri : /secure/interaction/editallowalways!default.action - javax.servlet.forward.context_path : - javax.servlet.forward.servlet_path : /secure/interaction/editallowalways!default.action - javax.servlet.forward.path_info : /500.jsp - javax.servlet.error.message : - interface com.atlassian.crowd.integration.http.HttpAuthenticator.REQUEST_SSO_COOKIE_COMMITTED : true - javax.servlet.error.status_code : 500 - javax.servlet.error.servlet_name : default - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@73400a - sessioninview.FILTERED : true - __sitemesh__filterapplied : true - javax.servlet.error.exception : javax.servlet.ServletException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query - __cleanup_counter : 0 - javax.servlet.error.request_uri : /secure/interaction/editallowalways!default.action - com.atlassian.crowd.integration.http.VerifyTokenFilter.FILTER_RUN : true - crowd.token_key : KAcCaMllsaSnXltDlE0O8g00

    Atlassian JIRA | 9 years ago | Charles Miller [Atlassian]
    javax.servlet.ServletException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
  6. 0

    [CWD-1073] Suppress transaction rolled back servlet exceptions on LDAP-related errors - Atlassian JIRA

    atlassian.com | 2 years ago
    javax.servlet.ServletException: Transaction rolled back because it has been marked as rollback-only

    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. 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()
    2. WebWork
      FilterDispatcher.doFilter
      1. com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:236)
      2. com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:202)
      2 frames
    3. 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
    4. Sitemesh
      PageFilter.doFilter
      1. com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
      2. com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
      2 frames
    5. 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
    6. Hibernate
      OpenSessionInViewFilter.doFilterInternal
      1. org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)
      1 frame
    7. Spring
      OncePerRequestFilter.doFilter
      1. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77)
      1 frame
    8. 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
    9. WebWork
      ActionContextCleanUp.doFilter
      1. com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:88)
      1 frame
    10. 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
    11. UrlRewriteFilter
      UrlRewriteFilter.doFilter
      1. org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350)
      1 frame
    12. 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
    13. com.atlassian.crowd
      VerifyTokenFilter.doFilter
      1. com.atlassian.crowd.integration.http.VerifyTokenFilter.doFilter(VerifyTokenFilter.java:131)
      1 frame
    14. 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
    15. com.atlassian.core
      AbstractEncodingFilter.doFilter
      1. com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37)
      1 frame
    16. 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
    17. 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
    18. Tomcat Util
      ThreadPool$ControlRunnable.run
      1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
      1 frame
    19. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:595)
      1 frame