Removing or updating a KSG linked to a Monitoring Policy creates orphanged job(s) (NETIQKB73340)

  • 7773340
  • 23-Jan-2012
  • 23-Feb-2012

Environment

NetIQ AppMangaer 8.x
NetIQ AppManager Performance Profiler 4.1.2

Situation

Removing or updating a KSG linked to a Monitoring Policy creates orphanged job(s)

Resolution

This issue has been corrected and will be included in the 4.5 release of NetIQ AppManager Performance Profiler. 

For customers that experience this issue, please contact NetIQ Technical Support and reference this Knowledge Base article and we can provide a script that will clean up existing stream ids.

Cause

This issue is caused by the AppManager Performance Profiler (AMPP) module. During the process of extracting the XML from the AMPP Knowledge Scripts, the StreamID is being set. This uses as a base the NEWID function to ensure each new stream has a unique ID.

By convention, the CreateDataHeader procedure does this by finding the current lowest StreamID (this process is only followed when a Stream Name is used). The seed for this is -1 so each new stream would be sequentially lower (-1, -2, -3 etc). The AMPP mod is not following that convention when using NEWID function.

The problem is that when data is being marked for delete - the stream ID created by the AMPP mod can result in a value that when processed in the delete becomes bigger than an integer (since the delete process includes a calculation that applies the mod time).

Additional Information

Formerly known as NETIQKB73340