Environment
NetIQ AppManager Enterprise 8.0.1 Service Pack 2
NetIQ AppManager Enterprise 8.0.1 Service Pack 3
NetIQ AppManager Enterprise 8.2
NetIQ AppManager Enterprise 8.0.1 Service Pack 3
NetIQ AppManager Enterprise 8.2
Situation
The Installer for an AM 8.0.1 Service Pack may time out during installation.
Resolution
The solution to this issue is to use User Groups in SQL, in conjunction with the QDB being updated, and not allow a large list of individual user accounts to be added to a given QDB.
If you can move a majority of the accounts that are tied to this QDB into User Groups, you will give the installer fewer accounts to manage during the installation of a Service Pack. This should significantly decrease the amount of time it will take the installer to finish and thus improve your chances of the installer completing its task within the 10 minute window allotted by SQL.
If you can move a majority of the accounts that are tied to this QDB into User Groups, you will give the installer fewer accounts to manage during the installation of a Service Pack. This should significantly decrease the amount of time it will take the installer to finish and thus improve your chances of the installer completing its task within the 10 minute window allotted by SQL.
Cause
This issue occurs because the Service Pack installers must drop and re-add every user from the QDB that is being updated.
In most cases, this will not be an issue, and the installer will complete as expected. In in the case of customers who have a very large list of individual SQL and Windows users tied to the SQL Instance hosting the QDB that is being updated with the Service Pack, the above process may not complete within the 10 minute window that SQL gives us to complete a single query. In such a case, the process that is removing and re-adding these accounts to the QDB will time out, causing the entire Service Pack installation to fail.
In most cases, this will not be an issue, and the installer will complete as expected. In in the case of customers who have a very large list of individual SQL and Windows users tied to the SQL Instance hosting the QDB that is being updated with the Service Pack, the above process may not complete within the 10 minute window that SQL gives us to complete a single query. In such a case, the process that is removing and re-adding these accounts to the QDB will time out, causing the entire Service Pack installation to fail.