Recently upgraded from 7022 to 7514, and now found that some of our custom query reports no longer work.

Just throw Java errrors.

Please advise how to fix the report, I guess some fields have moved tables.

Query:

select
sI.workstationname as "Computer",
ress.displaystate as "State",
swl.SoftwareName as "Software",
swl.filevendor as "Manufacturer"
FROm
systeminfo as si 
LEFT JOIN softwareinfo as SWI ON si.workstationid = swi.workstationid
LEFT JOIN resources as res on res.resourceid = si.workstationid
LEFT JOIN resourcestate as ress on res.resourcestateid = ress.resourcestateid 
LEFT JOIN softwarelist as swl ON swi.softwareid = swl.softwareid
where
ress.displaystate <> 'Disposed' and
(
(swl.SOFTWARENAME like '%Office Project%' and swl.SOFTWARENAME not like '%server%') or
swl.SOFTWARENAME like '%Office access%' or
swl.SOFTWARENAME like '%Office visio%' or
(swl.SOFTWARENAME like '%Adobe Acrobat%' and swl.SOFTWARENAME not like '%reader%') or
swl.SOFTWARENAME like '%illustrator%' or
swl.SOFTWARENAME like '%pagemaker%' or
(swl.SOFTWARENAME like '%photoshop%' and swl.SOFTWARENAME not like '%starter%' and swl.SOFTWARENAME not like 'adobe color%') or
swl.SOFTWARENAME like '%autocad%' or
swl.SOFTWARENAME like '%winfax%' or
swl.SOFTWARENAME like '%zetafax outlook%' or
swl.SOFTWARENAME like '%hummingbird%' or
swl.SOFTWARENAME like '%scansoft PDF%' or
swl.SOFTWARENAME like '%nuance PDF%' or
swl.SOFTWARENAME like '%reflection%'
)
order by swl.softwarename, si.workstationname

>> ERROR:

java.lang.StringIndexOutOfBoundsException: String index out of range: -1
    at java.lang.String.substring(Unknown Source)
    at com.adventnet.servicedesk.reports.utils.ReportUtil.parseDateColumns(ReportUtil.java:2103)
    at com.adventnet.servicedesk.reports.utils.CoreReportDesigner.generateSQLReport(CoreReportDesigner.java:7515)
    at com.adventnet.servicedesk.reports.action.ReportRequestHandler.runSQLQueryReport(ReportRequestHandler.java:1546)
    at com.adventnet.servicedesk.reports.action.ReportRequestHandler.handleRequest(ReportRequestHandler.java:1838)
    at com.adventnet.servicedesk.reports.action.CustomReportHandler.handleRequest(CustomReportHandler.java:149)
    at com.adventnet.servicedesk.reports.action.ReportHandler.execute(ReportHandler.java:59)
    at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
    at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
    at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
    at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
    at com.adventnet.servicedesk.filter.EncodingFilter.doFilter(EncodingFilter.java:90)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
    at com.adventnet.authentication.ContextChangeDetector.doFilter(ContextChangeDetector.java:112)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
    at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
    at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:158)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
    at com.adventnet.authentication.CredentialAssociation.invoke(CredentialAssociation.java:75)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
    at com.adventnet.client.util.LoginParameters.invoke(LoginParameters.java:53)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
    at com.adventnet.servicedesk.tools.AuthenticateNtlm.invoke(AuthenticateNtlm.java:285)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
    at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:444)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:535)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
    at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
    at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
    at java.lang.Thread.run(Unknown Source)
<<<<

Kind Regards,