Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

d_caprelli
Contributor II

Probel with Reload document with Management Console

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

1 Solution

Accepted Solutions
d_caprelli
Contributor II

Re: Probel with Reload document with Management Console

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

10 Replies

Re: Probel with Reload document with Management Console

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

Re: Probel with Reload document with Management Console

Do you have a sectionaccess implemented in this document?

d_caprelli
Contributor II

Re: Probel with Reload document with Management Console

no

vishsaggi
Esteemed Contributor III

Re: Probel with Reload document with Management Console

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

d_caprelli
Contributor II

Re: Probel with Reload document with Management Console

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

d_caprelli
Contributor II

Re: Probel with Reload document with Management Console

Hi i find the log i put there attachments.

Thanks

vishsaggi
Esteemed Contributor III

Re: Probel with Reload document with Management Console

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?

d_caprelli
Contributor II

Re: Probel with Reload document with Management Console

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

vishsaggi
Esteemed Contributor III

Re: Probel with Reload document with Management Console

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

Community Browser