Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Qlik SAP connector: Connector reply error: Mismatch detected. The SAP generated spool file cannot be

After the upgrade from the Qlik SAP Connector 7.0.0 to the 7.0.3 version (With Transports) we get this error when running our extraction. 

Connector reply error: Mismatch detected. The SAP generated spool file cannot be read. (count: LINES 16013, LINES_BUFFER 16016)

---

The error occurred here:

Select SAPREPORT (REPORT (RM07MLBS), VARIANT (Z_CIERREMPKQLI), ROWS_PER_RECORD (1), FIELD_AUTO_COLUMNS (3))

We verified the spool file is generated in SAP.

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Qlik SAP connector: Connector reply error: Mismatch detected. The SAP generated spool file canno

Hi Hakan.

Thanks for your quick response.

we solved this issue redoing the extraction using qlikview.

there were some text fields that couldnt load because they applied a num to them, we excluded the text records. and the issue was solved.

 

Julian

View solution in original post

2 Replies
Highlighted

Re: Qlik SAP connector: Connector reply error: Mismatch detected. The SAP generated spool file canno

Hi,

There is a workaround that should solve this error:

Step 1. Create a new folder named 'QvSAPReportConnector' and put that next to the folder QvSAPConnector in the path: C:\Program Files\Common Files\QlikTech\Custom Data.

Step 2. Move the file QvSAPReportConnector.dll from the folder QvSAPConnector to the folder QvSAPReportConnector.

Step 3. Temporary install the SAP connector release 6.6 on another server. Release 6.6 is available on the Qlik download site. Copy the files
icudt34.dll
icuin34.dll
icuuc34.dll
libicudecnumber.dll
libsapucum.dll
sapnwrfc.dll
from the folder QvSAPConnector on this server to the newly created folder QvSAPReportConnector on the release 7.0.3 server.

Step 4. Remove the release 6.6 folders from the temporary installation.

Restart QlikView and then it should work!

Regards,
Håkan

Highlighted
Partner
Partner

Re: Qlik SAP connector: Connector reply error: Mismatch detected. The SAP generated spool file canno

Hi Hakan.

Thanks for your quick response.

we solved this issue redoing the extraction using qlikview.

there were some text fields that couldnt load because they applied a num to them, we excluded the text records. and the issue was solved.

 

Julian

View solution in original post