Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
mbespartochnyy
Creator III
Creator III

Monitoring Apps Fail at Call QRS data AFTER LogContent table is stored

Hello everyone,

I have just installed a fresh copy of June 2019 SR 3 Qlik Sense on a brand new dev server and noticed that both License Monitor and Operations Monitor apps are failing to reload at the same place. Here's a snippet of the script from log files where tasks fail:

License Monitor

CALL QRS // Call QRS data AFTER LogContent table is stored
LET NumRowsQRS = 0
SET QRS_RowCounts = 'QRS Row Counts: '
For each endpoint in 'monitor_apps_REST_license_user','monitor_apps_REST_license_login','monitor_apps_REST_user','monitor_apps_REST_license_access','monitor_apps_REST_app','monitor_apps_REST_license'
CALL monitor_apps_REST_license_user
Set NumRows_monitor_apps_REST_license_user = 0
License_User_Access_Types:
NoConcatenate Load * Inline [UserId]
1 fields found: UserId,
0 lines fetched
For Each tipo in 'User','Professional','Analyzer'
LET f_unused = '[Unused UserId' & if(tipo='user',']',' User]')
LET f_quarantine = '[Quarantined UserId' & if(tipo='user',']',' User]')
LET tipo_lower = lower(tipo)
LIB CONNECT TO 'monitor_apps_REST_license_user'
Error: Connection aborted (System error: The handle is invalid.)
Execution Failed
Execution finished.

Operations Monitor

CALL QRS // Call QRS data AFTER LogContent table is stored
TRACE Fetching data from Qlik Sense Repository (QRS) database
Fetching data from Qlik Sense Repository (QRS) database

LET NumRowsQRS = 0
SET QRS_RowCounts = 'QRS Row Counts: '
For each endpoint in 'monitor_apps_REST_user','monitor_apps_REST_app','monitor_apps_REST_appobject','monitor_apps_REST_task'
CALL monitor_apps_REST_user
LIB CONNECT TO 'monitor_apps_REST_user_condensed'
Error: Connection aborted (System error: The handle is invalid.)
Execution Failed
Execution finished.

It seems like the there's something wrong with whatever QRS is. Some additional information about environment that I'm running Qlik Sense in:

  • Single node environment
  • Server is offline
    • As in, not allowed to be connected to internet

Has anyone faced this and found a solution? Any idea what I can try to get these apps up and running?

Mikhail B.

10 Replies
HeiniF
Partner - Contributor
Partner - Contributor

If I try and connect to the Connector on its own its not returning any data even though the connection works. 

HeiniF_0-1669021135648.png