Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Aug 9, 2022 5:41:15 AM
Aug 9, 2022 5:41:15 AM
A Qlik Sense reload task is stuck in the Triggered state. All services are otherwise running and other tasks are executing and finishing correctly.
Reviewing the Qlik Sense Scheduler logs shows:
Execution session found during resume is not running in any slave scheduler and will be deleted
and/or
Unexpected exception in Delete for Entity ExecutionSession with Id < >
SELECT
"ExecutionSessions"."ID",
"ExecutionSessions"."AbortAt",
"ExecutionSessions"."Retries",
"ExecutionSessions"."AbortReason",
"ExecutionSessions"."User",
"ExecutionSessions"."CreatedDate",
"ExecutionSessions"."ModifiedDate",
"ExecutionSessions"."SyncDate",
"ExecutionSessions"."ModifiedByUserName",
"ExecutionSessions"."App_ID",
"ExecutionSessions"."ExecutingNode_ID",
"ExecutionSessions"."ExecutionResult_ID",
"ExecutionSessions"."ReloadTask_ID",
"ExecutionSessions"."UserSyncTask_ID",
"ExecutionSessions"."ExternalProgramTask_ID"
FROM
public."ExecutionSessions";
ERROR: syntax error at or near ""ExecutionSessions""
LINE 1: "ExecutionSessions"."SyncDate",
^
SQL state: 42601
Character: 3
DELETE
FROM
public."ExecutionSessions";
Corruption may occur due to:
This can look like this in the repository database:
We had this issue in our multi node Nov 2022 environment, following an issue where the worker node stopped functioning and was replaced with a new.
For us the solution was a bit simpler:
We restarted the Repository service on the central node, which first failed because it could not stop the Scheduler service. After killing the Scheduler.exe process we could restart the Repository service and all services. This fixed the issue and the tasks status were changed to "Reset"