Qlik Community

QlikView Connectors

Not applicable

Qlikview Fetch Aborted issue via SAP Connector

Hello Everyone,

Currently we are facing an issue with one of our client regarding the data fetch from SAP.

“QVX_UNEXPECTED_END_OF_DATA: Fetch aborted, due to wrong number of rows received. Received 205638 rows, should be 206125”.

We are using QV SAP Connector while fetching the data from SAP. While this issue is coming not on a frequently basis and also not on a particular table.

We are using  this connection string.

CUSTOM CONNECT TO "Provider=QvSAPConnector.dll;ASHOST=111.111.11.11;SYSNR=60;CLIENT=000;Log=1;KeepCasing=1;NullDate=1;XUserId=JbaMXUXbaB;XPassword=baAGTRFA;TimeOutFetch=200000";

Here are some of the basic information that you be required.

  1. Qlikview Version :- QV 11 SR2
  2. Qlikview SAP Connector :-  QV SAP 5.6 SR1
  3. SAP BASIS :- 700 (Patch Level 25)

Note :-

  1. I am also sharing the log file of the .qvw document for your reference.

Please help me regarding the same.

Regards,

Nitin Jain

4 Replies
suniljain
Honored Contributor

Re: Qlikview Fetch Aborted issue via SAP Connector

Are you trying to extract report from SAP R/3 ?.

Not applicable

Re: Qlikview Fetch Aborted issue via SAP Connector

Yes we fetching data from SAP R/3 tables...

MVP
MVP

Re: Qlikview Fetch Aborted issue via SAP Connector

We encountered this error also few times:

QVX_UNEXPECTED_END_OF_DATA: Fetch aborted, due to wrong number of rows recieved. Recieved 45392808 rows, should be 45394409.

while loading from a large SAP R/3 table.

Jain, have you got a solution yet?

Can anybody explain what might cause the issue or how the expected number of records is retrieved.

tmumaw
Valued Contributor

Re: Qlikview Fetch Aborted issue via SAP Connector

Jain

Have you ever got this resolved?  We just upgraded to 11.2.SR3.  Everything seems to be running fine except this one job where I get the same error as you did.  I'm extracting the current year from an SAP table (GLPCA).

Thanks

Thom

Community Browser