Hi,
we are using above mentioned solution for monitoring our FAS Systems (7-Mode and cDOT).
After installing the OCPM 4.1 within SCOM 2012R2 our Exchange SCOM Management Pack did not work anymore.
A call at Microsoft yieled this:
"
ROOT CAUSE:
==============
The issue is caused because in OM 2012 the sproc p_SelectForTypeCache can return NULL values for ImageCategory when retrieving the Image Ressources if some Management Packs did not have this defined. In this case the Management Pack which was causing this was the MP, but essentially the sproc should be fixed to not return NULL values.
Following shouldn't return NULL for the column ImageCategory :
"SELECT [ImageReference].[ImageId], [ImageReference].[ReferenceId], [ImageReference].[ManagementPackId], [ImageReference].TimeAdded, [ImageReference].LastModified, SUBSTRING([EnumType].EnumTypeName, 39, 100) AS ImageCategory, [MPElementView].[MPElementName],
[ManagementPack].[ContentReadable]
FROM dbo.ImageReference
JOIN dbo.[Resource] on ([Resource].ResourceId = ImageReference.ImageId)
LEFT JOIN dbo.[Category] ON [Category].CategoryTarget = [Resource].ResourceId
LEFT JOIN dbo.[EnumType] ON [EnumType].EnumTypeId = [Category].CategoryValue
JOIN dbo.MPElementView ON (ImageReference.ReferenceId = MPElementView.MPElementId)
INNER JOIN dbo.[ManagementPack] ON dbo.ManagementPack.ManagementPackId = [ImageReference].ManagementPackId AND dbo.ManagementPack.ContentReadable = 1
WHERE dbo.[ImageReference].[ReferenceId] IN (select dbo.ManagedType.ManagedTypeId from dbo.ManagedType)
and dbo.[Resource].ResourceType = 4"
Any ideasd how to fix this?
Will there be an update of OCPM fixing this?
Thanks in advance!
regards