Reload Continues Fail

[nuwanhwb87]

Hi All,

My Sheduled Dashboard getting failed continuosly.

Unable to find the reason.

Below with i attached the  Log. Please help

(2021-06-24 18:36:19) Information: Starting task 'QVD Maker/Qv_DrivingDashboards/Production/Production Driving Dashboard OIMS Maker.qvw'. Id:112dfe80-602e-48d3-9c75-fb41bf593830. Triggered by 'TaskCompletedTrigger'. Id:d52e4d78-b766-4a45-bdd2-8afc9794525d

(2021-06-24 18:36:19) Information: Entering Task Execution.

(2021-06-24 18:36:19) Information: ClusterID=1

(2021-06-24 18:36:19) Information: QDSID=102e00b2-0481-6779-3270-ea68a19c0afd

(2021-06-24 18:36:19) Information: TaskID=112dfe80-602e-48d3-9c75-fb41bf593830

(2021-06-24 18:36:19) Information: MaxRunTime=06:00:00

(2021-06-24 18:36:19) Information: MachineName=CMBPAPP003

(2021-06-24 18:36:19) Information: Max attempts:1

(2021-06-24 18:36:19) Information: Current Attempt=0

(2021-06-24 18:36:19) Information: Task Dependencies are OK

(2021-06-24 18:36:19) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2021-06-24 18:36:19) Information: Opening "F:\QLIKVIEW\DATASOURCE\QVDMAKER\Qv_DrivingDashboards\Production\Production Driving Dashboard OIMS Maker.qvw"

(2021-06-24 18:36:19) Information: Allocating new QlikView Engine. Current usage count=2 of 10 (of type non-reader).

(2021-06-24 18:36:19) Information: Max retries:5

(2021-06-24 18:36:19) Information: Attempt:01

(2021-06-24 18:36:20) Information: Opened the QlikView Engine successfully. ProcessID=11876

(2021-06-24 18:36:20) Information: Allocated QlikView Engine successfully. Current usage count=3 of 10 (of type non-reader). Ticket number=9860.

(2021-06-24 18:36:20) Information: Loading document "F:\QLIKVIEW\DATASOURCE\QVDMAKER\Qv_DrivingDashboards\Production\Production Driving Dashboard OIMS Maker.qvw" (0.15 Mb)

(2021-06-24 18:36:20) Information: Physical FileSize=0.15 Mb. Memory Allocation Delta for this file=2.50 Mb. Available Physical Memory Before Open=6253.72 Mb. Available Physical Memory After Open=6253.58 Mb. Total Physical Memory=32767.49 Mb.

(2021-06-24 18:36:20) Information: Attempted to load the document without data.

(2021-06-24 18:36:20) Information: The document was loaded successfully.

(2021-06-24 18:36:20) Information: Document was opened successfully

(2021-06-24 18:36:20) Information: Starting reload

(2021-06-24 18:36:20) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

(2021-06-24 18:36:20) Information: The Source Document is being reloaded. DocumentPath=F:\QLIKVIEW\DATASOURCE\QVDMAKER\Qv_DrivingDashboards\Production\Production Driving Dashboard OIMS Maker.qvw

(2021-06-24 18:36:21) Information: Reloading.

(2021-06-24 18:36:22) Information: Reloading..

(2021-06-24 18:36:23) Information: Reloading...

(2021-06-24 18:36:24) Information: Reloading....

(2021-06-24 18:36:25) Information: Reloading.....

(2021-06-24 18:36:26) Information: Reloading......

(2021-06-24 18:36:27) Information: Reloading.......

(2021-06-24 18:36:28) Information: Reloading........

(2021-06-24 18:36:29) Information: Reloading.........

(2021-06-24 18:36:30) Information: Reloading..........

(2021-06-24 18:36:31) Information: Slow down logging. Log every <2> seconds.

(2021-06-24 18:36:31) Information: Reloading

(2021-06-24 18:36:33) Information: Reloading.

(2021-06-24 18:36:35) Information: Reloading..

(2021-06-24 18:36:37) Information: Reloading...

(2021-06-24 18:36:39) Information: Reloading....

(2021-06-24 18:36:41) Information: Reloading.....

(2021-06-24 18:36:43) Information: Reloading......

(2021-06-24 18:36:45) Information: Reloading.......

(2021-06-24 18:36:47) Information: Reloading........

(2021-06-24 18:36:49) Information: Reloading.........

(2021-06-24 18:36:51) Information: Reloading..........

(2021-06-24 18:36:53) Information: Slow down logging. Log every <10> seconds.

(2021-06-24 18:36:53) Information: Reloading

(2021-06-24 18:37:03) Information: Reloading.

(2021-06-24 18:37:13) Information: Reloading..

(2021-06-24 18:37:24) Information: Reloading...

(2021-06-24 18:37:34) Information: Reloading....

(2021-06-24 18:37:44) Information: Reloading.....

(2021-06-24 18:37:54) Information: Reloading......

(2021-06-24 18:38:04) Information: Reloading.......

(2021-06-24 18:38:14) Information: Reloading........

(2021-06-24 18:38:24) Information: Reloading.........

(2021-06-24 18:38:34) Information: Reloading..........

(2021-06-24 18:38:44) Information: Slow down logging. Log every <60> seconds.

(2021-06-24 18:38:44) Information: Reloading

(2021-06-24 18:39:45) Information: Reloading.

(2021-06-24 18:39:46) Information: The Source Document reload complete. DocumentPath=F:\QLIKVIEW\DATASOURCE\QVDMAKER\Qv_DrivingDashboards\Production\Production Driving Dashboard OIMS Maker.qvw

(2021-06-24 18:39:46) Information: Memory Allocation Delta for this file=53.79 Mb. Available Physical Memory Before Reload=6253.58 Mb. Available Physical Memory After Reload=6169.62 Mb. Total Physical Memory=6169.62 Mb.

(2021-06-24 18:39:47) Error: The Source Document was NOT reloaded successfully. DocumentPath=F:\QLIKVIEW\DATASOURCE\QVDMAKER\Qv_DrivingDashboards\Production\Production Driving Dashboard OIMS Maker.qvw.

(2021-06-24 18:39:47) Information: Closing the document.

(2021-06-24 18:39:47) Information: Closed the QlikView Engine successfully. ProcessID=11876

(2021-06-24 18:39:47) Error: The task "QVD Maker/Qv_DrivingDashboards/Production/Production Driving Dashboard OIMS Maker.qvw" failed. Exception:

(2021-06-24 18:39:47) 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=F:\QLIKVIEW\DATASOURCE\QVDMAKER\Qv_DrivingDashboards\Production\Production Driving Dashboard OIMS Maker.qvw.

(2021-06-24 18:39:47) Error: at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

(2021-06-24 18:39:47) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2021-06-24 18:39:47) Error: --- End of inner exception stack trace ---

(2021-06-24 18:39:47) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2021-06-24 18:39:47) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2021-06-24 18:39:47) Error: --- End of inner exception stack trace ---

(2021-06-24 18:39:47) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2021-06-24 18:39:47) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2021-06-24 18:39:47) Information: Task Execute Duration=00:03:27.7971816

(2021-06-24 18:39:47) Information: TaskResult.status=Finished

(2021-06-24 18:39:47) Information: Notifying all triggers of new state:FinishedWithErrors

(2021-06-24 18:39:47) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2021-06-24 18:39:47) Information: Saving Task Result

[Lucas_Gatling]

@nuwanhwb87  Can you please provide a copy of the document log so we can a see a more detailed error message
?

[Chip_Matejowsky]

@nuwanhwb87,

The key entry from the QDS Task log you posted is

(2021-06-24 18:39:47) Error: The Source Document was NOT reloaded successfully. DocumentPath=F:\QLIKVIEW\DATASOURCE\QVDMAKER\Qv_DrivingDashboards\Production\Production Driving Dashboard OIMS Maker.qvw.

This indicates that the failure occurred at the document level and the issue has to do with the load script, data connection, etc. and not at the QDS/Publisher lever or when task is in distribution phase.

As Lucas indicated, you'd want to review the Document log (aka Script log) for errors.  If document logging is enabled, the log 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 and Timestamp in Logfile Name checkboxes are ticked. Then run the reload task so that the document log is generated.  Refer to article How to Get the Qlikview Desktop Logs
for more details.

Best Regards

[nuwanhwb87]

Hi ,

Here with i attached the Log file for reference.

[Chip_Matejowsky · Accepted solution]

Hi @nuwanhwb87,

I reviewed the document log you attached but it looks to have completed successfully without any errors or warnings.  Is the issue still occurring?  If so, can you please upload the document log with the most recent failure?  Thanks!

Best Regards

[Chip_Matejowsky]

Hi @DennisClayton,

You're experiencing a reload failure which the task log shows the Error: The Source Document was NOT reloaded successfully error?  If yes, then same thing - ensure that document logging is enabled on the QVW, run the reload task again and review the document log for failures/warnings (typically at the end or close to the end of the log).  If you want, you can certainly attach the document log to this thread.

Best Regards

[nuwanhwb87]

Hi,

Below with i attached a print screen. Log file (PD OIMS Maker.qvw) unable to attach here(community).

below error message occur. Therefore attached in to a Zip folder. Please check.

[nuwanhwb87]

Hi,

I'm here attached the log file of manual run as wel .

Please help

[Chip_Matejowsky]

Hi @nuwanhwb87,

So the major discrepancy I can see between the two log files you provided is the QV product version.  The product version of the first log you provided [PD OIMs Maker.qvw.log] is 11.20.12235.  The product version of the second log you provided [PD OIMs Maker(Manual Run).qvw.log] is 12.50.20100.  So this is a gap of 5 major release versions.  The versions on which QVWs are created should match the QVS version.  Such a large discrepancy in versions may have corrupted the QVW.  Once you get the product versions the same, test again.  Also please note that the 11.20 version reached end of life for support on 12/31/20 - Qlik Sense, QlikView, and NPrinting End of Support Date.

Best Regards 

[nuwanhwb87]

Hi,

Is that means any version difference. between first log creation and this second manual run.

If i created this file as a new and schedule .Is it will be ok???

Thanks,

Nuwan