Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

charly_permadi
New Contributor

Scheduled tasks sometimes completed, but most of the time failed


Hi All,

Attached files are log files from the same QVW file (ReportingSection), one failed (09 Jun 2015 2:08 PM) and one completed (09 Jun 2015 2:41 PM). Snapshot between these two log files in below:

09 Jun 2015 2:08 PM --> failed

2.08.jpg

09 Jun 2015 2:41 PM --> completed

2.40.jpg

I have done the following:

- restart server

- restart all services

- remove and put back the tasks

- check the ODBC setup

Additional information:

- the following is related to the failed tasks, based on QMC --> Status --> Tasks --> Log:

(2015-06-09 14:08:38) Information: The Source Document reload complete. DocumentPath=D:\DATA\PUBLISH\QVD_ReportingSection.qvw

(2015-06-09 14:08:38) Information: Memory Allocation Delta for this file=327.34 Mb. Available Physical Memory Before Reload=15872.05 Mb. Available Physical Memory After Reload=15557.03 Mb. Total Physical Memory=15557.03 Mb.

(2015-06-09 14:08:38) Error: The Source Document was NOT reloaded successfully. DocumentPath=D:\DATA\PUBLISH\QVD_ReportingSection.qvw.

(2015-06-09 14:08:39) Information: Closing the document.

(2015-06-09 14:08:39) Information: Closed the QlikView Engine successfully. ProcessID=3752

(2015-06-09 14:08:39) Error: The task "Publish/QVD_ReportingSection.qvw" failed. Exception:

(2015-06-09 14:08:39) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=D:\DATA\PUBLISH\QVD_ReportingSection.qvw.

(2015-06-09 14:08:39) Error:    at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

(2015-06-09 14:08:39) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2015-06-09 14:08:39) Error:    --- End of inner exception stack trace ---

(2015-06-09 14:08:39) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2015-06-09 14:08:39) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2015-06-09 14:08:39) Error:    --- End of inner exception stack trace ---

(2015-06-09 14:08:39) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2015-06-09 14:08:39) Error:    at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

- the following is related to the completed tasks, based on QMC --> Status --> Tasks --> Log:

(2015-06-09 14:41:22) Information: The Source Document reload complete. DocumentPath=D:\DATA\PUBLISH\QVD_ReportingSection.qvw

(2015-06-09 14:41:22) Information: Memory Allocation Delta for this file=483.43 Mb. Available Physical Memory Before Reload=15855.52 Mb. Available Physical Memory After Reload=15380.64 Mb. Total Physical Memory=15380.64 Mb.

(2015-06-09 14:41:22) Information: The Source Document was reloaded successfully.

(2015-06-09 14:41:22) Information: Reload finished successfully

(2015-06-09 14:41:22) Information: Start saving document

(2015-06-09 14:41:30) Information: Check in document: D:\DATA\PUBLISH\QVD_ReportingSection.qvw

(2015-06-09 14:41:30) Information: Closing the document.

(2015-06-09 14:41:31) Information: Closed the QlikView Engine successfully. ProcessID=2340

(2015-06-09 14:41:31) Information: No distribution required.

(2015-06-09 14:41:31) Information: Task Execute Duration=00:00:50.4024570

(2015-06-09 14:41:31) Information: The task "Publish/QVD_ReportingSection.qvw" finished successfully

(2015-06-09 14:41:31) Information: TaskResult.status=Finished

(2015-06-09 14:41:31) Information: Notifying all triggers of new state:Finished

(2015-06-09 14:41:32) Information: Notifying all triggers of new state:Finished - completed

(2015-06-09 14:41:32) Information: Saving Task Result

Looking forward for your advise what need to be checked to solve the above error.

Thank you in advance.

Best regards,

Charly

4 Replies
jebamalai
Valued Contributor

Re: Scheduled tasks sometimes completed, but most of the time failed

If it runs fine at once and it failed in another instance then it may be because of the server load.Check how many jobs are running during the time you scheduled your job.I hope there is a limitation of the jobs scheduled.

jonas_rezende
Valued Contributor

Re: Scheduled tasks sometimes completed, but most of the time failed

Hi.

Verify if database loses connection to the networking during load.


This error  "QVX_UNEXPECTED_END_OF_DATA" happens when there is crash.


Hope it helps!

simone_spanio
Valued Contributor

Re: Scheduled tasks sometimes completed, but most of the time failed

Hi,

verify if other applications/batch are running when you get the error and if they require/cause a db lock.

It seems that something is using the db when you are loading your qvw.

Let us know.

S.

Re: Scheduled tasks sometimes completed, but most of the time failed

Your SQL Server database is dropping connections (connection closed by remote host). This could be at random (network errors) or systematically (meaning that your SQL server is in trouble)

Two questions:

  • Is SQL Server running on the same machine as QlikView Server (I expect not)
  • "... most of the time failed" Do tasks always fail with the same error?

SQL Server also has log files. Ask your dbadmin to check these logs for any additional messages.

Peter