Introduction

In the article Magister, you learned how to integrate Magister with Workspace 365. However, you may run into some issues during configuration or experience issues with the Magister live tile. Keep on reading to troubleshoot these issues.

Error responses

When something goes wrong, for example:

When you have no access rights on a list
The list does not exists
Something is wrong with the query in a list
Parameter is missing or incorrect

You will receive the following response:

```XML
HTTP/1.1 200 OK
Connection: close
Content-Type: text/xml; charset=utf-8
Content-Length: 155
Date: Fri, 09 Dec 2022 10:33:04 GMT

<?xml version="1.0" encoding="utf-8"?>
<Response>
  <Exception>EMGeneralFailure</Exception>
  <ExceptionMsg>Onbekende fout opgetreden</ExceptionMsg>
</Response>
```

When the username/password is incorrect the following response is returned:

```xml
HTTP/1.1 200 OK
Connection: close
Content-Type: text/html; charset=ISO-8859-1
Content-Length: 262
Date: Fri, 09 Dec 2022 10:41:33 GMT
Set-Cookie: Medius.Client.ID=AABB7DF5-7D62-4629-BEAD-281CBDD9E32E

<table><tr><td><b>Result</b></td><td ID="Result">False</td><tr><tr><td><b>ResultMessage</b></td><td ID="ResultMessage">Foutieve combinatie voor gebruikersnaam en wachtwoord opgegeven</td><tr><tr><td><b>SessionToken</b></td><td ID="SessionToken"></td><tr></table>
```

Tile doesn't load grades

If the Magister tile doesn't load grades, then the "Grade Column" has not been created yet. Refer to Create a "Grade column collection" for more information.

Items cannot be retrieved

After setting up Magister, the tiles in Workspace may give an error that items cannot be retrieved (or in Dutch: "Het ophalen van items is mislukt".

There are two possible causes for this:

Magister is the leading identity provider instead of Microsoft Entra ID (previously called Azure AD). This means you cannot use the sis_gebr.adnaam column for the GetPerson list which we use by default.
Refer to the W365_GetPerson_v1 Info section on steps how to resolve this, or see the steps below for a query you can run to test if you can use the default column.
The Workspace 365 IP range has not been correctly whitelisted by Schoolmaster.

Decibel query

You can verify whether you can use the sis_gebr.adnaam column for the GetPerson list by running a query in Decibel.

Open Magister.
Click the Magister logo.
Select Onderhoud.
Select Decibel.
Navigate to Systeem.
Go to ddlijsten.

Under Data, enter the query below:

DECLARE @upn VARCHAR(MAX) = '[email protected]';

SELECT
sis_gebr.idPersoon AS PersonId,
CASE WHEN sis_gebr.idPers IS NOT NULL
THEN true
ELSE false
END
AS IsTeacher,
student.stamnr AS StudentId

FROM sis_gebr
LEFT JOIN sis_leer student ON sis_gebr.idleer = student.idleer

WHERE sis_gebr.adnaam = @upn
AND sis_gebr.heeftToegang = true
AND sis_gebr.bVervallen = false
AND sis_gebr.baccnt_blok = false

Click Query to run the query.
- Note: If the Query button is not visible, maximize the screen.
If Decibel returns the message SQL statement doesn't return rows, keep trying until it returns results (you may have to wait a few minutes).
The query will return three columns: PersonId, IsTeacher and StudentId.
- If there are values listed under these columns, you can use sis_gebr.adnaam:
- If there are no values listed, you cannot use sis_gebr.adnaam and you will need to use sis_gebr.email

Magister