KB39938: "SQL Engine encountered an exception for free form SQL report [[DFCENGINE] Engine Logic: Invalid CompUnit base class method is called.]" when using derived tables in a Freeform SQL Report in MicroStrategy Developer 9.4.x-10.x and Netezza data WH

SYMPTOM:
In Strategy Developer 9.4.x-10.x when using a Netezza data warehouse, when running a Freeform SQL report that is set to use derived tables, users get the following error message:

 
 
Sample Code/Error
Sample Code/Error
 Error: SQL Engine encountered an exception for free form SQL report Engine Logic: Invalid CompUnit base class method is called.]
 
 
This issue can be observed when the following VLDB Properties as set:

• Drop Temp Table Method >  Do nothing
• Intermediate Table Type > "Derived table"
• Maximum SQL Passes Before Fallback >  3.

CAUSE:
This is a known issue in Strategy Developer 9.4.x-10.x .
 
ACTION:
Strategy will continue to investigate and post updates as soon as they are available.
 
WORKAROUND:
Change the VLDB settings of the report to not use derived tables to workaround this issue.