Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
silambarasan
Creator II
Creator II

Scheduled task is not running in QMC

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.

Labels (2)
7 Replies
madhumitha
Creator
Creator

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
Creator II
Creator II
Author

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

Chip_Matejowsky
Support
Support

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

Principal Technical Support Engineer with Qlik Support
Help users find answers! Don't forget to mark a solution that worked for you!
askarkhan
Contributor III
Contributor III

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
Contributor III
Contributor III

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
Support
Support

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.

Principal Technical Support Engineer with Qlik Support
Help users find answers! Don't forget to mark a solution that worked for you!
askarkhan
Contributor III
Contributor III

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