Can't Run Query Reports

Can't Run Query Reports

Hi there,

I have a report in which I need to run with full descriptions instead of a summary. Doing some google searching I found that I could run a query report to accomplish this. However, when adjusting the report to the query editor, I am receiving an error message.

Here is the query I am attempting to run:

  1. SELECT wo.WORKORDERID "Request ID",wo.TITLE "Subject",wo.DESCRIPTION "Description",rrs.RESOLUTION "Resolution",wo.CREATEDTIME "Created Time",wo.COMPLETEDTIME "Completed Time",std.STATUSNAME "Request Status" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN RequestResolver rrr ON wo.WORKORDERID=rrr.REQUESTID LEFT JOIN RequestResolution rrs ON rrr.REQUESTID=rrs.REQUESTID WHERE  (((std.STATUSNAME = 'Closed') AND (((wo.CREATEDTIME >= datetolong('1420099200000') AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL))) AND ((wo.CREATEDTIME <= datetolong('1476428399000') AND (((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL)) AND (wo.CREATEDTIME != -1))))) AND (wo.DEPARTMENTID = 1))  AND wo.ISPARENT='1' 

and here is the error message I am receiving:

  2. java.lang.NullPointerException
  3. at com.adventnet.servicedesk.reports.utils.CoreReportDesigner.generateSQLReport(CoreReportDesigner.java:7948)
  4. at com.adventnet.servicedesk.reports.action.ReportRequestHandler.runSQLQueryReport(ReportRequestHandler.java:1553)
  5. at com.adventnet.servicedesk.reports.action.ReportRequestHandler.handleRequest(ReportRequestHandler.java:1844)
  6. at com.adventnet.servicedesk.reports.action.CustomReportHandler.handleRequest(CustomReportHandler.java:155)
  7. at com.adventnet.servicedesk.reports.action.ReportHandler.execute(ReportHandler.java:59)
  8. at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
  9. at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
  10. at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
  11. at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
  12. at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  13. at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
  14. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
  15. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
  16. at com.adventnet.servicedesk.filter.EncodingFilter.doFilter(EncodingFilter.java:157)
  17. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
  18. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
  19. at com.manageengine.supportcenter.service.NTLMV2CredentialAssociationFilter.doFilter(NTLMV2CredentialAssociationFilter.java:31)
  20. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
  21. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
  22. at com.manageengine.supportcenter.service.NTLMV2Filter.doFilter(NTLMV2Filter.java:152)
  23. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
  24. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
  25. at com.adventnet.authentication.ContextChangeDetector.doFilter(ContextChangeDetector.java:112)
  26. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
  27. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
  28. at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
  29. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
  30. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
  31. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
  32. at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
  33. at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
  34. at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
  35. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
  36. at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
  37. at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66)
  38. at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
  39. at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:158)
  40. at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
  41. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
  42. at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
  43. at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
  44. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
  45. at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
  46. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
  47. at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
  48. at com.adventnet.authentication.CredentialAssociation.invoke(CredentialAssociation.java:75)
  49. at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
  50. at com.adventnet.client.util.LoginParameters.invoke(LoginParameters.java:53)
  51. at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
  52. at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:444)
  53. at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
  54. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:535)
  55. at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
  56. at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
  57. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  58. at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
  59. at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
  60. at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
  61. at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
  62. at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
  63. at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
  64. at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
  65. at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
  66. at java.lang.Thread.run(Unknown Source)

Would anyone be able to assist me in troubleshooting what is going on here?

Thanks,
-Michael Gainor


        New to M365 Manager Plus?
        New to M365 Manager Plus?
          New to RecoveryManager Plus?
          New to RecoveryManager Plus?
            New to Exchange Reporter Plus?
            New to Exchange Reporter Plus?
              New to SharePoint Manager Plus?
              New to SharePoint Manager Plus?
                See all integrations
                New to ADManager Plus?

                  New to ADSelfService Plus?

                  Start your free trial





                            Related Products