Error QVX_UNEXPECTED_END_OF_DATA: TIMEOUT_READ_MEMORY

[igorgois_]

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

[Anonymous]

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

[igorgois_ · Accepted solution]

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/S...