Running into the exact same issue also on 9.11.0 (Build 39533) running on a Mac w/ M1.
I fixed a few issues with the OQL given, as several things seemed plain wrong or didn't align with prior instructions:
This is the final OQL I used:
SELECT D/Name DepartmentName, COUNT(S/ShiftId) Number
FROM UserManager.Shift S
JOIN S/UserManager.Shift_Department/UserManager.Department D
LEFT OUTER JOIN S/UserManager.Shift_Employee/UserManager.Employee E
WHERE E/EmployeeId IS NULL
GROUP BY D/Name
Nothing worked and very frustrating that no further details are given... But even simple OQL qeries didn't work like:
SELECT E/Firstname
FROM UserManager.Employee E
Then I updated to 9.11.1 and the error is gone...
Where E.Id IS NULL
copy an
SELECT D.Name DepartmentName,COUNT(S/id) Number FROM UserManager.Shift S JOIN S/UserManager.Shift_Department/UserManager.Department D LEFT OUTER JOIN S/UserManager.Shift_Employee/UserManager.Employee E WHERE E/ID = NULL GROUP BY D.NameSELECT D.Name DepartmentName,COUNT(S/id) Number FROM UserManager.Shift S JOIN S/UserManager.Shift_Department/UserManager.Department D LEFT OUTER JOIN S/UserManager.Shift_Employee/UserManager.Employee E WHERE E/ID = NULL GROUP BY D.Name