topic Re: Reload Operations Monitor failing after August 2021 update in QlikView

Reload Operations Monitor failing after August 2021 update

sobhnath — Mon, 26 Jan 2026 18:19:17 GMT

Dear Support,

I recently upgraded my Qlik to August 2021 with sp1, sp2 and sp3. After upgrade all task are running fine but two task (Reload Operations Monitor and Reload License Monitor ) are failing and getting this error

20211018T042903.910-0500 0488
20211018T042903.910-0500 0489 FROM 'lib://ArchivedLogsFolder/xxxxxxx/Scheduler/System/CLSILAPQSS004_Service_Scheduler_2021-10-07T07.40.03Z.log'
20211018T042903.910-0500 0490 (txt, utf8, embedded labels, delimiter is '\t', msq)
20211018T042903.910-0500 0491 WHERE isnum(Sequence#)
20211018T042903.915-0500 Error: Field 'Sequence#' not found
20211018T042904.063-0500 Execution Failed
20211018T042904.308-0500 Execution finished.

Re: Reload Operations Monitor failing after August 2021 update

Maria_Halley — Thu, 28 Oct 2021 08:21:57 GMT

@sobhnath

I see that you have created 2 threads about this?

Did you test the solution from @ AshutoshBhumkar in the other thread?

Re: Reload Operations Monitor failing after August 2021 update

sobhnath — Thu, 28 Oct 2021 12:13:18 GMT

I replicated all the steps suggested after that in the start of Data load I am getting this error

In Data Load at start we are getting this error monitor_app_reload_stats << Operations_Monitor_Reload_Stats_7.16.0 Lines fetched: 4,588 monitor_app_reload_stats << AUTOGENERATE(1) Lines fetched: 4,589 Verifying logging database. Connected ERROR: Connector reply error: *** Working on Monitor App Reload Stats monitor_app_reload_stats << AUTOGENERATE(1) Lines fetched: 4,590 Could not validate active database logging. Sourcing from file logs instead. Last Reload Compare time = 43712. CutoffDate = 2021-07-28. Checking for base qvd Incremental reload of LogContent table (i.e. not first reload) LogContent << governanceLogContent_7.16.0_file The following error occurred: Connector reply error: Unable to connect to database: Connection failed: Please check the values for Username‚ Password‚ Host‚ and other properties. The error occurred here: db_check: SELECT "id" FROM "public"."log_entries" WHERE "entry_timestamp" >= '2021-10-28 05:54:46' Lines fetched: 1,383,450 working << 0b76f364-c07e-4ffd-9856-c576aa562557 Lines fetched: 0 qmc_change_map << df2bdf18-5f7f-4027-9fd2-da13dca5073b Lines fetched: 12

and at the end of data load getting this error

The following error occurred: HTTP protocol error 401 (Unauthorized): Requested resource requires authentication. The error occurred here: RestConnectorMasterTable: SQL SELECT "id" AS "id_u4", "createdDate" AS "createdDate_u0", "modifiedDate" AS "modifiedDate_u0", "modifiedByUserName" AS "modifiedByUserName_u0", "name" AS "name_u3", "publishTime", "published", "description", "fileSize", "lastReloadTime", "availabilityStatus", "__KEY_root", (SELECT "userId", "userDirectory", "__FK_owner" FROM "owner" FK "__FK_owner"), (SELECT "name" AS "name_u2", "__FK_stream" FROM "stream" FK "__FK_stream") FROM JSON (wrap on) "root" PK "__KEY_root" Data has not been loaded. Please correct the error and try loading again. RestConnectorMasterTable << RestConnectorMasterTable

Pls. suggest what to do next