QVX_UNEXPECTED_END_OF_DATA: Fetch aborted, due to an unexpected exception. Key = JOB_CANCELLED
Article Number: 000048898 | Last Modified: 2018/11/21
Reload of qlikview document involving an SAP SQL connection fails abrubtly with error, "QVX_UNEXPECTED_END_OF_DATA: Fetch aborted, due to an unexpected exception. Key = JOB_CANCELLED".
Logs of job /QTQVC/READ_DATA in transaction SM37 in SAP shows error "Forbidden word found in SQL".
The SQL statement either uses SELECT * or fetches too many fields.
SAP Connector version is older than v6.6.
SAP system is on DB6 database with unicode.
In the underlying ABAP code, although the records may be fetched in the right order most of the times, DB6 database seems to mess up the order sometimes which results in the SQL statement being fetched in the wrong order. This makes the job believe that a forbidden word is used in the SQL statement.
It was fixed by a code change in connector version 6.6 that ensures that the parsing order is always the same. Upgrade to a connector version later than v6.6 to realize the fix.