Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Error ID:00 Type:E Number:001 Failed to find Spool Request

I am facing a problem while calling a  report through report connector. I am attaching the screenshot of the ERROR . Error is ID:00 Type:E Number:001 Failed to find Spool Request

7 Replies
Highlighted
Not applicable

Please Find The Screen Shot of the error

Highlighted
Master
Master

Hi,

make sure that your "Printer Spooler" service is started on Qlikview server.

Highlighted
Partner
Partner

Hi, try to execute in sap the same report and see what gives in the spool of sap

try to create a variant that gives only some information and put in when you call the report to see if it is a problem of the report need a variant

good luck

Fernando

Highlighted
Creator II
Creator II

Hi,


I am facing the same problem while calling a  report through report connector. Error is ID:00 Type:E Number:001 Failed to find Spool Request.


Have you got the solution?

Highlighted

Check this:

PDF Publisher: Could not print report. ErrorCode=TIME_OUT_ERROR

Need to make sure that the service Print Spooler is enabled. If this was disable when Qlik was installed, the PDF Xchange will not work and you have to uninstall it and install it again.

Highlighted
Partner
Partner

Hi, Could the problem be that there is no data in the report and therefore no spool file is created and hence the error.

If you change your variant of the report to make sure you will get some data do you then get the same error?

My guess is that there is no data in the report and therefore you get the error

 

Highlighted
Contributor II
Contributor II

Hello people,

Has there been any advances in trying to sort this one out?

I am getting the same error. I am running QlikView SAP Connector 5.70.10958.0 and am getting this.

Don't know if this makes any difference, but I am running QlikView Desktop 11.20.13206.0 SR13 64bit

The weird thing is that, I do have other reports that are running on the same server/system number/PRD env with the same installation of SAP Connector and they are also connecting to some Z developments (the ones that are made for my organization) and they are running just fine.

The SAP Connector log reads:

=================

2019-09-07 11:43:59 Progress Resetting Server Context 2019-09-07 11:43:59 Progress Statement is: SELECT SAPREPORT (REPORT (ZSDR_TRAZABILIDADVENT), VARIANT (QV_1), ROWS_PER_RECORD (1), SKIP (T (1), P (0, "!ClDocVenta!")))

2019-09-07 11:43:59 Progress Creation of function /QTQVC/CALL_REPORT returned after 00:00:00

2019-09-07 11:44:45 Error /QTQVC/CALL_REPORT failed after 00:00:46 Key = ERROR (ID:00 Type:E Number:001 Failed to find spool request)

2019-09-07 11:44:45 Progress Resetting Server Context

2019-09-07 11:44:45 Progress Statement is: SELECT SAPREPORT (REPORT (ZSDR_TRAZABILIDADVENT), VARIANT (QV_2), ROWS_PER_RECORD (1), SKIP (T (1), P (0, "!ClDocVenta!")))

2019-09-07 11:44:45 Progress Creation of function /QTQVC/CALL_REPORT returned after 00:00:00

2019-09-07 11:46:59 Error /QTQVC/CALL_REPORT failed after 00:02:14 Key = ERROR (ID:00 Type:E Number:001 Failed to find spool request)

2019-09-07 11:46:59 Progress Resetting Server Context

2019-09-07 11:46:59 Progress Statement is: SELECT SAPREPORT (REPORT (ZSDR_TRAZABILIDADVENT), VARIANT (QV_3), ROWS_PER_RECORD (1), SKIP (T (1), P (0, "!ClDocVenta!")))

2019-09-07 11:46:59 Progress Creation of function /QTQVC/CALL_REPORT returned after 00:00:00

2019-09-07 11:49:23 Error /QTQVC/CALL_REPORT failed after 00:02:24 Key = ERROR (ID:00 Type:E Number:001 Failed to find spool request)

2019-09-07 11:49:23 Progress Resetting Server Context

2019-09-07 11:49:24 Progress Statement is: SELECT SAPREPORT (REPORT (ZSDR_TRAZABILIDADVENT), VARIANT (QV_4), ROWS_PER_RECORD (1), SKIP (T (1), P (0, "!ClDocVenta!")))

2019-09-07 11:49:24 Progress Creation of function /QTQVC/CALL_REPORT returned after 00:00:00

2019-09-07 11:51:20 Error /QTQVC/CALL_REPORT failed after 00:01:56 Key = ERROR (ID:00 Type:E Number:001 Failed to find spool request)

=================

The name of the program that I am trying to run is ZSDR_TRAZABILIDADVENT with the Variant QV_4, and when I go into SAP and run this same variant I DO get data out of it.

I have also checked even the structure of the report, but I don't think it is related to this, because I can't even get the preview on the Report Connector window (the one that helps you create the Query).

What is even weirder is that this report extraction was working ok before, like 3 months ago.

What I have done so far:

  • Checked the spooler service on the server (Running, though I have asked my IT team to restart it).
  • Checked other report extractions, running fine.
  • Ran the transaction myself on SAP, it runs and brings data with the variants I am using.
  • Had the BASIS check on the transaction but according to them everything is OK on SAP side (just wished I had the knowledge and power to check the spool things myself)
  • Created a brand new Variant with less data, to see if it was just a matter of buffer or something like that, not working (though still able to run the transaction on SAP)

Any help or crazy ideas are appreciated!

Juan Manuel Lopez Felizzola