Scheduled task is not running in QMC

[silambarasan]

Hi,

The scheduled tasks is not running in our qlikview server 12.10(SR4) on time.The schedule task are running on alternate days and we are manually execute it on daily basis.

All the services are up and running.

[madhumitha]

Hi ,

Please check the time zone where your server is mounted.

Also, check if you have entered '1' in the below option in the task triggers

[silambarasan]

Our time zone is correct only.Yes we have already set 1 in the task triggers

[Chip_Matejowsky]

You'll need to review the QDS Root Log for the date of the issue. By default, the Root Logs are stored in %ProgramData%\QlikTech\DistributionService\1\Log (if a single QDS node). The naming convention for the Root Log is "Root_<date>.txt". Within the log, find the name of the task and see what entries are present. If you can, post the Root Log to this thread.

Hope this helps,

Chip

[askarkhan]

hi,

I am also getting same error while few of my files are reloadinf successfully but few are not. below is one of the file which never gets reloaded.

Below is the Root Log of this file.

20-10-2019 06:15:00.3528534 Information Trigger detected. Type=Start, Trigger=ScheduleTrigger, State=1;20-10-2019 06:15:00;Triggered;Unhandled, Task=KALYAN DATA/BASE QVD/TEST.qvw

please suggest some solutions

thanks

[askarkhan]

full root log

20-10-2019 06:15:00.3528534 Information Trigger detected. Type=Start, Trigger=ScheduleTrigger, State=1;20-10-2019 06:15:00;Triggered;Unhandled, Task=BASE FILE/TEST.qvw
20-10-2019 06:15:09.7693902 Error The task "/BASE FILE/TEST.qvw" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=D:\BASE FILE\TEST.qvw. || at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult) || at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || --- End of inner exception stack trace --- || at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) || --- End of inner exception stack trace --- || at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) || at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

[Chip_Matejowsky]

Hello @askarkhan,

The snippet of the Root log you provided contains following: The Source Document was NOT reloaded successfully. DocumentPath=D:\BASE FILE\TEST.qvw, which means that the reload failed at the document level. To further troubleshoot, you'll need to review the document log (also known as the script log) of the QVW associated with this scheduled task. If document logging is enabled, it will be stored in the same directory in which the QVW file is housed. If document logging is not enabled, you will need to open the QVW file in QlikView Developer, click Settings > Document Properties > General tab and ensure the Generate Logfile checkbox is ticked. Then run the reload task so that the document log is generated. See the Qlik Support article "How To Enable QlikView Document Reload Log " for more information.

[askarkhan]

thanks Chip_Matejowsky For your support. from log file I got the issue and have also resolved that. error was in ODBC connection. previously I had made connection with 'User DSN' so QMC was giving error, now I changed and made new connection through 'System DSN' and its working fine now.

hope this help to others also.

thank you