SCOM : baseOS MP version 6.0.6958.0: what a shame

A workaround by Kevin Hollman by the end of this article.

I have always been dispointing with Microsoft handling language pack. But now I am pissed off, because,even the English alerts lacks of sense.

Below, the alert message in French :

Mémoire insuffisante sur le disque {0} de l’ordinateur {1}. Les valeurs ayant dépassé le seuil sont {2}% Espace libre et {3} Mégaoctets disponibles.

You can translate :

Insufficient memory on disk {0} on computer {1}. The values exceeding the threshold are {2}% free space and {3} free megabytes

While the english MP  :

The disk X: on computer myserver.com  is running out of disk space.

So in French, as in English no information on the values exceeding the threshold. Furthermore no coherence between the French MP alert and the English one.

If I was selling this to my client, I would be rejected.

Mémoire insuffisante sur le disque {0} de l’ordinateur {1}. Les valeurs ayant dépassé le seuil sont {2}% Espace libre et {3} Mégaoctets disponibles.

A workaround by Kevin Hollman I will not use it since I have too many overrides to deal with : http://blogs.technet.com/b/kevinholman/archive/2011/11/17/opsmgr-logical-disk-free-space-alerts-don-t-show-percent-and-mb-free-values-in-the-alert-description.aspx

SCOM – Troubleshooting – Failed to store data in the Data Warehouse. Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Latin1_General_CI_AS” in the equal to operation.

In my environnement this problem only occurs for the MP : Microsoft.Exchange.2010.Reports.

Since I did not need Exchange reports, I deleted them. But so far the event still appears.

So I recommend the workaround done by Marnix Wolf :  http://thoughtsonopsmgr.blogspot.com/2010/04/failed-to-store-data-in-data-warehouse.html

SCOM : Visio add-in tip : add link to diagram view

The visio Add-in is a powerful tool to make Operator Console more efficient than the builtin diagram view.

I created few high level visio diagram. But in some case I needed to use the diagram view and I didn’t want to waste my time going through the Operating Console, monitoring, etc.

That’s why I added links to the diagram view, with the following method:

• Open your SCOM visio diagram
• Right click on a object
• Modify Hypertext Link
• Add / Create
• URL : http://WebConsoleServer:51908/default.aspx?DisplayMode=Pivot&ViewType=DiagramView&PmoID=[ID]
• Replace [ID] by the one you have in the Health Explorer (or Alert View) hypertext link.
• Description : Diagram View

Hope this will be of any use.

SCOM : Reporting – Generic performance report – Target each Windows computer as group

Though it is quite simple and wrote long time ago by others. I feel like writing about it (at least for me).

As I was trying to create a report with the Operations Manager Console on the Memory Available Megabytes 2008 counter from the Microsoft Generic Report Library, I failed a couple of time before finding the cause.

The report I was using is Performance. The report details tells : Most performance counters are targeted at the Windows Operating System so when using the Object Picker select object of class “Windows Operating System”.

When I failed, I was searching for object name : “myserver”. However this request never returns object of class “Windows Operating System” but in my case : Windows Computer, and Health Service. I was always choosing the Windows Computer object thinking I was right.

Solution : You have to search for “Windows” only, select Windows Operating System objects and search in the path the server name.

http://thoughtsonopsmgr.blogspot.com/2009/08/opsmgr-and-empty-reports-part-4.html

http://blogs.catapultsystems.com/cfuller/archive/2010/07/22/creating-useful-custom-reports-in-opsmgr-how-to-create-a-simple-free-disk-space-report.aspx

SCOM 2007 R2 CU5 arrived

 

 

 

 

 

 

Kevin Hollman, as always, did a great job on the Kevin Hollman CU5.

 

Joining SCOM 2012 Comunity Evaluation Program

I will take part in the SCOM 2012 CEP.

No holidays anymore )

SCOM 2012 Beta out

Since I was on holiday, I missed it.

Can’t wait to test it.

Thanks to Kevin Hollman : http://blogs.technet.com/b/kevinholman/archive/2011/07/21/operations-manager-2012-public-beta-has-launched.aspx

AD DC Demoted still showing in DC State view

Great article from rob : SCOM’s “un-discovery”. What doesn’t work here… And how to correct it

SCOM – Troubleshooting : event id 31551 occuring every 10 minutes

• Symptoms :
  • event id 31551 occuring every 10 minutes
  • event id 8000 occuring arround the event id 31551

I was able to resolve the issue thanks to Mickeal O Karlsson : http://social.technet.microsoft.com/Forums/en-US/operationsmanagergeneral/thread/fd84641c-ecdd-4892-8fb2-77ed7c85ace7/

• On the database OperationsManagerDW, new query :

DBCC CHECKIDENT ("EventChannel");

It should return 32767 maximum upper limit of SMALLINT type.

• Cause : Some process increment this number to 32767 + 1 which cannot be stored in a smallint variable.

• Solution that worked for me : RESEEDing to 3 solve the problem because the incrementation can goes on again.

DBCC CHECKIDENT ("EventChannel", RESEED, 3);

• Hypothesis

1. 3 is the number of rows in your dbo.eventchannel table
2. I think that there is a process who should have done so but failed for some reason, or there’s no process for RESEEDing and the binaries should have behave correctly so that 32767 should have not be; reached.

My comment is provided as is. There’s no warranty that it will work for you.

Event ID 31551 :

Failed to store data in the Data Warehouse. The operation will be retried.

Exception  'SqlException': Sql execution failed. Error 8115, Level 16, State 1,  Procedure EventChannelRowIdResolve, Line 67, Message: Arithmetic  overflow error converting IDENTITY to data type smallint.

One or more workflows were affected by this.

Workflow name: Microsoft.SystemCenter.DataWarehouse.CollectEventData

Instance name: My_Instance.domaine.fr

Instance ID: {12345678-1234-1234-1234-123456789012}

Management group: My Management GROUP

Event ID 8000 :

A  subscriber data source in management group My Management GROUP has  posted items to the workflow, but has not received a response in  286 minutes.  Data will be queued to disk until a response has been  received.  This indicates a performance or functional problem with the  workflow.

Workflow Id : Microsoft.SystemCenter.DataWarehouse.CollectEventData

Instance    : My_Instance.domaine.fr

Instance Id : {12345678-1234-1234-1234-123456789012}

SCOM : MP Authoring – SCX – Unix.Computer.Role

As for Windows the class Windows.Computer.Role is used for IIS Server Role, I use Unix.Computer.Role for Unix/Linux Server Role such as Postgres, Apache, etc.

My problem was that the Unix.Computer.Role class has, by default, no dependency rollup monitor in the Unix.Computer class.

Therefore I overrode the Microsoft.Unix.Library MP and created a dependency rollup monitor targeted at the Unix.Computer class availability health that rolls up the availability of the Unix.Computer.Role class.

Now when I create a class which inherits from Unix.Computer.Role class its availability health automatically rolls up in the Unix.Computer Class.