topic Re: Qlikview Publisher reload failed in QlikView

Qlikview Publisher reload failed

Thu, 27 Jul 2017 04:08:36 GMT

Hi ,

I need a help we are using SAP Connector 5.8 and Publisher.

Every day extraction of tables and storing is happening correctly.

last month onwards we are facing the Task failed issues.

I don't why it is happening and where we can see the issue

In the log file where we can see the exact issue

Once I restarted the Server it is running ok what might be the issue i couldn't understand

please find the below for Log file.

Please help me on this issue.

The task "Reload of Sales_SAPDataExtractor.qvw" failed. Part of the log file follows:

7/27/2017 12:05:06 AM 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. at QlikView.Doc.DoReload(Int32 _Mode, Boolean _Partial, Boolean _Debug) at QVBWrapper.Document.Reload(ILogBucket i_LogBucket, Boolean i_MonitorQVBCPUUsage, Boolean i_Partial, Boolean i_ReadDocumentLog)
7/27/2017 12:05:07 AM Error The task "Reload of Sales_SAPDataExtractor.qvw" failed. Exception: 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. at QlikView.Doc.DoReload(Int32 _Mode, Boolean _Partial, Boolean _Debug) at QVBWrapper.Document.Reload(ILogBucket i_LogBucket, Boolean i_MonitorQVBCPUUsage, Boolean i_Partial, Boolean i_ReadDocumentLog) 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)

Re: Qlikview Publisher reload failed

Siva_Sankar — Thu, 27 Jul 2017 06:15:06 GMT

Hi Surender,

Did you check the document log instead of publisher log file?

-siva

Re: Qlikview Publisher reload failed

neha_shirsath — Thu, 27 Jul 2017 07:21:14 GMT

Hi Surender,

Tell me one thing, this extractor is fetching data from base table or z report?

Re: Qlikview Publisher reload failed

Thu, 27 Jul 2017 09:11:50 GMT

Hi Neha,

Appreciate your prompt response.

We are extracting from Tables only.

Re: Qlikview Publisher reload failed

Siva_Sankar — Thu, 27 Jul 2017 09:27:41 GMT

if possible can you copy paste the document log file?

Re: Qlikview Publisher reload failed

Miguel_Angel_Baeyens — Thu, 27 Jul 2017 09:27:44 GMT

If you are using macros, post the code to review. If you are not, post the script log, not the task log, to see in which point QlikView failed to load (which table or field) or syntax created the issue.

Re: Qlikview Publisher reload failed

neha_shirsath — Thu, 27 Jul 2017 09:31:46 GMT

Hi Surender,

Strange..!!

If you are fetching data directly from tables then it should not happened but have you debug the extractor script?

And also check the fields with SAP Script builder.

& also I wanted to know if your data size of table is large? because as u said once you restart the server its reload data normally then might be at night on your scheduled time your extractor didn't getting required bandwidth.

Thanks,

Neha

Re: Qlikview Publisher reload failed

Fri, 28 Jul 2017 03:31:56 GMT

Hi Neha,

I Am using the same script since 2 years there is no issue. but last 2 months back onwards am facing this issue.

I can't share the Document log file because it was replaced by new which is a success.

If any suggestions please let me know.