"Failed to submit" during replication; 'FG_LOGINFO' filegroup is full error in SEPM log

Products

• Endpoint Protection

Issue/Introduction

Replication is failing between to Endpoint Protection Manager (SEPM) sites.

Around 10% to 20% during the "Downloading" status, the replications fails with the error "Failed to submit".

Cause

The filegroup FG_LOGINFO has reached its upper limit on the SQL server hosting the SEPM database.

Resolution

Adjust the upper limit for the FG_LOGINFO filegroup on the SQL server:

SQL Permissions Required: sa or user with sysadmin server role.

1. Open SQL Server Management Studio. 
2. Connect to database instance containing the SEPM database.
3. Expand Databases. Find the database used by SEPM (default name is "sem5")
4. Right click on the database and select properties.
5. Choose Files.
6. Click the "..." button in the Autogrowth column next to sem5_loginfo.
7. Adjust the Maximum File Growth to a higher value. 

NOTE:  You may need to experiment with different values depending on how much log information you are storing, so monitor the scm-server log for future "FG_LOGINFO" errors.  If you continue to see these errors, you will need to readjust this value higher.

NOTE:  Use this method with caution. If the DB is reaching the set size limitations, there may be DB corruption present.
 

Alternate solution:
A common misconception is that lowering the log retention settings will reduce size of the filegroup on the SQL server.  The only effect this will have is limit the number of entries in the file itself.  The rest of the space in the file will remain as whitespace and the filesize itself will remain the same. 

For example,  the default log retention settings set to 60 days and 10000 lines.  The default filegroup upper limit is 20MB.  If you lower the number of log entries to 30 days and 5000 lines, the sem5_loginfo will then only contain 30 days or 5000 lines of log information (which ever is reached first), however filesize will stay at 20MB.

To actually reduce the filesize of the sem_loginfo file, you must use the SQL shrink process as described here:

http://technet.microsoft.com/en-us/library/ms190757.aspx

NOTE: In the Shrink File dialog, be sure to select "Data" as the File Type and "FG_LOGINFO" as the Filegroup.

To lower the log retention settings:

1. In the SEPM click on Admin -> Servers -> View Servers: Local Site -> Task: Edit Site Properties -> Log Settings Tab
2. Lower the log settings for the various log types listed as appropriate.

NOTE:  This change will take effect at the SEPM's local midnight time as part of the daily SEPM  maintenance.  Once that has happened, you can then run the shrink procedure on the SQL server.