SYMPTOM:
When executing a report whose data source consists of flat text files, the following error is displayed:
Sample Code/Error
Error:
Execution Failed
Error: SQL Generation CompleteQueryEngine encountered error: Execute Query failed. Error type: Odbc error: Odbc operation attempted: SQLExecDirect. File not found `/xxx/xxx’. Error in Process method of Component: QueryEngineServer. Project xxx, Job 1036, Error Code = -2147212544
However, the text file does exist in the location specified by the error, and all permissions are set correctly. Viewing the text file through the Warehouse Catalog is also successful.
CAUSE:
In the above case, the database connection type is incorrect.
ACTION:
Change the database connection type from Microsoft Excel to Generic Dbms
