West Midlands Police - ResponseMX

This page contains detailed debug information which can be used by Dottedeyes Support Analysts to help diagnose the problem.

To view this information please click the Show Details button below.
Then either:

Copy and paste the debug information into an email and send it to: support@dottedeyes.com
or print this page and fax it to 01527 556 939
or contact our Customer Services department on 01527 556 920.

Referrer: manual / bookmark

Request: http://www.myneighbourhood.info/myn2/jsp/error.jsp

Detail:

com.dottedeyes.rmx.exceptions.RMXException: Unable to execute com.dottedeyes.myn.data.SpotlightLongTermTrendQuery.
	at com.dottedeyes.rmx.data.query.Query.execute(Query.java:198)
	at com.dottedeyes.rmx.data.query.Query.execute(Query.java:133)
	at com.dottedeyes.myn.data.SpotlightLongTermTrendQuery.execute(SpotlightLongTermTrendQuery.java:20)
	at com.dottedeyes.myn.manager.IncidentManagerImpl.getCrimeLongTermTrend(IncidentManagerImpl.java:723)
	at com.dottedeyes.myn.actions.subpages.LongTermTrend.execute(LongTermTrend.java:51)
	at com.dottedeyes.myn.actions.ParentRegionWizardAction.executeAction(ParentRegionWizardAction.java:227)
	at com.dottedeyes.rmx.actions.BaseAction.execute(BaseAction.java:187)
	at com.dottedeyes.strutsx.action.FlexibleAction.execute(FlexibleAction.java:78)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
	at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
	at com.dottedeyes.myn.web.UntestedDataFilter.checkAndServeRequest(UntestedDataFilter.java:95)
	at com.dottedeyes.myn.web.UntestedDataFilter.doFilter(UntestedDataFilter.java:54)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
	at com.dottedeyes.myn.actions.filters.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:90)
	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:119)
	at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55)
	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:172)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
	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:595)
Caused by: com.dottedeyes.rmx.exceptions.RMXException: resulting query returned 0 rows, should have been 60
	at com.dottedeyes.myn.data.SpotlightLongTermTrendQuery.formResult(SpotlightLongTermTrendQuery.java:74)
	at com.dottedeyes.myn.data.SpotlightLongTermTrendQuery.execute(SpotlightLongTermTrendQuery.java:33)
	at com.dottedeyes.myn.data.SpotlightLongTermTrendQuery.execute(SpotlightLongTermTrendQuery.java:20)
	at com.dottedeyes.rmx.data.query.Query.execute(Query.java:165)
	... 40 more

MyNeighbourhood