Query Report Error - ( run smooth on mssql)

HI,

After upgrade to new 7.5 some of Request has a blank department field so
I am trying to build Query Report to get dept name from master department (departmentdefinition) but the query given below will not run.

im using mssql

SELECT     dbo.WorkOrder.WORKORDERID, dbo.WorkOrder.REQUESTERID, dbo.WorkOrder.DEPTID, dbo.DepartmentDefinition.DEPTNAME AS Depratment,
                      dbo.CategoryDefinition.CATEGORYNAME AS Category, dbo.SubCategoryDefinition.NAME AS SubCategory, dbo.ItemDefinition.NAME AS Item,
                      dbo.UserDepartment.USERID
FROM         dbo.CategoryDefinition INNER JOIN
                      dbo.WorkOrderStates ON dbo.CategoryDefinition.CATEGORYID = dbo.WorkOrderStates.CATEGORYID INNER JOIN
                      dbo.ItemDefinition ON dbo.WorkOrderStates.ITEMID = dbo.ItemDefinition.ITEMID INNER JOIN
                      dbo.SubCategoryDefinition ON dbo.WorkOrderStates.SUBCATEGORYID = dbo.SubCategoryDefinition.SUBCATEGORYID RIGHT OUTER JOIN
                      dbo.WorkOrder ON dbo.WorkOrderStates.WORKORDERID = dbo.WorkOrder.WORKORDERID LEFT OUTER JOIN
                      dbo.DepartmentDefinition INNER JOIN
                      dbo.UserDepartment ON dbo.DepartmentDefinition.DEPTID = dbo.UserDepartment.DEPTID ON
                      dbo.WorkOrder.REQUESTERID = dbo.UserDepartment.USERID

with error :

java.lang.StringIndexOutOfBoundsException: String index out of range: -1 at java.lang.String.substring(Unknown Source) at .............................

please assist

regards