Sometimes I get an Exception when clicking on "Ops Panel" in the Ops Dashboard

Description

Sometimes I get a Vaadin Exception when clicking on "Ops Panel" in the Ops Dashboard.

See atached screenshots for details.

Properties:

Exception:

com.vaadin.server.ServerRpcManager$RpcInvocationException: Unable to invoke method click in com.vaadin.shared.ui.button.ButtonServerRpc at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:170) at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:118) at com.vaadin.server.communication.ServerRpcHandler.handleBurst(ServerRpcHandler.java:214) at com.vaadin.server.communication.ServerRpcHandler.handleRpc(ServerRpcHandler.java:111) at com.vaadin.server.communication.UidlRequestHandler.synchronizedHandleRequest(UidlRequestHandler.java:91) at com.vaadin.server.SynchronizedRequestHandler.handleRequest(SynchronizedRequestHandler.java:37) at com.vaadin.server.VaadinService.handleRequest(VaadinService.java:1371) at com.vaadin.server.VaadinServlet.service(VaadinServlet.java:238) at org.ops4j.pax.vaadin.internal.extender.ApplicationFactoryServiceTracker$FactoryServlet.service(ApplicationFactoryServiceTracker.java:88) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.opennms.container.web.felix.base.internal.handler.ServletHandler.doHandle(ServletHandler.java:101) at org.opennms.container.web.felix.base.internal.handler.ServletHandler.handle(ServletHandler.java:84) at org.opennms.container.web.felix.base.internal.dispatch.ServletPipeline.handle(ServletPipeline.java:43) at org.opennms.container.web.felix.base.internal.dispatch.InvocationFilterChain.doFilter(InvocationFilterChain.java:52) at org.opennms.container.web.felix.base.internal.dispatch.HttpFilterChain.doFilter(HttpFilterChain.java:35) at org.opennms.container.web.felix.base.internal.dispatch.FilterPipeline.dispatch(FilterPipeline.java:50) at org.opennms.container.web.felix.base.internal.dispatch.Dispatcher.dispatch(Dispatcher.java:42) at org.opennms.container.web.bridge.internal.DispatcherFilter.doFilter(DispatcherFilter.java:72) at org.opennms.container.web.ProxyFilter.doFilter(ProxyFilter.java:56) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1288) at org.extremecomponents.table.filter.AbstractExportFilter.doFilter(AbstractExportFilter.java:49) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1288) at org.opennms.web.servlet.StoreRequestPropertiesFilter.doFilter(StoreRequestPropertiesFilter.java:79) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1288) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.opennms.web.springframework.security.AuthFilterEnabler.doFilter(AuthFilterEnabler.java:108) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1288) at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:233) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1288) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1288) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:443) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:556) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:227) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1044) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:372) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:189) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:978) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:255) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) at org.eclipse.jetty.server.Server.handle(Server.java:365) at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:486) at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:944) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1005) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:865) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240) at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:667) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543) at java.lang.Thread.run(Thread.java:724) Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.GeneratedMethodAccessor576.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:168) ... 82 more Caused by: com.vaadin.event.ListenerMethod$MethodException: Invocation of method buttonClick in org.opennms.features.vaadin.dashboard.ui.HeaderLayout$2 failed. at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:528) at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:167) at com.vaadin.server.AbstractClientConnector.fireEvent(AbstractClientConnector.java:969) at com.vaadin.ui.Button.fireClick(Button.java:368) at com.vaadin.ui.Button$1.click(Button.java:57) ... 86 more Caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.alarmId as alarmId16_4_, this_.tticketId as tticketId16_4_, this_.tticketState as tticketS3_16_4_, this_.alarmAckTime as alarmAck4_16_4_, this_.alarmAckUser as alarmAck5_16_4_, this_.alarmType as alarmType16_4_, this_.applicationDN as applicat7_16_4_, this_.clearKey as clearKey16_4_, this_.counter as counter16_4_, this_.description as descrip10_16_4_, this_.dpName as dpName16_4_, this_.eventParms as eventParms16_4_, this_.firstAutomationTime as firstAu12_16_4_, this_.firstEventTime as firstEv13_16_4_, this_.ifIndex as ifIndex16_4_, this_.ipAddr as ipAddr16_4_, this_.lastAutomationTime as lastAut16_16_4_, this_.lastEventId as lastEve34_16_4_, this_.lastEventTime as lastEve17_16_4_, this_.logmsg as logmsg16_4_, this_.managedObjectInstance as managed19_16_4_, this_.managedObjectType as managed20_16_4_, this_.mouseOverText as mouseOv21_16_4_, this_.nodeId as nodeId16_4_, this_.operinstruct as operins22_16_4_, this_.ossPrimaryKey as ossPrim23_16_4_, this_.qosAlarmState as qosAlar24_16_4_, this_.reductionKey as reducti25_16_4_, this_.serviceid as serviceid16_4_, this_.severity as severity16_4_, this_.stickymemo as stickymemo16_4_, this_.suppressedTime as suppres27_16_4_, this_.suppressedUntil as suppres28_16_4_, this_.suppressedUser as suppres29_16_4_, this_.eventUEI as eventUEI16_4_, this_.x733AlarmType as x31_16_4_, this_.x733ProbableCause as x32_16_4_, node1_.nodeId as nodeId35_0_, node1_.nodeCreateTime as nodeCrea2_35_0_, node1_.dpName as dpName35_0_, node1_.foreignId as foreignId35_0_, node1_.foreignSource as foreignS4_35_0_, node1_.nodeLabel as nodeLabel35_0_, node1_.nodeLabelSource as nodeLabe6_35_0_, node1_.lastCapsdPoll as lastCaps7_35_0_, node1_.nodeDomainName as nodeDoma8_35_0_, node1_.nodeNetBIOSName as nodeNetB9_35_0_, node1_.operatingSystem as operati10_35_0_, node1_.nodeParentID as nodePar18_35_0_, node1_.nodeSysContact as nodeSys11_35_0_, node1_.nodeSysDescription as nodeSys12_35_0_, node1_.nodeSysLocation as nodeSys13_35_0_, node1_.nodeSysName as nodeSys14_35_0_, node1_.nodeSysOID as nodeSysOID35_0_, node1_.nodeType as nodeType35_0_, node1_1_.criticalPathIp as critical1_36_0_, node1_1_.criticalPathServiceName as critical2_36_0_, onmsreduct4_.id as id33_1_, onmsreduct4_.author as author33_1_, onmsreduct4_.body as body33_1_, onmsreduct4_.created as created33_1_, onmsreduct4_.updated as updated33_1_, onmsreduct4_.reductionkey as reductio7_33_1_, onmsservic5_.serviceId as serviceId40_2_, onmsservic5_.serviceName as serviceN2_40_2_, onmsmemo6_.id as id33_3_, onmsmemo6_.author as author33_3_, onmsmemo6_.body as body33_3_, onmsmemo6_.created as created33_3_, onmsmemo6_.updated as updated33_3_, onmsmemo6_.reductionkey as reductio7_33_3_, onmsmemo6_.type as type33_3_ from alarms this_ left outer join node node1_ on this_.nodeId=node1_.nodeId left outer join pathOutage node1_1_ on node1_.nodeId=node1_1_.nodeId left outer join memos onmsreduct4_ on this_.reductionKey=onmsreduct4_.reductionkey and onmsreduct4_.type='ReductionKeyMemo' left outer join service onmsservic5_ on this_.serviceid=onmsservic5_.serviceId left outer join memos onmsmemo6_ on this_.stickymemo=onmsmemo6_.id where 0 order by this_.alarmId desc]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:635) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411) at org.springframework.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:343) at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate.findMatching(AbstractDaoHibernate.java:290) at Proxy11cc80f0_32ba_4d6f_bd38_2a831b09caf3.findMatching(Unknown Source) at org.opennms.features.topology.plugins.browsers.OnmsDaoContainer.getItemsForCache(OnmsDaoContainer.java:591) at org.opennms.features.topology.plugins.browsers.OnmsDaoContainer$Cache.reload(OnmsDaoContainer.java:195) at org.opennms.features.topology.plugins.browsers.SelectionAwareTable.resetPageBuffer(SelectionAwareTable.java:131) at com.vaadin.ui.Table.refreshRowCache(Table.java:2638) at com.vaadin.ui.Table.markAsDirtyRecursive(Table.java:1843) at org.opennms.features.vaadin.dashboard.dashlets.AlarmDetailsDashlet$2.refresh(AlarmDetailsDashlet.java:233) at org.opennms.features.vaadin.dashboard.dashlets.AlarmDetailsDashlet$2.<init>(AlarmDetailsDashlet.java:212) at org.opennms.features.vaadin.dashboard.dashlets.AlarmDetailsDashlet.getDashboardComponent(AlarmDetailsDashlet.java:160) at org.opennms.features.vaadin.dashboard.ui.dashboard.DashboardBody.setDashletSpecs(DashboardBody.java:174) at org.opennms.features.vaadin.dashboard.ui.dashboard.DashboardView.enter(DashboardView.java:62) at com.vaadin.navigator.Navigator.navigateTo(Navigator.java:571) at com.vaadin.navigator.Navigator.navigateTo(Navigator.java:526) at org.opennms.features.vaadin.dashboard.ui.HeaderLayout$2.buttonClick(HeaderLayout.java:96) at sun.reflect.GeneratedMethodAccessor577.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:508) ... 90 more Caused by: org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.doList(Loader.java:2545) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) at org.hibernate.loader.Loader.list(Loader.java:2271) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716) at sun.reflect.GeneratedMethodAccessor330.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.springframework.orm.hibernate3.HibernateTemplate$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.java:1282) at com.sun.proxy.$Proxy104.list(Unknown Source) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347) at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate$5.doInHibernate(AbstractDaoHibernate.java:287) at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate$5.doInHibernate(AbstractDaoHibernate.java:282) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406) ... 110 more Caused by: org.postgresql.util.PSQLException: ERROR: argument of WHERE must be type boolean, not type integer Position: 3153 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302) 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:1953) at org.hibernate.loader.Loader.doQuery(Loader.java:802) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) at org.hibernate.loader.Loader.doList(Loader.java:2542) ... 123 more

Acceptance / Success Criteria

None

Attachments

3

blocks

Lucidchart Diagrams

Activity

Show:

Christian Pape October 21, 2014 at 1:35 AM

An InRestriction without values caused the
exceptions. It's fixed with commit
179979432988e34697d6437b541f37de7adcd8c5

Fixed

Details

Assignee

Reporter

Components

Fix versions

Priority

PagerDuty

Created October 16, 2014 at 9:55 AM
Updated October 21, 2014 at 1:35 AM
Resolved October 21, 2014 at 1:35 AM