Problem

When I create a new project it is not displayed in the project list. The System Log may have one or both of the following errors: 

"Error creating case: CaseId : 0, CaseName : XXXX: Case creation failed."

"Invoke operation 'CreateProject' failed. Exception of type 'System.ServiceModel.DomainServices.Client.DomainOperationException' was thrown."

The AdgBusinessServices log may have one of the following errors:

System.Exception: Case creation failed. ---> ADG.Database.DAL.DALException: System.Data.SqlClient.SqlException (0x80131904): Minimum server memory value (XXXX) must be less than or equal to the maximum value (XXXX).

System.Exception: Case creation failed. ---> ADG.Database.DAL.DALException: System.Data.SqlClient.SqlException (0x80131904): The configuration option 'max server memory (MB)' does not exist, or it may be an advanced option.

 

 

Resolution

  1. Open SQL Management Studio
  2. Connect to your SQL server
  3. Run the following query to set max and min memory settings:

    sp_configure 'min server memory (MB)', 0;
    sp_configure 'max server memory (MB)', XXXX;
    RECONFIGURE WITH OVERRIDE;
    GO

    Substituting XXXX for half the total RAM in the system

  4. Attempt to create a new case

 

Cause

When creating a project, the system will automatically set SQL's maximum memory to half on the RAM in the SQL machine.  If the minimum RAM has been previously set to be equal to or greater than half the available RAM, this will result in a conflict and project creation will fail.  If the maximum RAM setting is somehow missing, it will fail to set that.