Troubleshooting Magister

Table of Contents

 

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>
```

Back to top

 

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".

Magister_OphalenItemsMislukt.png

There are two possible causes for this:

  1. 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.
  2. 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.

  1. Open Magister.
  2. Click the Magister logo.
  3. Select Onderhoud.
  4. Select Decibel.

    Magister_DecibelOpenen.png
    .

  5. Navigate to Systeem
  6. Go to ddlijsten.
  7. Under Data, enter the query below:
    DECLARE @upn VARCHAR(MAX) = 'EXAMPLE@DOMAIN.COM';

    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
  8. Click Query to run the query.
    • Note: If the Query button is not visible, maximize the screen.

      Magister_QueryVoorbeeld.png

  9. 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).
    Magister_SqlStatementDoesntReturnRows.png

  10. The query will return three columns: PersonId, IsTeacher and StudentId.
    • If there are values listed under these columns, you can use sis_gebr.adnaam:
      Magister_DecibelOutputCorrect.png
    • If there are no values listed, you cannot use sis_gebr.adnaam and you will need to use sis_gebr.email
      Magister_DecibelOutputEmpty.png

Back to top