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


Monitoring HYPER-V environment with SCOM 2012

Monitoring resources to make sure they are in the optimal condition never end battle. When things go wrong you need to know where and when it occurs exactly rather than speeding countless hours for troubleshooting. Welcome to SCOM which is dominant in that area. From me personal opinion SCOM is more powerful in Apps monitoring and that is what should be mattered 🙂

Saying that monitoring the underline hardware and related equipments have same weight over the time to provide complete picture of your environment. Starting with SCOM 2012 Microsoft introduce the concept of 360 monitoring which means exactly monitoring everything.

SCOM team recently released HYPER-V 2012 host monitoring management pack. If you’re having HYPER-V environment and want to to what’s going on under the hood this MP is the tool you should have 🙂 You can download the latest from the CodePlex web site.

Latest features been added in the MP are,

  • Support for Windows Server 2012 R2 hyper-V
  • Hyper-V Extended Replica Monitoring and Dashboard

 

SCOM1 
Replica virtual machine monitoring

Sources:
http://blogs.technet.com/b/cedward/archive/2013/06/21/hyper-v-2012-management-pack-extensions.aspx

http://blogs.technet.com/b/askcore/archive/2013/12/10/hyper-v-management-pack-extensions-2012-2012r2-available.aspx

Azure services monitoring with SCOM 2012 R2

For the last few months Windows Azure (Microsoft Public Cloud service) has gain big momentum. From SMB to all the way to Enterprise companies there are services can be leveraged from Azure offerings. In this article I’m more focus on how we can monitor Azure deployed services by using in-house monitoring solutions. Specifically I’m going to look at SCOM (System Center Operations Manager) monitoring Azure services.

First thing I have to do is provision VM’s in azure with services to be monitored. Now i could have taken couple of hours and create VM’s and then setup Exchange, SharePoint…etc but this is time consuming. After further searching I found out all of these can be automated with couple of PS commands which has been freely available in the Github. Now that is real time saving, entire SharePoint farm along with AD and SQL without much hands on 🙂

image  image image image

It took nearly 2 hours time (hey no much complains since everything is automated) to complete the entire task. Once that completed we’re going to monitor them from SCOM. I’m assuming you’re having SCOM 2012 SP1 or 2012 R2 environment. So getting back to SCOM side first thing we need to do is download the relevant MP (Management Packs) for Azure monitoring. You can get it from here.

Assuming you’ve downloaded and extracted the MP to root (C:\SCOM-MP\System Center Management Pack for Windows Azure) steps are as follows to import them into SCOM,

image image image

Select both MP by pressing and holding Ctrl key,

image

In my case I’ve already imported those MP’s earlier but when you do this you’ve to complete the task by importing them to the SCOM.

image
Note: Keep an eye about the MP version as well

Next task is to make sure we get the SCOM connected with Azure services you’ve publish your services. You’ll need to create and upload a management certificate to work with Windows Azure.  If you need more information how-to-do guide then please follow below two web urls,

http://msdn.microsoft.com/en-us/library/windowsazure/gg551722.aspx & http://msdn.microsoft.com/en-us/library/windowsazure/gg432987.aspx

Once you downloaded your Azure subscription management certificate to the SCOM server we can get started by configuring SCOM server to be integrated with Azure subscription. Go ahead and open the SCOM console. In the Operations Manager console select “Administration” then select “Windows Azure” and finally select “Add subscription

image image image

Once the above task completed you’ll get the good result 🙂

image

Now give SCOM little bit time to go ahead and scan your Azure subscription to find out what you’ve deployed. Once you’ve given ample time come to Monitoring section of the SCOM Console,

image

Under the Windows Azure section you can expand and check what information SCOM has detected about your Azure subscription. (Eg: Virtual machines, Roles, Services..etc)

image image image

Please note by default Azure services are not monitored until we manually configure them to do so.

In my next article I’ll explain how the Azure Cloud services can be monitored in detail level 🙂

New DNS MP for SCOM 2012 has been released

As the heading says Microsoft team has released their latest update for the DNS Management Pack fro SCOM. Compare with the previous MP this is completely revamp one based on their experience they gathered during the deployment time with XBOX team. Look forward to take this to customer environment since previous version had lot of unnecessary noises.

Daniel Savage (Program Manager) of System Center team explain more details about this release and why they feel this release will be worthy than previous version. You can read more about it here. You can download the latest MP from here.

Event id 7000, 7015, in SCOM 2012

In a recent SCOM deployment at customer site I came across the issues of SCOM Management Server throwing above mentioned event ID’s as follows,

image

image

Apart from SCOM Management Console throws the error Service account password is incorrect. Since the instruction are very clear all I had to do is go to scom management console—-> Administration —>Run as configuration—>Accounts and select the relevant Runas account and change the password. (in my case someone has changed the domain password in the AD side) Once that completed I’ve restarted the SCOM server itself hoping things would be fine. Well it didn’t Sad smile

Further research I found out this has to be change on the “Data Warehouse Report Deployment Account” section as well,

image

After another service restart fingers crossed but still getting the error in the SCOM Management Server Event viewer. With several web research I found out I’m not the only person who encounter this issue. Went back to the properties of the “Data Warehouse Report Deployment Account” and check Distribution tab. Found out I’ve selected the “More secure” option and selected the SCOM Management Server (This is the correct way)

image

what I did to solve the problem is selected the “Less Secure” Apply the change and again select “More Secure” and define the SCOM Management server and restart the SCOM services. This solve the problem and got the happy news of green mark on the SCOM Management server in the console Smile

image

How to Remove SCOM 2012 Management Packs Through PowerShell

While I’m working on my SCOM LAB environment I came across the requirement of removing the Active Directory Management Pack I’ve install into the system. One of the painful process is removing them one by one from the console, top of that I found out I’ve imported the MP’s related to other languages as well Sad smile

There has to be an easy way for this right? You guess correct thanks to tight PowerShell integration with SCOM Microsoft has provided a solution for that. With below mention command you can remove the management pack related to any software application. We only provide a keyword and base on that PowerShell will do the MP library search and remove the relevant MP’s.

image

In the above command you can replace the “AD” with any keyword. More information can be found on below mention TechNet article,

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