Novell Home

My Favorites

Close

Please to see your favorites.

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.

Environment

NetIQ AppManager 7.0.x
NetIQ AppManager 8.0.x

Situation

The NetIQ Monitoring Policy QDB scheduled SQL task is failing with the following error:
 
'DeleteMonitoringPolicy: The knowledge script group applied from control center cannot be removed from OC [SQLSTATE 42000] (Error 50000).'

Resolution

To correct this issue first run the following query against the QDB (repository):
 
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.

Cause

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.

Disclaimer

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
    • NetIQAppManager

Did this document solve your problem? Provide Feedback