topic Re: log files in QlikView

log files

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi ALl ,

My Relasod task keeps failing and below is the following log for this Can someone please explain what is reason of this failure ...

The task "Reload of dev\Project\QVDGEN.qvw" failed. Part of the log file follows:

4/20/2018 8:16:39 AM Error The Source Document was NOT reloaded successfully. DocumentPath=\\Qlkv\dev\Project\QVDGEN.qvw.

4/20/2018 8:16:40 AM Error The task "Reload of dev\Project\QVDGEN.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=\\Qlkv\dev\Project\QVDGEN.qvw

at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

--- End of inner exception stack trace ---

at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

--- End of inner exception stack trace ---

at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

Thanks in Advance

Re: log files

shiveshsingh — Mon, 23 Apr 2018 05:03:49 GMT

Can you manually reload the qvw file and see what error you are getting?

Re: log files

smilingjohn — Mon, 23 Apr 2018 05:20:15 GMT

Hi Shivesh ,

If i relaod manually after fetching around 54 million recods the script end saying unexpected end of data.

but when i reload 2nd times or third time it reload succefully .

I really dont understand this

Re: log files

olivierrobin — Mon, 23 Apr 2018 07:09:57 GMT

hello

maybe a problem of timeout (your reoad may take too much time)

did you check :

the log on qmc ?

the log of the script ?

Re: log files

smilingjohn — Mon, 23 Apr 2018 08:35:44 GMT

Hi Olivier

Withing the script execution the time is mentioned as 1440 mints ,,,

do i need to increse this ?

the log on qmc says under error as fialed exception

Re: log files

olivierrobin — Mon, 23 Apr 2018 08:39:44 GMT

no, 1440 is the time in minutes, so it is one day (24h)

and the log of the script ? (i mean, when you select genrate a script in document properties)

Re: log files

smilingjohn — Mon, 23 Apr 2018 09:26:13 GMT

Hi Robin ,

Thanks for the reply

is there any kind of time out setting in log files ?

i have enabled to generate log and i dont see any time there

with the log file within error it shows failed with exception only ...

i dont know what has to be done .

Thanks

Re: log files

olivierrobin — Mon, 23 Apr 2018 09:32:50 GMT

can you post the part og log showing the code and the error ?

Re: log files

tamilarasu — Mon, 23 Apr 2018 09:35:32 GMT

Hi John,

Sometimes, we are also face this error message. Mostly in the line "SQL select" (statement) from data base. Sometime it fails to load the data but the next run will be successful. I am not sure in which line you are seeing this issue. I would suggest you to read the below link.

https://community.qlik.com/thread/248691#1264234