Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

israrkhan
Valued Contributor II

Publisher>> Reload Task take failed...

Dear Community members

we are facing an issue, our  Publisher task are hanging.

here is the log file, if one can share the thoughts.........

would be highly appreciated......

.................................................................................................................................................................................

9/9/2014 13:03:22.3994955InformationStarting task 'SGH Aseer Daily  Target'. Id:c0d59ed6-156f-4b23-9598-8085759e5b0a. Triggered by 'ScheduleTrigger'. Id:00f7af3e-d6eb-43b4-8b45-919d2724b2ed
9/9/2014 13:03:22.4150957InformationEntering Task Execution.
9/9/2014 13:03:22.4150957InformationClusterID=1
9/9/2014 13:03:22.4150957InformationQDSID=cd6b1ea4-2fdc-3063-265d-c93fe61abf22
9/9/2014 13:03:22.4150957InformationTaskID=c0d59ed6-156f-4b23-9598-8085759e5b0a
9/9/2014 13:03:22.4150957InformationMaxRunTime=1.00:00:00
9/9/2014 13:03:22.4150957InformationMachineName=BITOOLS
9/9/2014 13:03:22.4150957InformationMax attempts:1
9/9/2014 13:03:22.4150957InformationCurrent Attempt=0
9/9/2014 13:03:22.4150957InformationTask Dependencies are OK
9/9/2014 13:03:22.4150957InformationDocument is marked to be Reloaded with fresh data. Initializing Reload for Distribution.
9/9/2014 13:03:22.4150957InformationOpening "F:\Qlink-Data\QlikView DATA\Target.qvw"
9/9/2014 13:03:22.4150957InformationAllocating new QlikView Engine. Current usage count=6 of 30 (of type non-reader).
9/9/2014 13:03:22.4150957InformationMax retries:5
9/9/2014 13:03:22.4150957InformationAttempt:01
9/9/2014 13:03:22.6646989InformationOpened the QlikView Engine successfully. ProcessID=3664
9/9/2014 13:03:22.6646989InformationAllocated QlikView Engine successfully. Current usage count=7 of 30 (of type non-reader). Ticket number=75.
9/9/2014 13:03:22.6646989InformationLoading document "F:\Qlink-Data\QlikView DATA\Target.qvw" (1.07 Mb)
9/9/2014 15:11:11.6450179InformationLoading. LoadTime=02:07:48.9803190
9/9/2014 15:12:07.9773401ErrorThe sourcedocument failed to open.. Exception=System.Runtime.InteropServices.COMException (0x800706BE): The remote procedure call failed. (Exception from HRESULT: 0x800706BE)

   at QlikView.Global.SetUserPreferences(IUserPreferences _Preferences)

   at QVBWrapper.Document.PerformActionAllowingComExceptions(ILogBucket logBucket, String actionName, Action action)

   at QVBWrapper.Document.Load(ILogBucket i_LogBucket, Boolean withData)

9/9/2014 15:12:07.9773401InformationAttempted to load the document without data.
9/9/2014 15:12:07.9773401ErrorThe document failed to open.
9/9/2014 15:12:07.9773401ErrorDocument could not be opened
9/9/2014 15:12:07.9773401InformationFailed to check in document: F:\Qlink-Data\QlikView DATA\Target.qvw
9/9/2014 15:12:07.9773401ErrorThe task "Daily Target" failed. Exception:

QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.FailedDocumentCheckoutException: Failed to check out document with path: F:\Qlink-Data\QlikView DATA\Target.qvw

   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)

7 Replies

Re: Publisher>> Reload Task take 2, 3 hour for few thousands rows

Dear Israr,

Is your Server hosted on SAN?

are you qlikview files reside on shared SAN drive?

Regards

ASHFAQ

israrkhan
Valued Contributor II

Re: Publisher>> Reload Task take failed...

Dear Ashfaq,

Actually this problem is with one of our client...

and every thing had been working fine since a year...but last month their license got expired..

and few days back we upgraded their license, and now they are facing this issue,

they are getting this error "failed to open document" as mentioned in the log file.

and task are hanging, after 2, 3 hours they are getting this error...

hope its clear now...

Re: Publisher>> Reload Task take failed...

Hi,

I did not answered my question..!

Is your qlikview files reside on shared SAN drive? I would recommend to move it to local server instead of shared folder.

I would check if there is some dependency on qvd's?If yes the I would schedule dependent task.

At the time of reload make sure the same extractind qvd is not used as i/p n some other application.

Make sure you don't have any antivirus software running, If yes make sure to eliminate QlikView content from scanning?

If at all you have any section access, then make sure to provide section access admin credentials while scheduling app in reload tab.

Hope it helps

Regards

ASHFAQ

israrkhan
Valued Contributor II

Re: Publisher>> Reload Task take failed...

Dear Ashfaq,

Thanks for reply

No SAN... local server...

regarding your suggestions above, there is no change in the server, due to license expired server was closed, even not running for few days...

but just after upgrading license,we faced this issue...

could be any issue due to license upgrade or server was down since 2, 3 weeks...

Re: Publisher>> Reload Task take failed...

Hi,

There shouldn't be any such issue regarding Licence upgrade.

It could be one of above.

Did you try by enabling document log?

did it worked fine i run manually?

Regards

ASHFAQ

israrkhan
Valued Contributor II

Re: Publisher>> Reload Task take failed...

manually mean? from desktop client?

works fine from desktop reload...

Re: Publisher>> Reload Task take failed...

then its definitely one of those.

Regards

ASHFAQ

Community Browser