-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
If you create a new user in WebUI in OpenNMS 1.7.3 (current unstable),
the new user can´t login and get the following Java Exception:
<errormessage>
The Web User Interface Has Experienced an Unexpected Error
The webUI has encountered an exception condition that it does not know
how to handle.
Possible causes could be that the database is not responding, the
OpenNMS application has stopped or is not running, or there is an
issue with the servlet container.
You can try going to the main page and hitting "refresh" in your
browser, but there is a good chance that will have no effect. Please
bring this message to the attention of the person responsible for
maintaining OpenNMS for your organization, and have them insure that
OpenNMS, the external servlet container (if applicable), and the
database are all running without errors.
org.springframework.dao.InvalidDataAccessResourceUsageException: could
not execute query; nested exception is
org.hibernate.exception.SQLGrammarException: could not execute query
at
org
.springframework
.orm
.hibernate3
.SessionFactoryUtils
.convertHibernateAccessException(SessionFactoryUtils.java:630)
at
org
.springframework
.orm
.hibernate3
.HibernateAccessor
.convertHibernateAccessException(HibernateAccessor.java:412)
at
org
.springframework
.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
at
org
.springframework
.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:
343)
at
org
.opennms
.netmgt
.dao
.hibernate.AbstractDaoHibernate.findMatching(AbstractDaoHibernate.java:
217)
at
org.opennms.web.outage.DaoWebOutageRepository.getMatchingOutageSummaries
(DaoWebOutageRepository.java:211)
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:597)
at
org
.springframework
.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at
org
.springframework
.aop
.framework
.ReflectiveMethodInvocation
.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at
org
.springframework
.aop
.framework
.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
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 $Proxy68.getMatchingOutageSummaries(Unknown Source)
at
org.opennms.web.controller.outage.OutageBoxController.handleRequestInternal
(OutageBoxController.java:36)
at
org
.springframework
.web
.servlet.mvc.AbstractController.handleRequest(AbstractController.java:
153)
at
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle
(SimpleControllerHandlerAdapter.java:48)
at
org
.springframework
.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
at
org
.springframework
.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807)
at
org
.springframework
.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
at
org
.springframework
.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:
502)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:389)
at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:
216)
at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:
417)
at org.mortbay.jetty.servlet.Dispatcher.include(Dispatcher.java:192)
at
org
.apache
.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:1013)
at org.apache.jsp.index_jsp._jspService(org.apache.jsp.index_jsp:55)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:109)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at
org
.apache
.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:389)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:486)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:380)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:
502)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1157)
at
org
.extremecomponents
.table.filter.AbstractExportFilter.doFilter(AbstractExportFilter.java:
49)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1148)
at
org
.opennms
.web.AddRefreshHeaderFilter.doFilter(AddRefreshHeaderFilter.java:73)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1148)
at
org
.opennms
.web
.StoreRequestPropertiesFilter
.doFilter(StoreRequestPropertiesFilter.java:71)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1148)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
at
org.opennms.web.springframework.security.AuthFilterEnabler.doFilterHttp
(AuthFilterEnabler.java:98)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke
(FilterSecurityInterceptor.java:109)
at
org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter
(FilterSecurityInterceptor.java:83)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security
.ui
.SessionFixationProtectionFilter
.doFilterHttp(SessionFixationProtectionFilter.java:67)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security
.ui
.ExceptionTranslationFilter
.doFilterHttp(ExceptionTranslationFilter.java:101)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security
.providers
.anonymous
.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:
105)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security
.wrapper
.SecurityContextHolderAwareRequestFilter
.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security
.ui
.basicauth
.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security
.ui
.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:
277)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security
.context
.HttpSessionContextIntegrationFilter
.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
at
org
.springframework
.web
.filter
.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
at
org
.springframework
.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:
167)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1148)
at
org
.springframework
.orm
.hibernate3
.support
.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:
198)
at
org
.springframework
.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1148)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:387)
at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:
216)
at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:
417)
at
org
.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:
114)
at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:324)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:
535)
at org.mortbay.jetty.HttpConnection
$RequestHandler.headerComplete(HttpConnection.java:865)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:539)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
at
org
.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:
409)
at org.mortbay.thread.QueuedThreadPool
$PoolThread.run(QueuedThreadPool.java:520)
Caused by: org.hibernate.exception.SQLGrammarException: could not
execute query
at
org
.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:
90)
at
org
.hibernate
.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2231)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)
at
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:
118)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1596)
at sun.reflect.GeneratedMethodAccessor521.invoke(Unknown Source)
at
sun
.reflect
.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.orm.hibernate3.HibernateTemplate
$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.java:1293)
at $Proxy109.list(Unknown Source)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate
$5.doInHibernate(AbstractDaoHibernate.java:212)
at
org
.springframework
.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
... 99 more
Caused by: org.postgresql.util.PSQLException: ERREUR: erreur de
syntaxe sur ou près de « ) »
at
org
.postgresql
.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:
1525)
at
org
.postgresql
.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at
org
.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
188)
at
org
.postgresql
.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org
.postgresql
.jdbc2
.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:
354)
at
org
.postgresql
.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:
258)
at
com
.mchange
.v2
.c3p0
.impl
.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:
76)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:
208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1808)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at
org
.hibernate
.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2228)
... 111 more
Caused by: org.hibernate.exception.SQLGrammarException: could not
execute query
at
org
.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:
90)
at
org
.hibernate
.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2231)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)
at
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:
118)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1596)
at sun.reflect.GeneratedMethodAccessor521.invoke(Unknown Source)
at
sun
.reflect
.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.orm.hibernate3.HibernateTemplate
$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.java:1293)
at $Proxy109.list(Unknown Source)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate
$5.doInHibernate(AbstractDaoHibernate.java:212)
at
org
.springframework
.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
at
org
.springframework
.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:
343)
at
org
.opennms
.netmgt
.dao
.hibernate.AbstractDaoHibernate.findMatching(AbstractDaoHibernate.java:
217)
at
org.opennms.web.outage.DaoWebOutageRepository.getMatchingOutageSummaries
(DaoWebOutageRepository.java:211)
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:597)
at
org
.springframework
.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at
org
.springframework
.aop
.framework
.ReflectiveMethodInvocation
.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at
org
.springframework
.aop
.framework
.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
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 $Proxy68.getMatchingOutageSummaries(Unknown Source)
at
org.opennms.web.controller.outage.OutageBoxController.handleRequestInternal
(OutageBoxController.java:36)
at
org
.springframework
.web
.servlet.mvc.AbstractController.handleRequest(AbstractController.java:
153)
at
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle
(SimpleControllerHandlerAdapter.java:48)
at
org
.springframework
.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
at
org
.springframework
.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807)
at
org
.springframework
.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
at
org
.springframework
.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:
502)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:389)
at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:
216)
at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:
417)
at org.mortbay.jetty.servlet.Dispatcher.include(Dispatcher.java:192)
at
org
.apache
.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:1013)
at org.apache.jsp.index_jsp._jspService(org.apache.jsp.index_jsp:55)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:109)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at
org
.apache
.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:389)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:486)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:380)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:
502)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1157)
at
org
.extremecomponents
.table.filter.AbstractExportFilter.doFilter(AbstractExportFilter.java:
49)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1148)
at
org
.opennms
.web.AddRefreshHeaderFilter.doFilter(AddRefreshHeaderFilter.java:73)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1148)
at
org
.opennms
.web
.StoreRequestPropertiesFilter
.doFilter(StoreRequestPropertiesFilter.java:71)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1148)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
at
org.opennms.web.springframework.security.AuthFilterEnabler.doFilterHttp
(AuthFilterEnabler.java:98)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke
(FilterSecurityInterceptor.java:109)
at
org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter
(FilterSecurityInterceptor.java:83)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security
.ui
.SessionFixationProtectionFilter
.doFilterHttp(SessionFixationProtectionFilter.java:67)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security
.ui
.ExceptionTranslationFilter
.doFilterHttp(ExceptionTranslationFilter.java:101)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security
.providers
.anonymous
.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:
105)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security
.wrapper
.SecurityContextHolderAwareRequestFilter
.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security
.ui
.basicauth
.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security
.ui
.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:
277)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security
.context
.HttpSessionContextIntegrationFilter
.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
at
org
.springframework
.web
.filter
.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
at
org
.springframework
.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:
167)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1148)
at
org
.springframework
.orm
.hibernate3
.support
.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:
198)
at
org
.springframework
.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1148)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:387)
at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:
216)
at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:
417)
at
org
.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:
114)
at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:324)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:
535)
at org.mortbay.jetty.HttpConnection
$RequestHandler.headerComplete(HttpConnection.java:865)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:539)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
at
org
.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:
409)
at org.mortbay.thread.QueuedThreadPool
$PoolThread.run(QueuedThreadPool.java:520)
Caused by: org.postgresql.util.PSQLException: ERREUR: erreur de
syntaxe sur ou près de « ) »
at
org
.postgresql
.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:
1525)
at
org
.postgresql
.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at
org
.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
188)
at
org
.postgresql
.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org
.postgresql
.jdbc2
.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:
354)
at
org
.postgresql
.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:
258)
at
com
.mchange
.v2
.c3p0
.impl
.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:
76)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:
208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1808)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at
org
.hibernate
.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2228)
... 111 more
Caused by: org.postgresql.util.PSQLException: ERREUR: erreur de
syntaxe sur ou près de « ) »
at
org
.postgresql
.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:
1525)
at
org
.postgresql
.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at
org
.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
188)
at
org
.postgresql
.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org
.postgresql
.jdbc2
.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:
354)
at
org
.postgresql
.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:
258)
at
com
.mchange
.v2
.c3p0
.impl
.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:
76)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:
208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1808)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at
org
.hibernate
.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2228)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)
at
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:
118)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1596)
at sun.reflect.GeneratedMethodAccessor521.invoke(Unknown Source)
at
sun
.reflect
.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.orm.hibernate3.HibernateTemplate
$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.java:1293)
at $Proxy109.list(Unknown Source)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate
$5.doInHibernate(AbstractDaoHibernate.java:212)
at
org
.springframework
.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
at
org
.springframework
.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:
343)
at
org
.opennms
.netmgt
.dao
.hibernate.AbstractDaoHibernate.findMatching(AbstractDaoHibernate.java:
217)
at
org.opennms.web.outage.DaoWebOutageRepository.getMatchingOutageSummaries
(DaoWebOutageRepository.java:211)
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:597)
at
org
.springframework
.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at
org
.springframework
.aop
.framework
.ReflectiveMethodInvocation
.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at
org
.springframework
.aop
.framework
.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
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 $Proxy68.getMatchingOutageSummaries(Unknown Source)
at
org.opennms.web.controller.outage.OutageBoxController.handleRequestInternal
(OutageBoxController.java:36)
at
org
.springframework
.web
.servlet.mvc.AbstractController.handleRequest(AbstractController.java:
153)
at
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle
(SimpleControllerHandlerAdapter.java:48)
at
org
.springframework
.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
at
org
.springframework
.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807)
at
org
.springframework
.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
at
org
.springframework
.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:
502)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:389)
at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:
216)
at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:
417)
at org.mortbay.jetty.servlet.Dispatcher.include(Dispatcher.java:192)
at
org
.apache
.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:1013)
at org.apache.jsp.index_jsp._jspService(org.apache.jsp.index_jsp:55)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:109)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at
org
.apache
.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:389)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:486)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:380)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:
502)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1157)
at
org
.extremecomponents
.table.filter.AbstractExportFilter.doFilter(AbstractExportFilter.java:
49)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1148)
at
org
.opennms
.web.AddRefreshHeaderFilter.doFilter(AddRefreshHeaderFilter.java:73)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1148)
at
org
.opennms
.web
.StoreRequestPropertiesFilter
.doFilter(StoreRequestPropertiesFilter.java:71)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1148)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
at
org.opennms.web.springframework.security.AuthFilterEnabler.doFilterHttp
(AuthFilterEnabler.java:98)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke
(FilterSecurityInterceptor.java:109)
at
org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter
(FilterSecurityInterceptor.java:83)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security
.ui
.SessionFixationProtectionFilter
.doFilterHttp(SessionFixationProtectionFilter.java:67)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security
.ui
.ExceptionTranslationFilter
.doFilterHttp(ExceptionTranslationFilter.java:101)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security
.providers
.anonymous
.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:
105)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security
.wrapper
.SecurityContextHolderAwareRequestFilter
.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security
.ui
.basicauth
.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security
.ui
.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:
277)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security
.context
.HttpSessionContextIntegrationFilter
.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
at
org
.springframework
.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org
.springframework
.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
at
org
.springframework
.web
.filter
.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
at
org
.springframework
.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:
167)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1148)
at
org
.springframework
.orm
.hibernate3
.support
.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:
198)
at
org
.springframework
.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1148)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:387)
at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:
216)
at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:
417)
at
org
.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:
114)
at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:324)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:
535)
at org.mortbay.jetty.HttpConnection
$RequestHandler.headerComplete(HttpConnection.java:865)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:539)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
at
org
.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:
409)
at org.mortbay.thread.QueuedThreadPool
$PoolThread.run(QueuedThreadPool.java:520)
</errormessage>
Environment:
- Ubuntu 8.04 Server LTS (Hardy Heron) i386
- java version "1.6.0_07"
Java(TM) SE Runtime Environment (build 1.6.0_07-b06)
Java HotSpot(TM) Client VM (build 10.0-b23, mixed mode, sharing)
- Postgres 8.3.7-0ubuntu8.04.1
- --
Ronny Trommer (Germany)
Web: http://www.open-factory.org
IRC: irc.freenode.org - #opennms
PGP key: 7ED9 1A00 0BD9 EB84 9F63 5808 B1BC E829 E383 98A0
Keyserver: keyserver.pgp.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (Darwin)
iEYEARECAAYFAkoi6yoACgkQsbzoKeODmKC3zwCeIlZOr7g/pwOPrCQooAHAjlx6
o1wAnRIuDdyuvJTiJXbuvFGev4gGiVF4
=WUQ2
-----END PGP SIGNATURE-----
------------------------------------------------------------------------------
Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT
is a gathering of tech-side developers & brand creativity professionals. Meet
the minds behind Google Creative Lab, Visual Complexity, Processing, &
iPhoneDevCamp as they present alongside digital heavyweights like Barbarian
Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ
opennms-devel mailing list
To *unsubscribe* or change your subscription options, see the bottom of this
page:
https://lists.sourceforge.net/lists/listinfo/opennms-devel
