How to solve SQL exceptions that occur on removing a matter in Legal Processing

SYMPTOMS

Attempts to delete a matter in Legal Processing fail. The matter that is supposed to be deleted is still present  

The following error appears in the Legal Processing log file: "ERROR ZyLAB.EDiscovery.DataService.MatterDeletion.MatterDeleter - Deletion action 3 failed after 4 attempt(s). System.Data.SqlClient.SqlException (0x80131904): User does not have permission to perform this action."

Matter is not completely deleted.

CAUSE

SqlExceptions might be caused by insufficient SQL permissions.

The following SQL stored procedure: sys.sp_updatestats, is used by ZyLAB Legal Processing during the delete process.
Based on the use of this stored procedure, the user has to be SQL server system Administrator or the database owner (that is, the owner of the database not role db_owner).

You can retrieve the owner of the database using SQL Server Management Studio.
Most likely the owner will be an 'sa' (database owner) or the user that created the database.

Thus, if the ZyLAB user is not the system administrator then this error will be thrown.

RESOLUTION

This can be done in SQL Server Management Studio:

• Right click on the database instance
• Select properties
• Go to the "files" tab and change the owner

APPLIES TO

3.1