SYMPTOM:
When the user runs a SQL/MDX test in Strategy Integrity Manager, the below error returns:
SQLEngine got an Exception from DFC: Engine Logic: Custom group on the template has nothing to display.Error in Process method of Component: SQLEngineServer, ... , Job 140, Error Code= -2147212800.)
However, reports can be executed in Strategy without any problem.
CAUSE:This issue is caused by a custom group in a report with optional prompts. By default, Strategy Integrity Manager does not answer optional prompts. This is currently expected behavior.
ACTION:In order for Strategy Integrity Manager to answer optional prompts with default answers, use the Strategy Integrity Manager Wizard, at the step to select prompt settings, to set the option
Answer optional prompts. See the screenshot below:
