Loading data from SQL based source fails with the error "Error: File extdata.cpp, Line 2903
The error message comes from QlikView engine and is related to the database resultset not having valid fields.
Typically this is due to the usage of LOAD * , which means that QlikView will parse the result set in order to find the returned field names. For some reason the data base has not returned a valid resultset, most likely due to database driver issues or an invalid SQL query.
For troubleshooting it is recommended to run the failing query in a third party SQL query tool, with the following considerations.
- Use the same ODBC DSN, or OLEDB connection
- Use the same underlying database driver
- Access the same database server
- Use the same user credentials, username and password. NOTE: Use the QlikView service user if issue is related to QlikView Server
The third party tool should return an unexpected resultset. In this context pay extra attention to that the field names are exactly as expected and in readable language without garbage characters.
Common resolution is to correct SQL query so that a valid and expected result set is returned by database.