NetIQ AppManager 7.0.x
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.
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:
- Run the following query:
Select * from object where Rootmachineobjid = <NumberDisplayedForTheRootObjectInTheError>
- 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>
- If nothing is returned, run the following query to remove the residual items:
Delete from object where RootMachineObjid =<NumberDisplayedForTheRootObjectInTheError>