NetIQ Monitoring Policy SQL job failing: DeleteMonitoringPolicy: The knowledge script group applied from control center cannot be removed from OC
This document (7012131) is provided subject to the disclaimer at the end of this document.
NetIQ AppManager 8.0.x
select * FROM dbo.CC_OCMPToDelete A INNER JOIN dbo.MonitoringPolicy B ON B.ObjID = A.ObjID AND B.VirtualKSID = A.VirtualKSID
If this returns anything then run the following query against the QDB (repository) to correct the issue:
DELETE A FROM dbo.CC_OCMPToDelete A INNER JOIN dbo.MonitoringPolicy B ON B.ObjID = A.ObjID AND B.VirtualKSID = A.VirtualKSID
Once this completes then start the NetIQ Monitoring Policy QDB sql job.
A Monitoring Policy is defined twice and needs to be removed in order for the NetIQ Monitoring Policy QDB scheduled SQL task to be able to complete its maintenance process.
This Support Knowledgebase provides a valuable tool for NetIQ/Novell/SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.
- Document ID:7012131
- Creation Date:11-APR-13
- Modified Date:17-APR-13
Did this document solve your problem? Provide Feedback