Follow

Unable to Create Case due to SQL Memory Settings

Created by: Brendan Bone
Created date:
Last Updated date:

Problem

When I create a new project in Summation Pro or eDiscovery 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, Summation/eDiscovery 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, Summation/eDiscovery will fail to set that.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk