Cannot upgrade SCOM 2012 R2 for UR7

This is another quick update which I came across during the field job (yes I’m back on the roots apart from sitting and designing solutions J). We’re in the process of making SCOM 2012 R2 environment updated to n-1 UR update. At this stage latest version is 8 and we decided to apply UR 7.

When I ran the command  greeted with following errors J

Msg 1105, Level 17, State 2, Procedure fn_AlertViewChanges, Line 2

Could not allocate space for object ‘sys.syscolpars’.’clst’ in database ‘OperationsManager’ because the ‘PRIMARY’ 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.

Msg 1105, Level 17, State 2, Procedure fn_AlertViewChangesNoContext, Line 2

Could not allocate space for object ‘sys.sysobjvalues’.’clst’ in database ‘OperationsManager’ because the ‘PRIMARY’ 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.

Msg 1105, Level 17, State 2, Procedure p_EffectiveMonitoringWorkflow, Line 3

Could not allocate space for object ‘sys.sysobjvalues’.’clst’ in database ‘OperationsManager’ because the ‘PRIMARY’ 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.

Msg 1105, Level 17, State 2, Procedure p_GroomTypeSpecificLogTables, Line 2

Could not allocate space for object ‘sys.sysobjvalues’.’clst’ in database ‘OperationsManager’ because the ‘PRIMARY’ 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.

Msg 1105, Level 17, State 2, Procedure p_InstallTypesAndReltypes, Line 3

Could not allocate space for object ‘sys.sysmultiobjrefs’.’clst’ in database ‘OperationsManager’ because the ‘PRIMARY’ 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.

Msg 1105, Level 17, State 2, Procedure p_DiscoverySourcesEligibleForDeletionDueToOverridesProcedure, Line 2″

Looking carefully at the error messages it’s very clear disk full is the culprit. But again SCOM DB server having enough free storage. Problem related to low storage capacity define in the “OperationsManager” DB. Once the value has been modified UR7 upgrade ran smoothly.


Normally Log files capacity should be 50% of the size of Operations Manager DB J


Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s