Symantec Management Platform (Notification Server)

Hey,

when we try to run some of our CMDB Rules in the Management Console, they will fail with the following error:

The import rule 'Update Asset with User Cost Center' failed. Error: The stored procedure 'spDCN_GetResourcesByGuid' wasn't found.

So I was looking for this Stored Procedure, or something similar, on our SQL-Server but there was nothing I could use!
But I'm sure, that it was there, beacuse this rule ran for a couple of months without any problems..

Does someone here still have this stored procedure on his SQL-Server? Or can someone tell me, what this one would do exactly and which parameters it has, so that I can write it by my own? We really need this! We already tried to rewrite our CMDB Rule, but with no success.. Everytime the same error!

Thanks!

Matthias

CREATE PROC [dbo].spDCN_GetResourcesByGuid    @guids ntext,   @resourceType uniqueidentifier,   @includeDerivedTypes bit  AS     if (@includeDerivedTypes = 1)   begin    select [Guids].ui, rr.Guid as [FoundGuid]    FROM dbo.fnListToGuidTableDal2(@guids) AS [Guids]    LEFT OUTER JOIN     (select r.Guid, r.Name FROM vResourceItem r    JOIN ResourceTypeHierarchy rth ON r.ResourceTypeGuid = rth.ResourceTypeGuid    WHERE rth.BaseResourceTypeGuid = @resourceType) rr on rr.Guid=[Guids].ui    order by [Guids].listpos asc   end   else   begin    select [Guids].ui, r.Guid as [FoundGuid]    FROM dbo.fnListToGuidTableDal2(@guids) AS [Guids]    LEFT OUTER JOIN  vResourceItem r on r.Guid=[Guids].ui and r.ResourceTypeGuid = @resourceType    order by [Guids].listpos asc   end

However, I would run a repair on CMDB Solution instead from within SIM.  It may be that you need to repair additional solutions if this repair doesn't get it, such as Asset Management Solution or the entire Asset Management Suite.

It might be a good idea to check if you have these stored procedures:

• spDCN_GetResourcesByName
• spDCN_GetItemsByGuid
• spDCN_GetItemsByName

Did you by any chance upgrade Management Platform or Solutions before you noticed this issue?

Thanks! But it doesn't seem to help.. I will make a CMDB repair on sunday, because the other 3 procedures are missing too..

That will be a great weekend ;)

This may not apply but you could be missing addtional stored procedures as well as referenced by this article:

http://www.symantec.com/docs/TECH162609

Did the repair fix it, or cnpalmer's KB reference?