QVX_UNEXPECTED_END_OF_DATA

[vamsee]

Hello all, 

I am using Qlik SAP Connector 5.5.

I have a simple script to extract a particular table from SAP. 

VBAP:
LOAD 
		[VBELN] as [Sales Document_VBELN],
		[POSNR] as [Item_POSNR],
		[PSTYV] as [Item category_PSTYV]
;
SQL Select 
		VBELN
		POSNR
		PSTYV
		
From VBAP
where 
	VBELN IN ( Select VBELN from ZOPENORD)
and PSTYV IN ('ZMOS')
;

 This was running perfectly fine until a week ago, extracts around 1600 records.

Most of the time it completes in less than a minute however once in a while it takes longer.

But since last Friday I am getting an error message QVX_UNEXPECTED_END_OF_DATA.

I have read multiple posts on this error and state its due to the number of lines being fetched, whereas I am only fetching 1600.

Any suggestions on this are greatly appreciated.

@Hakan_Ronningberg  @rwunderlich @sunny_talwar @pablolabbe 

[ravikancharlabi]

Dear members,

Greetings!

We are facing an issue with similar topic but on MS SQL Server DB.

can you please help us to resolve the same.

1. I have added Connect Timeout=600; in the OLEDB connectivity as well.

2. ODBC / OLEDB both are giving this similar error.

Regards,

Ravi.

[viz301]

Hello Ravi,

Kindly let me know whether you have been able to resolve the issue because we are also facing a similar one.

Thanks.