Symantec Endpoint Protection Managers using a Microsoft SQL database no longer host the latest definitions and client install packages.

Article:TECH106075  |  Created: 2008-01-30  |  Updated: 2014-04-11  |  Article URL http://www.symantec.com/docs/TECH106075
Article Type
Technical Solution


Subject

Issue



Managers that use a Microsoft SQL database no longer apply new content updates or client installation packages. Manual or scheduled LiveUpdate sessions result in the content being downloaded, but LiveUpdate reports that definitions are up to date. Applying Intelligent Updater or importing client packages into the Symantec Endpoint Protection Manager (SEPM) fails to update the SEPM database.


Error



The following error is written to the scm-server0/1.log:

2008-09-30 12:29:11.968 SEVERE: Unexpected server error. in: com.sygate.scm.server.consolemanager.requesthandler.BinaryFileHandler
com.sygate.scm.server.metadata.MetadataException: Could not allocate space for object 'dbo.BINARY_FILE' in database 'SEM5' because the 'FG_CONTENT' 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.


Cause



The SEPM installation sets a default maximum size for the FG_CONTENT filegroup to 20,000 MB in size.  This space is used by content (virus definitions, IPS signatures, etc) as well as client packages that can be exported by the SEPM.  This amount of space can handle all existing client packages (current version and all historical packages) and the default enterprise content retention of 30 revisions.  Storing more content revisions may require a SQL administrator to increase the maximum autogrowth size of the FG_CONTENT filegroup.

The default size may no longer be large enough for 30 revisions.  Please monitor the size in case the maximum size needs to be increased..


Solution



If you require more than 30 revisions of content, work with your database administrator to increase the maximum Autogrowth size for the database file(s) in the FG_CONTENT file group. If you do not require a large number of content revisions, this problem can be worked around by lowering the number of content revisions stored in your SEPM database to the default of 30.

Increasing the maximum Autogrowth size

You will need to increase the maximum Autogrowth setting for the file(s) in the FG_CONTENT Filegroup for each revision of content above the default maximum of 30 you wish to keep. This will ensure the database allows for enough expansion to prevent this problem in the future.

Note: As of April 10, 2014, a single revision of content will use approximately 765 MB of space.  This number grows each day.

 

Reducing the number of content revisions

  • Log in to the Manager console
  • Click Admin>Servers>Local Site.
  • Click Edit Site Properties>LiveUpdate.
  • Change the value of "Number of content revisions to keep:" to 30 or less.
  • Click OK.



Legacy ID



2008093013225248


Article URL http://www.symantec.com/docs/TECH106075


Terms of use for this information are found in Legal Notices