SYMPTOM
When using MySQL database as the warehouse, when running report, the following error messages may appear:
QueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. Can`t reopen table: `xxx`
where 'xxx' is the name of temporary table created by previous SQL statement.
CAUSE
This issue has been observed in environments using the MySQL warehouse when handling temporary tables.
ACTION
If the database error cannot be resolved, it may be appropriate to consider an alternative Intermediate Table Type, For example, change Intermediate Table Type in VLDB properties to 'Derived table' as shown on an image below. This will allow Strategy Query Engine to use nested SELECT statements instead of creating temporary tables.
ADDITIONAL NOTES
For information on MySQL locks, please refer to the following article:
KB20079: How to avoid table locks when using MySQL database as a warehouse with Strategy
Third Party Software Installation:
WARNING:
The third-party product(s) discussed in this article is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.
