When I try to edit a certain report, I get an error. It will run ok but I cannot edit it.

 

Error:

>>>>>>>>>

[12:59:55:489]|[05-19-2009]|[com.adventnet.servicedesk.tools.AuthenticateNtlm]|[INFO]|[26]|: NTLM Challenge to get postdata from IE After validation|
[12:59:55:489]|[05-19-2009]|[com.adventnet.servicedesk.tools.AuthenticateNtlm]|[INFO]|[26]|: NTLM Challenge to get postdata from IE After validation|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  module = edit_report|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  operation = edit_report|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|: java.lang.NullPointerException|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at com.adventnet.servicedesk.reports.action.ReportRequestHandler.editReport(ReportRequestHandler.java:316)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at com.adventnet.servicedesk.reports.action.ReportRequestHandler.handleRequest(ReportRequestHandler.java:1667)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at com.adventnet.servicedesk.reports.action.CustomReportHandler.handleRequest(CustomReportHandler.java:149)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at com.adventnet.servicedesk.reports.action.ReportHandler.execute(ReportHandler.java:59)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at com.adventnet.servicedesk.filter.EncodingFilter.doFilter(EncodingFilter.java:90)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at com.adventnet.authentication.ContextChangeDetector.doFilter(ContextChangeDetector.java:112)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:158)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at com.adventnet.authentication.CredentialAssociation.invoke(CredentialAssociation.java:75)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at com.adventnet.client.util.LoginParameters.invoke(LoginParameters.java:53)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at com.adventnet.servicedesk.tools.AuthenticateNtlm.invoke(AuthenticateNtlm.java:284)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:444)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:535)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)|
[12:59:55:489]|[05-19-2009]|[SYSOUT]|[INFO]|[26]|:  at java.lang.Thread.run(Unknown Source)|

>>>>>>>>>>>>>

 

SQL Query:

>>>>>>>>>>>>> 

SELECT aau.FIRST_NAME "Requester",aau.FIRST_NAME "Requester",wo.WORKORDERID "Request ID",longtodate(wo.CREATEDTIME) "Created Time",wo.TITLE "Subject",wo.DESCRIPTION "Description" FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE  ((( std.STATUSNAME != 'Closed') AND ( std.STATUSNAME != 'WIP')) AND ( std.STATUSNAME IS NOT NULL))  AND wot.THD_WOID=wot.WORKORDERID  ORDER BY 1

>>>>>>>>>>>>>

 

Any Ideas?