Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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