KB15618: "Error: Intelligence Server Private Byte limit has reached. ..No memory to be contracted." is displayed when generating SQL for a report that uses multi-sourcing in MicroStrategy 9.x and 10.x

SYMPTOM
The following error is thrown when trying to generate SQL or run a report that makes use of multi-sourcing in a Strategy 9.x environment.

Error: Intelligence Server Private Byte limit has reached. ..No memory to be contracted.

 
If the Intelligence Server is monitored it can be seen that any memory available to it is taken up before the error is displayed and that the error only shows up after the Intelligence Server has used up all memory.
This only occurs for some reports and change the attributes or filters present on the report can cause the error to not display.
 
CAUSE
This issue is caused by a known issue dealing with optimization for SQL generation with multi-source reports. It only affects a small number of reports with specific data models behind them.
 
ACTION
Currently, this issue is being reviewed by Strategy for a potential code fix on an upcoming Strategy release. 
 

KB15618