[November2018]: Some monitoring apps are not working after update to November 2018 Release

[paolo_mapelli]

Good Morning,

again another time (frequent issue, as far as I know...), upgrading from February 2018 to November 2018, "Operations Monitor" and "Reloads Monitor" are not reloading anymore.

Last rows of Operations Monitor reloading task:

2018-11-16 09:58:51 2043 REM *** *** *** *** ****** ****** *** ***
2018-11-16 09:58:51 2044 CALL reloadSummary
2018-11-16 09:58:51 0885 TRACE Working on Reload Summary
2018-11-16 09:58:51 0885 Working on Reload Summary
2018-11-16 09:58:51 0886
2018-11-16 09:58:51 0887 Reload_1:
2018-11-16 09:58:51 0888 Load
2018-11-16 09:58:51 0889 If([Reload from Hub]=1,TaskId,ProxySessionId) as ProxySessionId,
2018-11-16 09:58:51 0890 LogTimeStamp as [Reload Start],
2018-11-16 09:58:51 0891 If([Reload from Hub]=1,'Reload from Hub of ' & ObjectName,SubField(ObjectName,'|',1)) as [Task Name]
2018-11-16 09:58:51 0892 RESIDENT LogContent
2018-11-16 09:58:51 0893 WHERE TaskExecution = 0 OR [Reload from Hub] = 1
2018-11-16 09:58:51 Error: Field 'Reload from Hub' not found
2018-11-16 09:58:51 Execution Failed
2018-11-16 09:58:51 Execution finished.

Last rows of Reloads Monitor reloading task:

2018-11-16 09:57:35 1310 REM *** *** *** *** *** *** *** *** *** *** ****** *** *** *** *** *** ***
2018-11-16 09:57:35 1311 If NoOfRows('LogContent')=0 Then
2018-11-16 09:57:35 1321 CALL additional_tables
2018-11-16 09:57:35 0583 REM *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
2018-11-16 09:57:35 0584 *** *** *** *** ****** *** *** *** *** *** *** ********* *** *** *** *** *** ***
2018-11-16 09:57:35 0586 REM *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ******************************************
2018-11-16 09:57:35 0587 Reload_Status_Duration:
2018-11-16 09:57:35 0588 NoConcatenate Load
2018-11-16 09:57:35 0589 ExecutionId,
2018-11-16 09:57:35 0590 Interval([Reload Duration],'hh:mm:ss') as [Reload Duration],
2018-11-16 09:57:35 0591 IF([Reload Duration]<1/1440,dual('< 1',1),
2018-11-16 09:57:35 0592 IF([Reload Duration]<11/1440,dual('1 - 10',10),
2018-11-16 09:57:35 0593 IF([Reload Duration]<31/1440,dual('11 - 30',30),
2018-11-16 09:57:35 0594 IF([Reload Duration]<1/24,dual('31 - 60',60), dual('> 60',61)
2018-11-16 09:57:35 0595 )))) as [Reload Duration Bucket],
2018-11-16 09:57:35 0596 [Reload Status]
2018-11-16 09:57:35 0597 Resident LogContent
2018-11-16 09:57:35 0598 Where TaskExecution >=0 and not [Reload from Hub]=1
2018-11-16 09:57:35 Error: Field 'TaskExecution' not found
2018-11-16 09:57:35 Execution Failed
2018-11-16 09:57:35 Execution finished.

Strange thing: QS upgrade ran yesterday and everything (including all monitoring apps) was working fine after that, until a server restart occourred this morning. After this restart above monitoring apps stopped working.

Any ideas on how to solve this?

Thanks in advance.

[Levi_Turner · Accepted solution]

Hey @paolo_mapelli,

Is this article helpful?

Likewise you could use an ErrorMode variable in the load script to ignore the error and see what data gets displayed.

[paolo_mapelli]

Hi Ltu,

absolutely helpful, just needed to "turn the log level in the Sense Management console to Basic" and nothing else to have Operations and Reload Monitor back reloading.

Fun fact: I've NOT changed "audit activity log level" BEFORE upgrading from Feb2018 to Nov2018 so I don't know what changed it.

Thanks again for support and regards.

Paolo.