ReportAM_CompLic Knowledge Script fails. (NETIQKB48444)

ReportAM_CompLic Knowledge Script fails.
Error: 'Number: 0; Description: ; Comment: Problem stored procedure execution; Source:'

To remove the orphaned objects from the repository:

1. Back up your repository.
   
2. In SQL Query Analyzer, connect to the SQL Server housing the repository and select the repository (QDB) database.
   
3. Execute the following SQL statement to identify the orphaned objects:
   
   Select ObjID, Name, convert(varbinary,Status) from Object Where Status & 0x08000000 =0
   And RootMachineObjID Not in (Select ObjID from Object Where Status & 0x08000000 =0)
   
   
4. Execute the following SQL statements to find out if the object has direct ties to other data in the repository:
   
   Select * from ViewHierarchy where ObjID in (select ObjID from Object Where Status & 0x08000000 =0
   And RootMachineObjID Not in (Select ObjID from Object Where Status & 0x08000000 =0))
   
   Select * from JobObject where TargetObjID in (select ObjID from Object Where Status & 0x08000000 =0
   And RootMachineObjID Not in (Select ObjID from Object Where Status & 0x08000000 =0))
   
   
5. If these two statements yield 0 rows, proceed to the next step. If one or more row is returned, contact NetIQ Technical Support.
   
   
6. Execute the following SQL statement to delete the orphaned objects:
   
   Delete Object Where Status & 0x08000000 =0
   And RootMachineObjID Not in (Select ObjID from Object Where Status & 0x08000000 =0)
   
   
7. Execute the following statement to verify that the problem is resolved:
   
   EXEC dbo.LicenseAudit
   
   
8. If the task completes successfully, run the REPORTAM_CompLic report Knowledge Script. If the task does not complete successfully, repeat steps 2-6 or call NetIQ Technical Support.

One or more objects failed to be deleted from the repository when a machine was deleted.

Formerly known as NETIQKB48444