Qliksense job failed with error of mismatch in records while fetching data from SAP table VBAP

[Neha]

Qliksense job failed with error of mismatch in records while fetching data from SAP table VBAP using the SAP SQL connector. The error message is given below :

20201110T064844.291-0500      Error: QVX_UNEXPECTED_END_OF_DATA: Fetch completed with mismatching number of rows, expected 56194611 rows but read 56192518 rows!

    20201110T064845.417-0500      Execution Failed

    20201110T064845.422-0500      Execution finished.

[ArnadoSandoval]

Hi @Neha 

I got some troubleshooting ideas:

• Are you fetching those records from a table (VBAP) that is not being updated by the business application?
• Is this error happening 100% of the time, or just once in a while?

I suspect your table VBAP was updated (records added or deleted) while Qlik was fetching its data.

hth

[PrashantSangle]

check this support link 

https://support.qlik.com/articles/000043379?_ga=2.236251330.218062422.1605155271-73407647.1595316103

Regards,

Prashant Sangle