SAP Report Connector - Empty report Handling

[KHSDM]

Hi all,

I'm currently extracting SAP data using the SAP Report Connector. But I have an issue with the extraction. The report might not return any data. (as expected and is normal). But it will cause the loading job to fail. Is there a way to handle this? Instead of failing, can it proceed as normal? Prefer not to use the "ErrorMode=0" if possible. I still need to track other errors.

[Hakan_Ronningberg]

Hi,

Some Reports creates a spool file even though zero rows are found. The connector should be able to handle those Reports.

Some Reports do not create a spool file when zero rows are found. For the moment the connector will display an error message when such a report is executed. Do you get a message like below in the connector log or do you get another error message?

Error /QTQVC/CALL_REPORT failed after 00:00:01 Key = ERROR (ID:00 Type:E Number:001 Failed to find spool request).

Regards,
Håkan

[KHSDM]

QlikView reload error:

https://pictr.com/images/2019/09/17/5lL6fZ.png

SAP Error:

https://pictr.com/images/2019/09/17/5lLS9J.png

[Hakan_Ronningberg]

Hi,

It looks like the Report is cancelled when no rows are found. It is a strange way to end the report in such a situation. Are you using a standard SAP Report? In that case what is the name of the Report?

If the Report is created by your company, I suggest to change the ABAP code behind the Report and create an empty spool file when no rows are found, instead of cancelling the Report.

Regards,
Håkan

[Hakan_Ronningberg · Accepted solution]

Hi again,

We (the SAP connector team at Qlik R&D) will investigate if it is possible to set a Connection String Property to ignore error messages when the Report is executed. A number of Reports seems to end with an error message if no rows are found. If the Connection String Property is set to true, the script processing will continue even though an error message is received.

If possible, this feature will be available in the next release of the Report connector. Release date is not decided yet.

Regards,
Håkan

[KHSDM]

Great! Hopefully this can be implemented in future release. Thank you for all the info.

[mike_coupal]

We have a Sense app that uses the report connector and it often gives just the heading and no data, so I have it running in a loop until the rowcount is large enough or it reached the 'max loops'. It often fails to refresh the QVD before the main app reads the QVD file and people see 'stale' data. I removed it from the task trigger chain because it failed so often.

This creates many jobs in SAP and doesn't seem like an acceptable solution. The spools in the SAP jobs are deleted and I don't know how to debug the process. The help documentation doesn't mention how to turn on the trace or how to debug this issue.

[dangallagherLEV]

Is there any update to this question from several years ago?  We extract a lot of data from SAP, and occasionally the report/query doesn't return any data, and the full QlikView report fails.  And there's no information/parameter to get around it.