Environment
NetIQ AppManager 7.0.x
Situation
AM7 installation fails on install of component Repository with a string of SQL error messages such as..
Error!
AppManager repository installation failed
SQLSTATE=01000, native error=15070,
msg='[Microsoft][ODBC SQL Server Driver][SQL Server]Object 'task_util' was successfully marked for recompilation
Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server. The job was not saved.
Error!
AppManager repository installation failed
SQLSTATE=01000, native error=15070,
msg='[Microsoft][ODBC SQL Server Driver][SQL Server]Object 'task_util' was successfully marked for recompilation
Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server. The job was not saved.
Resolution
In SQL Enterprise Manager/SQL Management Studio, delete the old NetIQ SQL jobs and retry the AppManager 7 Repository installation.
Cause
A previous installation of AppManager on this server was removed, and no QDB exists. However, some SQL jobs for NetIQ AppManager remain in SQL Enterprise Manager from the previous installation.
Additional Information
Formerly known as NETIQKB70149
If the server has been renamed, you may get the following error when you try to delete the SQL jobs:
Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server. The job was not saved.
Ref: http://support.microsoft.com/kb/281642
You can see the offending SQL job entries in the msdb database, sysjobs table where the field 'originating_server' has the old hostname value. To correct these, you could run SQL to update the originating_server values or remove the records for the relevant jobs from the table.