Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with System monitor v5.1.23

Hello all,

I have a slight problem with System monitor.

When I reload the application, I get this error message:

Table not found

Master:

Load *,

NoOfRows('OSLogs') AS OSTableFieldCount,

If('' < 1 , '1', '2') AS TESTSingle,

IF(TypeofLog = 'Audit', RGB(42,166,8),

IF(TypeofLog = 'DSC', RGB(0,205,115),

IF(TypeofLog = 'Events', RGB(150,237,137),

IF(TypeofLog = 'HTTPERR', RGB(44,186,234),

If(TypeofLog = 'IIS', RGB(85,221,255),

IF(TypeofLog = 'Performance', RGB(170,215,217),

IF(TypeofLog = 'Pub' , RGB(192,170,192),

IF(TypeofLog = 'QMS', RGB(255,127,0),

IF(TypeofLog = 'Session', RGB(230,159,75),

IF(TypeofLog = 'Webserver', RGB(255,200,135),

IF(TypeofLog = 'Windows - App', RGB(255,255,204),

IF(TypeofLog = 'Windows - Sec', RGB(255,245,141),

IF(TypeofLog = 'Windows - Sys', RGB(255,100,85),

IF(TypeofLog = 'Restart', RGB(0,0,0),

IF(TypeofLog = 'Salesforce', RGB(131,198,238),

IF(TypeofLog = 'SAP', RGB(178,245,54),

IF(TypeofLog = 'Offline', RGB(51,0,51),''

                ))))))))))))))))) AS 'Color1',

               

IF(TypeofLog = 'Pub' AND Sev = 'Failed' OR Sev = 'Error', LightRed(),

IF(Sev = 'Warning', RGB(212,104,18),

IF(TypeofLog = 'Audit', RGB(42,166,8),

IF(TypeofLog = 'DSC', RGB(0,205,115),

IF(TypeofLog = 'Events', RGB(150,237,137),

IF(TypeofLog = 'HTTPERR', RGB(44,186,234),

If(TypeofLog = 'IIS', RGB(85,221,255),

IF(TypeofLog = 'Performance', RGB(170,215,217),

IF(TypeofLog = 'Pub' , RGB(192,170,192),

IF(TypeofLog = 'QMS', RGB(255,127,0),

IF(TypeofLog = 'Session', RGB(230,159,75),

IF(TypeofLog = 'Webserver', RGB(255,200,135),

IF(TypeofLog = 'Windows - App', RGB(255,255,204),

IF(TypeofLog = 'Windows - Sec', RGB(255,245,141),

IF(TypeofLog = 'Windows - Sys', RGB(255,100,85),

IF(TypeofLog = 'Restart', RGB(0,0,0),

IF(TypeofLog = 'Salesforce', RGB(131,198,238),

IF(TypeofLog = 'SAP', RGB(178,245,54),

IF(TypeofLog = 'Offline', RGB(51,0,51),''

                ))))))))))))))))))) AS 'Color2',

If(TypeofLog = 'Restart', White()) AS 'Color3'

Resident MasterTemp

Order by TypeofLog asc

Do you know why is that occurring?

Thanks in advance

0 Replies