Qlikview Publisher reload failed

[#1]

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)

[Siva_Sankar]

Hi Surender,

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

-siva

[neha_shirsath]

Hi Surender,

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

[#4]

Hi Neha,

Appreciate your prompt response.

We are extracting from Tables only.

[Siva_Sankar]

if possible can you copy paste the document log file?

[Miguel_Angel_Baeyens]

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.

[neha_shirsath]

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

[#8]

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.