"Unexpected Server Error" in SEPM when moving clients between groups

Products

• Endpoint Protection

Issue/Introduction

When you attempt to move one or more clients from one group to another within the Symantec Endpoint Protection Manager (SEPM) interface, you receive an "Unexpected Server Error" message.

 

"Unexpected Server Error" in SEPM interface.

AgentRegister-*.log files contain the following:
[DATE] [TIME] THREAD [THREAD] WARNING: com.microsoft.sqlserver.jdbc.SQLServerException: Could not allocate space for object 'dbo.SEM_CLIENT'.'I_SEM_CLIENT_USN' in database 'sem5' because the 'FG_INDEX' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
 

 

Environment

Cause

Your SQL database needs to increase in size but cannot.

Resolution

Adjust the size limit in SQL for your Symantec database.

 

To adjust the database size limit:

1. In SQL Server Management Studio, connect to the database instance that contains the SEPM database.

2. Under Databases, right-click the database used by the SEPM.
   NOTE: By default, the database is named sem5.

3. Click Properties.

4. In the Database Properties window, in the left pane, click Files.

5. In the right pane, in the Autogrowth column, click the ellipsis (...) next to the listed growth configuration.

6. In the Change Autogrowth window, under Maximum File Size, increase the Restricted File Growth size or click Unrestricted File Growth, as appropriate to your environment, and then click OK.

7. Repeat steps 5 and 6 for each listed file, and then close SQL Server Management Studio and restart the SQL Database service.