Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks @Maria_Halley - Your suggestion works, after resetting the password, job start working
I see that you have created 2 threads about this?
Did you test the solution from @ AshutoshBhumkar in the other thread?
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
Hello this error seems to be an issue with the service user.
You may follow the below articles to troubleshoot it.
Best Regards
Sooraj Suresh
I would start with this one, even if the error is not the same
https://community.qlik.com/t5/Knowledge/License-and-operation-monitoring-apps-error-401-Unauthorized...
If non of the articles help, I suggest that you create a support case
Thanks @Maria_Halley - Your suggestion works, after resetting the password, job start working