SYMPTOM :
During a report execution, the following error message is displayed in Strategy Developer 9.x and no data is retrieved:
SQL Generation CompleteQueryEngine encountered error: Getting result table from child process failed. Data truncated. Error type: Max memory consumption during data fetching exceeded. Fail to deserialize table. Max memory usage exceeded. Max memory size limit: 1 MB. SQL Statement: <SQL statement> Error in Process method of Component: QueryEngineServer, Project Strategy Tutorial, Job <xxx>, Error Code= -2147212544.
CAUSE :
This issue happens because the report result set size has exceeded the project Governing Rule defined for the parameter Memory consumption during data fetching (MB).
ACTION :
Adjust the value defined for the parameter Memory consumption during data fetching (MB) under Project Configuration > Governing Rules > Default > Result Sets as in the picture below:
Also, the report can be accordingly adjusted to retrieve a smaller volume of data by using filters, for instance.
