Qlik Community

Ask a Question

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Document reload failure - successful on manual reload

I have a document that is failing to reload through the distribution server. When I attempt a reload manually in the document itself it executes fine.

Below is the task log showing the errors. If anyone can help resolve this asap it would be much appreciated.

Thanks

Adam

(2014-01-13 10:11:54) Information: MaxRunTime=1.00:00:00

(2014-01-13 10:11:54) Information: MachineName=S32036

(2014-01-13 10:11:54) Information: Max attempts:1

(2014-01-13 10:11:54) Information: Current Attempt=0

(2014-01-13 10:11:54) Information: Task Dependencies are OK

(2014-01-13 10:11:54) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2014-01-13 10:11:54) Information: Opening "D:\S32036\QlikView_Files\Source Documents\Live Documents\UK\Leads\UK Leads.qvw"

(2014-01-13 10:11:54) Information: Allocating new QlikView Engine. Current usagecount=3 of 4

(2014-01-13 10:11:54) Information: Max retries:5

(2014-01-13 10:11:54) Information: Attempt:01

(2014-01-13 10:11:55) Information: Allocated QlikView Engine successfully. Current usagecount=3 of 4, Ticket=711

(2014-01-13 10:11:55) Information: Loading document "D:\S32036\QlikView_Files\Source Documents\Live Documents\UK\Leads\UK Leads.qvw" (70.22 Mb)

(2014-01-13 10:11:55) Information: Physical FileSize=70.22 Mb. Memory Allocation Delta for this file=16.97 Mb. Available Physical Memory Before Open=50980.85 Mb. Available Physical Memory After Open=50937.09 Mb. Total Physical Memory=65535.55 Mb.

(2014-01-13 10:11:55) Information: Attempted to load the document without data.

(2014-01-13 10:11:55) Information: The document was loaded successfully.

(2014-01-13 10:11:55) Information: Document was opened successfully

(2014-01-13 10:11:55) Information: Starting reload

(2014-01-13 10:11:55) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier.

(2014-01-13 10:11:55) Information: Waiting for the document log "D:\S32036\QlikView_Files\Source Documents\Live Documents\UK\Leads\UK Leads.qvw" to become available..

(2014-01-13 10:11:55) Information: The Source Document is being reloaded. DocumentPath=D:\S32036\QlikView_Files\Source Documents\Live Documents\UK\Leads\UK Leads.qvw

(2014-01-13 10:11:55) Information: Found a document log. FileName=D:\S32036\QlikView_Files\Source Documents\Live Documents\UK\Leads\UK Leads.qvw.log

(2014-01-13 10:11:55) Information: Writing documentLog to C:\ProgramData\QlikTech\DistributionService\1\Log\20140113\101154 - UK Leads\DocumentLog.txt

(2014-01-13 10:11:56) Information: Reloading.

(2014-01-13 10:11:57) Information: Reloading..

(2014-01-13 10:11:58) Information: Reloading...

(2014-01-13 10:11:59) Information: Reloading....

(2014-01-13 10:12:00) Information: Reloading.....

(2014-01-13 10:12:01) Information: Reloading......

(2014-01-13 10:12:02) Information: Reloading.......

(2014-01-13 10:12:03) Information: Reloading........

(2014-01-13 10:12:04) Information: Reloading.........

(2014-01-13 10:12:05) Information: Reloading..........

(2014-01-13 10:12:06) Information: Slow down logging. Log every <2> seconds.

(2014-01-13 10:12:06) Information: Reloading

(2014-01-13 10:12:08) Information: Reloading.

(2014-01-13 10:12:10) Information: Reloading..

(2014-01-13 10:12:12) Information: Reloading...

(2014-01-13 10:12:14) Information: Reloading....

(2014-01-13 10:12:16) Information: Reloading.....

(2014-01-13 10:12:18) Information: Reloading......

(2014-01-13 10:12:20) Information: Reloading.......

(2014-01-13 10:12:22) Information: Reloading........

(2014-01-13 10:12:24) Information: Reloading.........

(2014-01-13 10:12:26) Information: Reloading..........

(2014-01-13 10:12:28) Information: Slow down logging. Log every <10> seconds.

(2014-01-13 10:12:28) Information: Reloading

(2014-01-13 10:12:39) Information: Reloading.

(2014-01-13 10:12:49) Information: Reloading..

(2014-01-13 10:12:59) Information: Reloading...

(2014-01-13 10:13:09) Information: Reloading....

(2014-01-13 10:13:19) Information: Reloading.....

(2014-01-13 10:13:29) Information: Reloading......

(2014-01-13 10:13:39) Information: Reloading.......

(2014-01-13 10:13:49) Information: Reloading........

(2014-01-13 10:13:59) Information: Reloading.........

(2014-01-13 10:14:09) Information: Reloading..........

(2014-01-13 10:14:19) Information: Slow down logging. Log every <60> seconds.

(2014-01-13 10:14:19) Information: Reloading

(2014-01-13 10:14:23) Error: The sourcedocument failed to reload.. Exception=System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component.

(2014-01-13 10:14:23) Error:    at QlikView.Doc.DoReload(Int32 _Mode, Boolean _Partial, Boolean _Debug)

(2014-01-13 10:14:23) Error:    at QVBWrapper.Document.Reload(ILogBucket i_LogBucket, Boolean i_MonitorQVBCPUUsage, Boolean i_Partial, Boolean i_ReadDocumentLog)

(2014-01-13 10:14:23) Information: Closing the document.

(2014-01-13 10:14:24) Information: Closed the QlikView Engine successfully. ProcessID=8356

(2014-01-13 10:14:24) Error: The task "UK Leads" failed. Exception:

(2014-01-13 10:14:24) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The sourcedocument failed to reload.. Exception=System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component.

(2014-01-13 10:14:24) Error:    at QlikView.Doc.DoReload(Int32 _Mode, Boolean _Partial, Boolean _Debug)

(2014-01-13 10:14:24) Error:    at QVBWrapper.Document.Reload(ILogBucket i_LogBucket, Boolean i_MonitorQVBCPUUsage, Boolean i_Partial, Boolean i_ReadDocumentLog)

(2014-01-13 10:14:24) Error:    at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

(2014-01-13 10:14:24) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2014-01-13 10:14:24) Error:    --- End of inner exception stack trace ---

(2014-01-13 10:14:24) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2014-01-13 10:14:24) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2014-01-13 10:14:24) Error:    --- End of inner exception stack trace ---

(2014-01-13 10:14:24) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2014-01-13 10:14:24) Error:    at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2014-01-13 10:14:24) Information: Task Execute Duration=00:02:29.9000571

(2014-01-13 10:14:24) Information: Sending Alert mail

(2014-01-13 10:14:25) Information: TaskResult.status=Finished

(2014-01-13 10:14:25) Information: Notifying all triggers of new state:FinishedWithErrors

(2014-01-13 10:14:25) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2014-01-13 10:14:25) Information: Saving Task Result

8 Replies
NareshGuntur
Partner
Partner

Hi Adam,

How much time does it take to reload if you reload it manually?

I doubt the issue is with the distribution as I see the below line in the log.

If you can give the error which it has shown you in the document log file, it will be helpful.

(2014-01-13 10:14:24) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed --->


Cheers,

Naresh


Not applicable
Author

Hi Naresh,

Thanks for the reply.

It takes about 2 minutes to run manually.

I have attached the TaskLog and DocumentLog.

Thanks

Adam

jerrysvensson
Partner
Partner

Check the document log.

The reload seems to fail.

No access to database for Service user?

NareshGuntur
Partner
Partner

If you observe both the log files, till 10:14:21 the document is getting reloaded fine. Document log shows at 10:14:23, the reload gets completed. And if you see the task log, the failure is at the same time. It means that as suspected earlier the issue is with the distribution and that is the reason it is getting reloaded successfully if you reload it manually. It has nothing to do with the document. Please check the server/publisher settings and configuration.

Cheers,

Naresh

Not applicable
Author

Thanks for the reply Jerry.

The weird thing is the document log looks fine. No sign of a failed reload (as far as I'm aware).

Not applicable
Author

Thanks Naresh.

The weird thing is no-one had made any changes to the task, which had been working for months before this.

I tried deleting and creating a new task for the same document but still no issue.

If anyone can help decipher the task log for me with potential settings / config errors that would be great?

Thanks

Adam

morris70
Specialist
Specialist

There are a few thing you could try. First I would make sure that the Service account running the QlikView services on the server has sufficient access rights to the distribution/reload folder. Another thing you could try is to make a new task and check if that reloads, It might seem strange but sometimes this helps.

beristardj
Contributor III
Contributor III

hi Adam:

In my case, I solved it!, starting qv distribution services with an user with administrative privileges on the server, not on the domain.