Component and Flows not loading

Products

• CA Release Automation - Release Operations Center (Nolio)
• CA Release Automation - DataManagement Server (Nolio)

Issue/Introduction

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.