After running SQL Scanner and selecting a SQL statement that contains temporary tables, the following error is thrown when launching the Tuning Lab:
Process Error!
Original SQL: Invalid SQL statement.
Table does not exist.
Invalid object name #tmp_table.
CAUSE 1
The Tuning Lab is not pointing to the correct database and user which owns the objects being tuned.
CAUSE 2
The SQL statement uses temporary tables that cannot be created on the fly.
WORKAROUND 1
In Tuning Lab, set the correct database and user which owns the objects referenced in the SQL statement.
WORKAROUND 2
Create all the temporary tables referenced in the SQL statement using the User-Defined Temp Table function. Please refer to the Help file for more detailed information on using this function.
