Component and Flows not loading

Document ID : KB000093072
Last Modified Date : 26/04/2018
Show Technical Document Details
Issue:
When we try and view flows, processes, shared components and process execution, the left and center panes fail to load content (no errors, just "loading" with a spinning cog). We've restarted the Nolio services and even restarted the server, but the issue remains.
Environment:
RELEASE AUTOMATION, Release: 6.5.0.10007
Operating System: Win Server 2012 R2
Cause:
During the review of the logs we can see that the error generated when end-user observed above behavior is as below.
 
2018-04-12 13:05:05,000 [asapJobsScheduler_QuartzSchedulerThread] WARN  (org.springframework.scheduling.quartz.LocalDataSourceJobStore:198) - Failed to override connection auto commit/transaction isolation.
com.microsoft.sqlserver.jdbc.SQLServerException: There is insufficient system memory in resource pool 'internal' to run this query.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
    at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)
    at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84)
    at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39)
Resolution:
The above issue is due to some limitation been set on the DB in terms of maximum memory and DB crossing that limit resulting in above error. There is often time when application need to execute complex queries and may require extensive memory. This issue can be resolved by raising the limit exposed on max database memory allocation.