java.lang.StringIndexOutOfBoundsException: String index out of range: -1

When I take a query from SSMS (SQL Server) into a New Query in Service Desk, I almost always get this error: 'java.lang.StringIndexOutOfBoundsException: String index out of range: -1'

I frequently see posts like this, where a replacement query is provided. I'm having trouble telling what changes are made. I found that it looks like schema is an issue, so I removed schema, but still get the error as well as using the AS function to rename a field. Also, date formatting seems to be an issue, so I just removed it altogether, I'll have to fix that later of course.

I would appreciate help with this query, but I'd like even better to be able to know what to do to fix the queries myself.

Thanks in advance for any help!

Here's my current example:

SELECT
PD.PROJECTID
,PD.PROJECTCODE
,PD.TITLE
,PRJTDEF.PROJECTTYPENAME
,PDOWNU.FIRST_NAME "OWNER_NAME"
,PR.ROLENAME
,PMAU.FIRST_NAME "PROJECT_MEMBER_NAME" --HOLDS FIRST AND LAST NAME
,PRTYDEF.PRIORITYNAME
,PD.DURATION
,PS.STATUSNAME
,PDCRTU.FIRST_NAME "CREATED_BY_NAME"
,PD.CREATEDTIME
,PD.SCHEDULEDSTARTTIME
,PD.SCHEDULEDENDTIME
,PD.ACTUALSTARTTIME
,PD.ACTUALENDTIME
,PD.PROJECTEDEND
,SDO.NAME "SITE_NAME"
,PRJTEMP.TITLE
,PDREQUU.FIRST_NAME "REQUESTED_BY_NAME"
,DEPTDEF.DEPTNAME
FROM ProjectDetails PD
LEFT OUTER JOIN ProjectMembers PM ON PD.PROJECTID = PM.PROJECTID --MEMBER_ID NOT USED ELSEWHERE
LEFT OUTER JOIN ProjectRoles PR ON PM.PROJECTROLEID = PR.ROLEID --PROJECT MEMBER ROLE LOOKUP
LEFT OUTER JOIN ProjectStatus PS ON PD.STATUSID = PS.STATUSID --PROJECT STATUS LOOKUP
LEFT OUTER JOIN PriorityDefinition PRTYDEF ON PD.PRIORITYID = PRTYDEF.PRIORITYID --PRIORITY LOOKUP
LEFT OUTER JOIN ProjectTypeDefinition PRJTDEF ON PD.PROJECTTYPEID = PRJTDEF.PROJECTTYPEID --PROJECT TYPE LOOKUP
LEFT OUTER JOIN ProjectTemplate PRJTEMP ON PD.PROJECTTEMPLATEID = PRJTEMP.PROJECTTEMPLATEID --TEMPLATE LOOKUP
LEFT OUTER JOIN AaaUser PMAU ON PM.USERID = PMAU.USER_ID -- PROJECT MEMBER LOOKUP
LEFT OUTER JOIN AaaUser PDCRTU ON PD.CREATEDBY = PDCRTU.USER_ID --PROJECT CREATED BY
LEFT OUTER JOIN AaaUser PDOWNU ON PD.OWNERID = PDOWNU.USER_ID --PROJECT CREATED BY
LEFT OUTER JOIN AaaUser PDREQUU ON PD.OWNERID = PDREQUU.USER_ID --PROJECT REQUESTED BY USER
LEFT OUTER JOIN DepartmentDefinition DEPTDEF ON PD.DEPARTMENTID = DEPTDEF.DEPTID --DEPARTMENT LOOKUP
LEFT OUTER JOIN SiteDefinition SDEF ON PD.SITEID = SDEF.SITEID --SITE LOOKUP --USE SDOrganization FOR SITE NAME
LEFT OUTER JOIN SDOrganization SDO ON SDEF.SITEID = SDO.ORG_ID --SITE NAME LOOKUP
WHERE 1=1
AND PRJTDEF.PROJECTTYPENAME = 'Funnel'
AND PS.STATUSNAME NOT IN ('Cancelled','Closed','Completed')