topic Re: Reload getting failed in QlikView

Reload getting failed

Mon, 25 Apr 2016 09:24:50 GMT

Namaste All,

Could you please help me with this issue..

I am using QV server without Publisher,

My reload is getting failed, All the files, with or without section access implemented on the files, they are getting failed.

The following are the two errors , of a file, there is no section access implemented on this,,,

Error: The Source Document was NOT reloaded successfully. DocumentPath=C:\ProgramData\QlikTech\Documents\Filename.qvw.

(2016-04-25 10:08:00) Information: Closing the document.

(2016-04-25 10:08:00) Information: Closed the QlikView Engine successfully. ProcessID=1800

(2016-04-25 10:08:00) Error: The task "Filename.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\Salts Assembly Leading Metrics-Dashboard V0.1.2.1.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

Thank you

Ganesh

Re: Reload getting failed

Peter_Cammaert — Mon, 25 Apr 2016 09:30:45 GMT

In this case, an excerpt from the TaskLog is useless as the TaskLog will not document script errors. In addition to that, the first line from this excerpt may be the final line that indicates a reload error, so the details may come before that line...

Check/Post the document log instead. That oine will most probably contain the real explanation.

Peter

Re: Reload getting failed

Mon, 25 Apr 2016 09:35:59 GMT

Hi Ganesh,

It seems some condition is failing.

You can check your log files for this reload.

If you dont have the log file for the reload.

Go to Document Properties -> General Tab -> On the right you'll see check boxes.

Check the checkbox stating generate logfile.

Regards,

Anjali Gupta

Re: Reload getting failed

Mon, 25 Apr 2016 09:59:35 GMT

Hi Peter

Thanks for quick reply

Actually, All my files are reloading successfully without any errors on my desktop.. They are not reloading only on the server..

Please find the attached Document log file

Thanks

Re: Reload getting failed

Mon, 25 Apr 2016 10:06:19 GMT

Thanks for the reply

Please find the log file attached to peter above

Thanks

Re: Reload getting failed

arasantorule — Mon, 25 Apr 2016 10:11:50 GMT

Hi Ganesh,

Are the paths for "Source Folders" defined are accessible from the server?

Just to confirm, can you try to load an empty application using the server. If the empty document load is successful, there should be a problem with the folder access for data load.

Thanks.

Re: Reload getting failed

avinashelite — Mon, 25 Apr 2016 10:31:31 GMT

Hi Ganesh,

Please share the Log fie ..which is generated from the server ..so that we can identify the issue

Re: Reload getting failed

Mon, 25 Apr 2016 10:40:36 GMT

Hi All

Please find the attached another document log file for another file

and below is the Task log file in server,

(2016-04-25 10:35:11) Information: Starting task 'FileName2.qvw'. Id:70ad801a-52c3-4ffa-8e54-807347afe946. Triggered by 'ScheduleTrigger'. Id:0094e88d-8650-4401-b3ec-1b13193fec77

(2016-04-25 10:35:11) Information: Entering Task Execution.

(2016-04-25 10:35:11) Information: ClusterID=3

(2016-04-25 10:35:11) Information: QDSID=769f0cb7-0c4a-1c55-fedd-25e797a0a826

(2016-04-25 10:35:11) Information: TaskID=70ad801a-52c3-4ffa-8e54-807347afe946

(2016-04-25 10:35:11) Information: MaxRunTime=06:00:00

(2016-04-25 10:35:11) Information: MachineName=WIN-SO7J5FAMA2G

(2016-04-25 10:35:11) Information: Max attempts:1

(2016-04-25 10:35:11) Information: Current Attempt=0

(2016-04-25 10:35:11) Information: Task Dependencies are OK

(2016-04-25 10:35:11) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2016-04-25 10:35:11) Information: Opening "C:\ProgramData\QlikTech\Documents\AGV Leading Metrics-Dashboard V0.1.qvw"

(2016-04-25 10:35:11) Information: Allocating new QlikView Engine. Current usage count=0 of 2 (of type non-reader).

(2016-04-25 10:35:11) Information: Max retries:5

(2016-04-25 10:35:11) Information: Attempt:01

(2016-04-25 10:35:13) Information: Opened the QlikView Engine successfully. ProcessID=4008

(2016-04-25 10:35:13) Information: Allocated QlikView Engine successfully. Current usage count=1 of 2 (of type non-reader). Ticket number=6394.

(2016-04-25 10:35:13) Information: Loading document "C:\ProgramData\QlikTech\Documents\AGV Leading Metrics-Dashboard V0.1.qvw" (4.10 Mb)

(2016-04-25 10:35:14) Information: Physical FileSize=4.10 Mb. Memory Allocation Delta for this file=26.06 Mb. Available Physical Memory Before Open=2718.23 Mb. Available Physical Memory After Open=2688.65 Mb. Total Physical Memory=4035.43 Mb.

(2016-04-25 10:35:14) Information: Attempted to load the document without data.

(2016-04-25 10:35:14) Information: The document was loaded successfully.

(2016-04-25 10:35:14) Information: Document was opened successfully

(2016-04-25 10:35:14) Information: Starting reload

(2016-04-25 10:35:14) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

(2016-04-25 10:35:14) Information: The Source Document is being reloaded. DocumentPath=C:\ProgramData\QlikTech\Documents\AGV Leading Metrics-Dashboard V0.1.qvw

(2016-04-25 10:35:14) Information: The Source Document reload complete. DocumentPath=C:\ProgramData\QlikTech\Documents\AGV Leading Metrics-Dashboard V0.1.qvw

(2016-04-25 10:35:14) Information: Memory Allocation Delta for this file=1.11 Mb. Available Physical Memory Before Reload=2688.64 Mb. Available Physical Memory After Reload=2685.54 Mb. Total Physical Memory=2685.54 Mb.

(2016-04-25 10:35:15) Information: Reloading.

(2016-04-25 10:35:15) Error: The Source Document was NOT reloaded successfully. DocumentPath=C:\ProgramData\QlikTech\Documents\AGV Leading Metrics-Dashboard V0.1.qvw.

(2016-04-25 10:35:15) Information: Closing the document.

(2016-04-25 10:35:16) Information: Closed the QlikView Engine successfully. ProcessID=4008

(2016-04-25 10:35:16) Error: The task "FileName2.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\AGV Leading Metrics-Dashboard V0.1.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.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || 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)

(2016-04-25 10:35:16) Information: Task Execute Duration=00:00:04.7736084

(2016-04-25 10:35:16) Information: TaskResult.status=Finished

(2016-04-25 10:35:16) Information: Notifying all triggers of new state:FinishedWithErrors

(2016-04-25 10:35:16) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2016-04-25 10:35:16) Information: Saving Task Result

Re: Reload getting failed

Peter_Cammaert — Mon, 25 Apr 2016 10:43:59 GMT

This is a log from when the reload succeeds. We need a log from a reload that fails.

Re: Reload getting failed

Peter_Cammaert — Mon, 25 Apr 2016 10:47:50 GMT

If you encounter the following in the Task Log:

(2016-04-25 10:35:14) Information: Starting reload

(2016-04-25 10:35:14) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

(2016-04-25 10:35:14) Information: The Source Document is being reloaded.

you know that no document log will be generated of this failing task. We need a document log generated during execution of a task that fails.

Re: Reload getting failed

Mon, 25 Apr 2016 10:53:33 GMT

Hi,

Check if you C: drive has space?

Make some more space in you C: drive as the document needs space to save the .qvw

It has happened with me twice, that the task failed without any error just because C: drive doesn't have enough space.

Any completed successfully, after I cleared some space from it.

(You can remove Temporary files, and move some files from C: to 😧 or E: whatever applicable.)

Regards,

Anjali Gupta

Re: Reload getting failed

Mon, 25 Apr 2016 11:25:19 GMT

Hi Peter,

I have enabled the document log file in the server, than i found, file is not connecting to odbc, again removed and configurred, and its working fine.

But, even previously also i tested odbc connection, connection was successfull.. i dont know, what made the difference..

Usually, i dont enable the log file, since, it is genedated every 2 minutres of reload, so i disable that..

May i ask you, whether we can install qlikview server and client on the same windows server machine,, so that i can do the chagnes quickly?

Thank you peter

Re: Reload getting failed

Mon, 25 Apr 2016 11:28:35 GMT

Thank you for all the responses friends...

Re: Reload getting failed

Peter_Cammaert — Mon, 25 Apr 2016 11:30:26 GMT

Yes, you can install QV Desktop on the server machine without any problem. QV Desktop will not interfere with QlikView server operations. And as you already discovered, this brings quite a speedup in last-minute changes (like temporarily enabling log file generation, enabling Section Access and Data reduction which may have been disabled in Development etc.)

Keep in mind that you will need a Named CAL assigned to the service account if you plan to use that account to make any changes to documents hosted by the server.

Best,

Peter

Re: Reload getting failed

mithilesh17 — Mon, 25 Apr 2016 11:31:41 GMT

Dear Ganesh,

Happened with us.

Username from which QV services are running, add that username in section access as ADMIN.

Reload that file manually and save it and after doing this change QMC reload should work.

Regards,

Mithilesh

Re: Reload getting failed

Mon, 25 Apr 2016 11:34:12 GMT

yeah, I have named CAL assigned to my administrator.

Thanks

Peter