SYMPTOM:
When attempting to execute a Freeform SQL report containing a CREATE TABLE statement or other statement which doesn't select results, like the one below, the following error appears in Strategy Engine:
CREATE TABLE TEST100 (COL1 INTEGER)
Error: SQL Generation Complete QueryEngine encountered error: Fetch failed. Error type: Invalid operation. Attempted to fetch an empty result. Error in Process method of Component: QueryEngineServer, Project Strategy Tutorial, Job 291, Error Code -2147212544.
NOTE: The table is created despite the report execution failure.
CAUSE:
Freeform SQL reports take custom SQL and execute it against a database, mapping the result set returned to Strategy objects. A CREATE TABLE statement does not return a result set, just a success or failure message, so the report execution fails when the result set comes back empty.
ACTION:
The CREATE TABLE statement can be placed in a Report Pre Statement VLDB property, which does not expect a result set:
