Getting error java.lang.StringIndexOutOfBoundsException: String index out of range: -1 while running query report
Statement:- I am tring to generate report which contaiing only 100 characters out of description
Query :
SELECT "wo"."WORKORDERID" AS "Request ID",
substr(wotodesc.FULLDESCRIPTION,1,100) AS "Description",
"rrs"."RESOLUTION" AS "Resolution" FROM "WorkOrder" "wo"
LEFT JOIN "WorkOrderToDescription" "wotodesc" ON "wo"."WORKORDERID"="wotodesc"."WORKORDERID"
LEFT JOIN "RequestResolver" "rrr" ON "wo"."WORKORDERID"="rrr"."REQUESTID" LEFT JOIN "RequestResolution" "rrs" ON "rrr"."REQUESTID"="rrs"."REQUESTID"
WHERE ( "wo"."WORKORDERID" = 238865 ) AND wo.ISPARENT='1'
Error:
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
at java.lang.String.substring(String.java:1927)
at com.adventnet.servicedesk.reports.utils.ReportStabilityUtil.getReportLevel(ReportStabilityUtil.java:205)
at com.adventnet.servicedesk.reports.utils.ReportStabilityUtil.applyReportStabilityRestriction(ReportStabilityUtil.java:440)
at com.adventnet.servicedesk.reports.utils.CoreReportDesigner.generateSQLReport(CoreReportDesigner.java:8164)
at com.adventnet.servicedesk.reports.utils.CoreReportDesigner.generateSQLReport(CoreReportDesigner.java:7976)
at com.adventnet.servicedesk.reports.action.ReportRequestHandler.runSQLQueryReport(ReportRequestHandler.java:1810)
at com.adventnet.servicedesk.reports.action.ReportRequestHandler.handleRequest(ReportRequestHandler.java:2259)
at com.adventnet.servicedesk.reports.action.CustomReportHandler.handleRequest(CustomReportHandler.java:189)