Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i have a problem to reload automaitcally my document with Server Management Console.
If i reload data in QV normally: it work ok.
If i reload data in Management Console click in the Run button: it work ok
but.. when i schedule that reload in managemnet console at the morning i see it do un error, i put the error there:
(2017-09-01 03:46:26) Information: The Source Document reload complete. DocumentPath=C:\ProgramData\QlikTech\Documents\Cruscotti Romagna Energia\Cruscotti\Cruscotto_CDG_EE.qvw (2017-09-01 03:46:26) Information: Memory Allocation Delta for this file=5.12 Mb. Available Physical Memory Before Reload=18278.23 Mb. Available Physical Memory After Reload=18335.61 Mb. Total Physical Memory=18335.61 Mb. (2017-09-01 03:46:26) Error: The Source Document was NOT reloaded successfully. DocumentPath=C:\ProgramData\QlikTech\Documents\Cruscotti Romagna Energia\Cruscotti\Cruscotto_CDG_EE.qvw. (2017-09-01 03:46:26) Information: Closing the document. (2017-09-01 03:46:27) Information: Closed the QlikView Engine successfully. ProcessID=7608 (2017-09-01 03:46:28) Error: The task "Cruscotti Romagna Energia/Cruscotti/Cruscotto_CDG_EE.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=C:\ProgramData\QlikTech\Documents\Cruscotti Romagna Energia\Cruscotti\Cruscotto_CDG_EE.qvw. || in QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult) || in QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || --- Fine della traccia dello stack dell'eccezione interna --- || in QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || in QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) || --- Fine della traccia dello stack dell'eccezione interna --- || in QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) || in QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult) (2017-09-01 03:46:28) Information: Task Execute Duration=05:06:28.0641263 (2017-09-01 03:46:28) Information: TaskResult.status=Finished (2017-09-01 03:46:28) Information: Notifying all triggers of new state:FinishedWithErrors (2017-09-01 03:46:28) Information: Notifying all triggers of new state:FinishedWithErrors - completed (2017-09-01 03:46:28) Information: Saving Task Result |
Hope someone can help me with that error
Hi no error in the script i think the error occour becouse after 6 hours qlik go out of memory, now my script wait 5 hours for finish at it all ok
As you probably found out yourself, the information in the TaskLog isn't very helpful in this case. We may need a look at the DocumentLog, because the message:
(2017-09-01 03:46:26) Error: The Source Document was NOT reloaded successfully.
most probably points to an error while trying to execute the load script. The fact that it works in QV Desktop may mean that the problem has something to do with authorizations.
Can you check the DocumentLog of that failing task run and do a quick search for script errors? Or post the log in this thread if you don't mind posting your script code in a Community forum.
Do you have a sectionaccess implemented in this document?
no
your attachments all shows image icons. Can you upload you document log as Peter suggested in his reply. ?
Ok, but where i can find the log? i not see another log, sorry
Hi i find the log i put there attachments.
Thanks
Your document log is not full, did you terminate the process? Can you run this qvw file again and send us the documentlog again if possible?
Is complete i think, the task again start this night this is the result, look at files thanks
In your QVW load script can you see any other scripts after the below LOAD statement?
Referenti:
LOAD "REFERENTE",
"DES_REFERENTE" ;
SQL
SELECT COD_REFERENTE AS REFERENTE,DES_REFERENTE
FROM "CRE_BI"."AGE_A_REFERENTI_AGENZIA";