KB39449: "SQLEngine got an Exception from DFC, Generate SQL for attribute form expression failed... Error Code = -2147212800" error occurred when using an analytical engine function for attribute form in MicroStrategy Developer 9.x.

SYMPTOM:
 
When using an analytical engine function for a newly created attribute form in Strategy Developer 9.x, following error occurs:
 
SQLEngine got an Exception from DFC: Engine Logic: Generate SQL for attribute form expression failed, please check if the expression is valid. Error in Process method of Component: SQLEngineServer, Project Strategy Tutorial, Job 2645, Error Code= -2147212800
 
STEPS TO REPRODUCE:

• In Strategy Tutorial create a new Attribute
• Select Source Table LU_YEAR
• Select “Insert Function” and choose Math and the Trunc function or any other analytical function as shown below:

• Select any column of the table and add a math function to the expression as shown below:

• Save and close the new attribute and update the Schema
• Go to “Data Explorer – Strategy Tutorial” and expand “System Hierarchy” or run a report using the attribute form created above. The error message will be displayed.

 
 
CAUSE:
 
This error occurs when using any function that evaluates in the Analytical Engine only as it is not translated into a SQL statement.
 
ACTION:
 
Use an ApplySimple statement which utilizes the database function within it instead of relying on analytical engine functions.