topic Re: QlikView SAP SQL Connector error and queries on that in QlikView

QlikView SAP SQL Connector error and queries on that

Mon, 26 Jan 2026 21:26:37 GMT

Hi Qlikxperts...

There’s the below error which we are encountering frequently. Would like to know if anyone has ever faced this and has any suggestions to overcome this:

“QVX_UNEXPECTED_END_OF_DATA: Fetch aborted after 241 retries. Key = TIMEOUT_READ_MEMORY (ID:00 Type:E Number:001 Timeout when trying to read shared buffer)”

Also, please provide your views/opinions/clarifications on QlikView on SAP implementation with respect to the below points:

When extracting via QlikView SAP SQL connector, would there be a dialog box process also occupied along with the background process when an RFC is created?
Has there been any successful implementation wherein

- the SAP Application front-end and the Database are on the same Server box
- and put multiple table extractions (sequentially/ in parallel) via the QV SAP Connector when there’s a limit on number of background jobs(5) that can run simultaneously considering there would be frontend users also logged in.

Hoping to receive constructive replies...

Thanks in advance!

Best Regards,

KnightriderX

Re: QlikView SAP SQL Connector error and queries on that

Fri, 07 Feb 2014 13:00:13 GMT

Hi knightriderX,

I have the same issues. Did you solve the problems yourself ?

Best Regards

Thomas

Re: QlikView SAP SQL Connector error and queries on that

Fri, 07 Feb 2014 13:22:46 GMT

Hi Thomas,

I have got no real good solutions on any of the issues above.

Still on the old setup only.

Best Regards,

KrX

Re: QlikView SAP SQL Connector error and queries on that

Wed, 12 Feb 2014 09:34:48 GMT

The error is related to missing export / import shared buffer on the SAP system. This should be checked by the SAP Basis Administrator. Mostly there are other SAP Jobs running blocking the connector to read the data.

Re: QlikView SAP SQL Connector error and queries on that

Thu, 13 Feb 2014 08:21:18 GMT

I am the SAP-Basis Administrator. I think the buffers are ok. We have no problems in our sap-systems.

There are many users and many many jobs running parallel. I think it's a real timeout Problem. The table, i'm fetching data from, is a infostructure-table and its very large. It will become much more larger at the end of the year..

Below the SQL-Statement. There are only sequential reads in the database, because "SPTAG" is not indexed.

Any ideas without defining a new index ?

"select * from S999 where SPTAG between '20140101' AND '20140228' "

Re: QlikView SAP SQL Connector error and queries on that

Thu, 13 Feb 2014 08:56:34 GMT

Hi Thomas!

Are you getting the "QVX_UNEXPECTED_END_OF_DATA" error in your QV extraction?

Regards,

Re: QlikView SAP SQL Connector error and queries on that

Thu, 13 Feb 2014 09:19:45 GMT

Yes.

“QVX_UNEXPECTED_END_OF_DATA: Fetch aborted after 241 retries. Key = TIMEOUT_READ_MEMORY (ID:00 Type:E Number:001 Timeout when trying to read shared buffer)”

Re: QlikView SAP SQL Connector error and queries on that

Thu, 13 Feb 2014 09:27:58 GMT

Hi Thomas!

In your earlier post when you said your SAP buffers are OK, can you please mention the number of buffers and size of each that is configured in your SAP system?

Also, do you have any parallel or simultaneous QV or other extractions scheduled or run when one of them returned that error?

Are your SAP Application Server and Database server on the same physical box or on different boxes?

Thanks and Best Regards,

Re: QlikView SAP SQL Connector error and queries on that

Thu, 13 Feb 2014 10:37:36 GMT

Check rsdb/obj/buffersize (default value is 4,096 [kB]) and use transaction ST02 to monitor Export / import Buffer before and durring the reload.

Re: QlikView SAP SQL Connector error and queries on that

Mon, 24 Feb 2014 11:16:08 GMT

I have the same issue:

Did anyone solve above problem????

please provide me a solution as early as possible.

Thanks in Advance!

Regards,

Sanjay

Re: QlikView SAP SQL Connector error and queries on that

ernesto_hdezh — Tue, 25 Feb 2014 17:38:14 GMT

Hi Sanjay

one cuestion, what version the conector you have installed???

Why do this question??? beacuse the last version the conector, i have some problems with the conexion, maybe it's some similar your problem , if you have the version 5.8 SR2 uninstall , and install version 5.8 SR1.

Ernesto

Re: QlikView SAP SQL Connector error and queries on that

laujerry — Mon, 10 Mar 2014 03:50:11 GMT

hi ernesto, i am using connector version 5.7 sr1, and i still hv the problem

i am trying to load the table konv using sql subquery

in this thread delrio suggested downgrading connector to 5.3

so friends above, which connector version are u using?

Re: QlikView SAP SQL Connector error and queries on that

Emmanuelle__Bustos — Fri, 05 Jul 2019 21:57:18 GMT

Hi,

We have the same issue with QV 11.0 and SAP Connector 5.7, did you find the root problem and how to solve it?