Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Not applicable

Re: Document reload failure - successful on manual reload

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

Re: Re: Document reload failure - successful on manual reload

Hi Naresh,

Thanks for the reply.

It takes about 2 minutes to run manually.

I have attached the TaskLog and DocumentLog.

Thanks

Adam

jerrysvensson
Not applicable

Re: Document reload failure - successful on manual reload

Check the document log.

The reload seems to fail.

No access to database for Service user?

nareshguntur
Not applicable

Re: Document reload failure - successful on manual reload

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

Re: Document reload failure - successful on manual reload

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

Re: Document reload failure - successful on manual reload

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
Not applicable

Re: Document reload failure - successful on manual reload

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
Not applicable

Re: Document reload failure - successful on manual reload

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.