QVX_UNEXPECTED_END_OF_DATA Error

[priyanka08]

I am getting the following error while running the below code in QlikView. Earlier, it was running perfectly, but starting from last week, it has been throwing an error all of a sudden.

Qlikvie code in Extractor

let vConnectorName='QV_PROD';

ODBC CONNECT TO $(vConnectorName); 

SELECT * from schemaname.Sales

Error  

QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: S1000, ErrorCode: 1060, ErrorMsg: [Starburst][Trino] (1060) Trino Query Error: Query 20240129_082452_49028_xxfq5 was abandoned by the client, as it may have exited or stopped checking for query results. Query results have not been accessed since 2024-01-29T16:31:36.797+08:00: currentTime 2024-01-29T16:36:37.086+08:00 (2)

[GOKULAKANNAN]

Hi @priyanka08 ,

This may help you,

TIMEOUT_READ_MEMORY indicates that the background extraction job takes a long time. Can there be many other jobs in the SAP system at the same time? You can increase the time before timeout by setting a high value in the connection string property TimeOutFetch like ;TimeOutFetch=4000;

You should switch off the Trace connection string property (when it is not used) since it is bad for performance.

Also a lot of improvements has been made to the connector after release 5.5. So I recommend to upgrade to the latest release if possible!

[anat]

This error message appear when:

•  Usage of CPU and/or RAM have reached their maximum on the Windows machine were the reload was performed
• The database server is heavily loaded and can't provide the requested information

https://community.qlik.com/t5/Official-Support-Articles/Error-message-QVX-UNEXPECTED-END-OF-DATA-app...

[priyanka08]

Thanks for your response.Is it because of special character presnt in some of the column and it include last  3 year data . as per my understanding fetchng the same record by incremental load will help

[priyanka08]

This is not SAP . This is  sql code error  while fetching  the data in  Qlikview Extractor

[GOKULAKANNAN]

In that case, Try to do the limit load, if its works fine then you need to refine your query and load only the required data.