Probel with Reload document with Management Console

[danosoft]

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

[Peter_Cammaert]

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.

[vishsaggi]

Do you have a sectionaccess implemented in this document?

[danosoft]

no

[vishsaggi]

your attachments all shows image icons. Can you upload you document log as Peter suggested in his reply. ?

[danosoft]

Ok, but where i can find the log? i not see another log, sorry

[danosoft]

Hi i find the log i put there attachments.

Thanks

[vishsaggi]

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?

[danosoft]

Is complete i think, the task again start this night this is the result, look at files thanks

[vishsaggi]

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";