The NetIQ License Audit Job is failing. (NETIQKB48090)

  • 7748090
  • 02-Feb-2007
  • 10-Jan-2011

Environment

NetIQ AppManager 6.x
NetIQ AppManager 7.0.x

Situation

The NetIQ License Audit Job is failing.

Error: 'Executed as user: NT AUTHORITY\SYSTEM. GetLicenseIDForRootServerView: error while getting the final LIKE id for license [SQLSTATE 42000] (Error 50000) Associated statement is not prepared [SQLSTATE HY007] (Error 0) LicenseAudit: error executing GetLicenseIDFromRootServerObjID for rootserverobjid :<NumberofObjectid>[SQLSTATE 42000] (Error 50000). NOTE: The step was retried the requested number of times (2) without succeeding. The step failed.'

Exec dbo.licenseaudit reports an error.

Resolution

WARNING! In these occurrences, you must manually remove the child objects.  Be sure to verify you have a full database backup of your AM Repository (QDB by default) prior to following this process.

To remove the residual items:

  1. Run the following query:

    Select * from object where Rootmachineobjid =  <NumberDisplayedForTheRootObjectInTheError>
  2. If numerous items are returned, run the following query to verify that the residual items have no parent object:

    Select * from object where objid =<NumberDisplayedForTheRootObjectInTheError>
  3. If nothing is returned, run the following query to remove the residual items:

    Delete from object where RootMachineObjid =<NumberDisplayedForTheRootObjectInTheError>

Cause

A Parent Object was removed from the Object table, but the children objects remain as residual object items.

Additional Information

Formerly known as NETIQKB48090

Feedback service temporarily unavailable. For content questions or problems, please contact Support.