Solved: Re: Reload Operations Monitor failing after August... - Qlik Community

sobhnath · ‎2021-10-28

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.

sobhnath · ‎2021-11-02

Thanks @Maria_Halley - Your suggestion works, after resetting the password, job start working

View solution in original post

Maria_Halley · ‎2021-10-28

@sobhnath

I see that you have created 2 threads about this?

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

sobhnath · ‎2021-10-28

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