Error QVX_UNEXPECTED_END_OF_DATA: TIMEOUT_READ_MEMORY

igorgois_ — Wed, 04 Apr 2018 17:28:09 GMT

Hello

I am facing a problem on extraction with sap connector

The log says:

2018-04-04 11:06:02 0012 KONV:

2018-04-04 11:06:02 0013 Load *

2018-04-04 11:06:02 0014 SQL

2018-04-04 11:06:02 0015 SUBSELECT

2018-04-04 11:06:02 0016 MANDT,

2018-04-04 11:06:02 0017 KNUMV,

2018-04-04 11:06:02 0018 KPOSN,

2018-04-04 11:06:02 0019 STUNR,

2018-04-04 11:06:02 0020 ZAEHK,

2018-04-04 11:06:02 0021 KDATU,

2018-04-04 11:06:02 0022 KSCHL,

2018-04-04 11:06:02 0023 KPEIN,

2018-04-04 11:06:02 0024 KBETR

2018-04-04 11:06:02 0025 FROM KONV

2018-04-04 11:06:02 0026 WHERE KNUMV IN (

2018-04-04 11:06:02 0027 SELECT

2018-04-04 11:06:02 0028 KNUMV

2018-04-04 11:06:02 0029 FROM EKKO

2018-04-04 11:06:02 0030 WHERE AEDAT >= "20170101"

2018-04-04 11:06:02 0031 AND AEDAT < "20180101"

2018-04-04 11:06:02 0032 )

2018-04-04 11:26:10 9 fields found: MANDT, KNUMV, KPOSN, STUNR, ZAEHK, KDATU, KSCHL, KPEIN, KBETR,

2018-04-04 11:26:10 Error: QVX_UNEXPECTED_END_OF_DATA: TIMEOUT_READ_MEMORY

2018-04-04 11:26:10 Execution Failed

2018-04-04 11:26:10 Execution finished.

I tried to split the extraction with one qvd per year, but the problem continues

Sometimes i run the task and dont get the erro, other times I do.

I saw someone with the same error but the post was closed. That why Im asking here again

Any clue?

Thanks in advance

Re: Error QVX_UNEXPECTED_END_OF_DATA: TIMEOUT_READ_MEMORY

Anonymous — Wed, 11 Apr 2018 09:03:21 GMT

Hi,

We are facing exact same issue when using SAP SQL connector. It is also random and sometimes it exectues correctly. We are using connector version 6.3.1.

The customer recently did a migration of servers to a cloud and the Qlik server changed IP. I am wondering if this may have an impact, even though we havent experienced any other issue.

Any help is appreciated.

Here is a sample of the log:

1:05:31,208 [5] - SqlDataService.GetData() - TIMEOUT_READ_MEMORY received, sleeping for 100ms

01:05:35,889 [5] - SqlDataService.GetData() - TIMEOUT_READ_MEMORY received, sleeping for 100ms

01:05:40,899 [5] - SqlDataService.GetData() - TIMEOUT_READ_MEMORY received, sleeping for 100ms

01:05:45,892 [5] - SqlDataService.GetData() - TIMEOUT_READ_MEMORY received, sleeping for 100ms

01:05:51,214 [5] - SqlDataService.GetData() - TIMEOUT_READ_MEMORY received, sleeping for 100ms

01:05:55,894 [5] - SqlDataService.GetData() - 300 seconds of inactivity, checking background job.

01:05:55,894 [5] - SqlDataService.GetData() - TIMEOUT_READ_MEMORY received, sleeping for 100ms

01:06:00,904 [5] - SqlDataService.GetData() - TIMEOUT_READ_MEMORY received, sleeping for 100ms

01:06:05,897 [5] - SqlDataService.GetData() - TIMEOUT_READ_MEMORY received, sleeping for 100ms

01:06:10,904 [5] - SqlDataService.GetData() - TIMEOUT_READ_MEMORY received, sleeping for 100ms

01:06:29,845 [5] - SqlDataService.GetData() - Fetch aborted, due to an unexpected exception

SAP.Middleware.Connector.RfcCommunicationException:

LOCATION CPIC (TCP/IP) on local host with Unicode

ERROR connection to partner '10.65.0.11:3300' broken

TIME Wed Apr 11 01:06:29 2018

RELEASE 721

COMPONENT NI (network interface)

VERSION 40

RC -6

MODULE nixxi.cpp

LINE 5082

DETAIL NiIRead: P=10.65.0.11:3300; L=0.0.0.0:60108

SYSTEM CALL recv

ERRNO 10053

ERRNO TEXT WSAECONNABORTED: Software caused connection abort

COUNTER 5

at SAP.Middleware.Connector.CpicConnection.CpicReceive(Int32 timeout)

at SAP.Middleware.Connector.CpicConnection.Read(Byte* buffer, Int32 offset, Int32 count)

at SAP.Middleware.Connector.RfcConnection.ReadBytes(Byte* buffer, Int32 count)

at SAP.Middleware.Connector.RfcConnection.ReadRfcIDBegin(Int32& length)

at SAP.Middleware.Connector.RfcConnection.ReadUpTo(RFCGET readState, RfcFunction function, RFCID toRid)

at SAP.Middleware.Connector.RfcConnection.RfcReceive(RfcFunction function)

at SAP.Middleware.Connector.RfcFunction.RfcDeserialize(RfcConnection conn, IRfcIOStream stream)

at SAP.Middleware.Connector.RfcFunction.RfcCallReceive(RfcConnection conn, IRfcIOStream stream, RFCID rid)

at SAP.Middleware.Connector.RfcFunction.Invoke(RfcDestination destination)

at Qlik.Connectors.SAP.SqlDataService.GetData(NameValueCollection paramCollection, BlockingCollection`1 sourceDataRows, Func`5 processRow, Object tableInfo)

01:06:29,861 [5] - SqlDataService.CancelJob() - About to cancel job: 20180411010044

01:06:50,915 [5] - SQLConnectorDataReader.Read() - Error occured during read!

SAP.Middleware.Connector.RfcCommunicationException:

LOCATION CPIC (TCP/IP) on local host with Unicode

ERROR partner '10.65.0.11:3300' not reached

TIME Wed Apr 11 01:06:50 2018

RELEASE 721

COMPONENT NI (network interface)

VERSION 40

RC -10

MODULE nixxi.cpp

LINE 3283

DETAIL NiPConnect2: 10.65.0.11:3300

SYSTEM CALL connect

ERRNO 10060

ERRNO TEXT WSAETIMEDOUT: Connection timed out

COUNTER 7

at SAP.Middleware.Connector.CpicConnection.ConnectAsClient(Dictionary`2 options, Boolean forRepository)

at SAP.Middleware.Connector.RfcConnection.ConnectAsClient(RfcDestination destination, Boolean forRepository)

at SAP.Middleware.Connector.RfcConnectionPool.GetClient()

at SAP.Middleware.Connector.RfcDestination.GetClient(Boolean forRepository)

at SAP.Middleware.Connector.RfcSessionState.GetConnection()

at SAP.Middleware.Connector.RfcSessionManager.GetConnection(RfcDestination dest)

at SAP.Middleware.Connector.RfcFunction.Invoke(RfcDestination destination)

at Qlik.Connectors.SAP.SqlDataService.CancelJob(NameValueCollection parameters)

at Qlik.Connectors.SAP.SqlDataService.GetData(NameValueCollection paramCollection, BlockingCollection`1 sourceDataRows, Func`5 processRow, Object tableInfo)

at Qlik.Connectors.SQL.SQLConnectorDataReader.Read(BlockingCollection`1 sourceDataRows)

01:06:50,915 [5] - Teardown Connection

01:06:50,962 [1] - RECEIVED: QvxRequest {Command=QVX_GET_EXECUTE_ERROR, Options={AllowPrompt=False, AutoCommit=False, ConnectTimeoutSec=, IsEmpty=True, LoginTimeoutSec=, Provider=, ReadOnly=False}}

01:06:50,962 [1] - SENDING: QvxReply {Result=QVX_OK}

01:06:50,962 [1] - RECEIVED: QvxRequest {Command=QVX_TERMINATE, Options={AllowPrompt=False, AutoCommit=False, ConnectTimeoutSec=, IsEmpty=True, LoginTimeoutSec=, Provider=, ReadOnly=False}}

01:06:50,962 [1] - SENDING: QvxReply {Result=QVX_OK}

01:06:50,962 [1] - TERMINATING

Re: Error QVX_UNEXPECTED_END_OF_DATA: TIMEOUT_READ_MEMORY

igorgois_ — Wed, 11 Apr 2018 11:50:58 GMT

i took out the DISTINCT clause and it worked...

If the SELECT of the sub-table returns duplicates, they are removed before selecting from the main table. So, there is no need (and it does not work) to use the DISTINCT addition to the SUBSELECT.

https://help.qlik.com/en-US/connectors/Subsystems/SAP_SQL_Connector_help/Content/6.2/QV-connection/SAP-SQL-connection-Subselect.htm

topic Error QVX_UNEXPECTED_END_OF_DATA: TIMEOUT_READ_MEMORY in Connectivity & Data Prep

Error QVX_UNEXPECTED_END_OF_DATA: TIMEOUT_READ_MEMORY

Re: Error QVX_UNEXPECTED_END_OF_DATA: TIMEOUT_READ_MEMORY

Re: Error QVX_UNEXPECTED_END_OF_DATA: TIMEOUT_READ_MEMORY