Qlik Sense Operations Monitor A problem fetching data from QRS via the REST connector

Andre_Sostizzo — Wed, 02 Jun 2021 18:49:32 GMT

The Qlik Sense Monitoring apps fail to reload with error: "There was a problem fetching data from QRS via the REST connector."

Example:

Load There was a problem fetching data from QRS via the REST connector. Reload terminated. QRS Row Counts:  qrs_user = 0 lines, qrs_app = 0 lines, qrs_appobject = 0 lines, qrs_task = 0 lines,
Error: Syntax error, missing/misplaced FROM:
Execution Failed
Execution finished.

Environment:

, all versions

Resolution:

Qlik REST Connector not available

See Qlik Sense Online Help chapter Troubleshooting - Monitoring a Qlik Sense Site for section Failed to connect to the QRS via the Qlik REST Connector

Incorrect permissions for the service account

The service account running the Qlik Sense Services does not have sufficient access as determined by the security rules to perform the reload..

Assigning the Qlik Sense Service account as a RootAdmin will accomplish this task, but that is a high level of authorization. Minimally this style of security rule should suffice:

In this example the filter applies only to streams (Stream_*) and we are granting read only access (read), setting the condition(s) for this security rule apply only to the UserID of the Qlik Sense Service account, and the context is scoped to only the QMC.

This functionally means that the Qlik Sense Service Account can only read, but do no modifications to streams in the QMC. Example view of this user's access:

If you do not know the service account being used by Qlik Sense, then you will need to login to the the server running Qlik Sense Enterprise, then:

Windows 2012: Start > Search for services.msc

Scroll down to the Qlik Sense Services and note the account running the Qlik Sense Engine service.

article Qlik Sense Operations Monitor A problem fetching data from QRS via the REST connector in Official Support Articles

Qlik Sense Operations Monitor A problem fetching data from QRS via the REST connector

Environment:

Resolution:

Qlik REST Connector not available

Incorrect permissions for the service account