BUG: in Qlik SAP SQL Connector (ver 7.0), SUBSELECT * is not working
Article Number: 000058063 | Last Modified: 2018/10/19
In Qlik SAP SQL Connector (ver 7.0), extracting data using "SUBSELECT *........ IN (SELECT... FROM ......WHERE ....)" returns error.
2018-10-18 16:26:39 QVX_UNEXPECTED_END_OF_DATA: Job aborted, check log for Job /QTQVC/READ_DATA in
2018-10-18 16:26:39 Job Overview (transaction SM37)
2018-10-18 16:26:39 Error: failed.....
Qlik SAP Connector (ver 7.0)
This defect was introduced in release 6.6 when another bug was fixed.
Bug SAP-1731 was solved in Qlik SAP Connector version 7.0.1 and is available on Qlik download site.
If you can't upgrade, as workaround, replace star (*) in the SUBSELECT quey by a list of fields name.
SUBSELECT BUKRS BELNR GJAHR BUZEI BUZID FROM BSEG
WHERE BUKRS BELNR GJAHR IN ( SELECT BUKRS BELNR GJAHR FROM BKPF WHERE CPUDT >= '19950606')