One or more steps in either the RiskFabric Processing or RiskFabric Intraday Processing jobs fails and a message similar to the following is logged by the SQL Server Agent:
Error Message: There is insufficient system memory in resource pool 'default' to run this query. [SQLSTATE 42000] (Error 50000). The step failed.
Release : 6.x
This error is caused by insufficient resources on the server hosting SQL Server services for the tasks being executed at the time of failure. This is most commonly seen when one of the RiskFabric processing jobs is running concurrent with other SQL Server Agent jobs (e.g., database backup or maintenance tasks). This can also occur when performing a sufficiently large DIM search in the RiskFabric portal while processing is running.
Ensure the allocation of system memory to the SQL Server service is 80% by following this procedure:
net stop MSSQLSERVER
net start MSSQLSERVERNOTE: If you are hosting the RiskFabric database in a named instance, execute these commands instead:
net stop MSSQL$<Instance Name>
net start MSSQL$<Instance Name>
If SQL Server's memory allocation is already set to 80%, evaluate the following options: