Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

8 Replies
Not applicable
Author

Please Find The Screen Shot of the error

stabben23
Partner - Master
Partner - Master

Hi,

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

fkeuroglian
Partner - Master
Partner - Master

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

sumanta12
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?

balabhaskarqlik

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.

fredrikehno99
Partner - Contributor
Partner - Contributor

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

 

JuanManuelLopezFelizzola
Contributor III
Contributor III

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
MuhammadFahim
Partner - Contributor II
Partner - Contributor II

Hi, i am also facing the same issue and tried almost everything and it is not working, can you tell me have you found the solution? if yes kindly share it with me so i can extract my report.