SYMPTOM:
When executing a Report Service Document with a Freeform SQL prompt report as dataset in Strategy Desktop 9.4.1, after answering the prompts, the error message appears, as shown below:

Sample Code/Error
Error(s) occurred while loading report: DSSSQLEngine: converting Report: Template Unit - The object definition is incomplete or inconsistent
CAUSE:
The Report Service Document was executed directly without saving it first.
ACTION:
Save the document first, then execute it.