Skip to main content

Sometimes a customer has deployed the Alliance HF installer and perhaps forgot to update all the databases for each profile but you are not sure.  If this is the case and you have access to the SQL Server, you can execute the following script which will tell you what Alliance version and HF is deployed.

-- Find DB Alliance and HF versions

SELECT ap_descr, 
       ap_glb_param_val
FROM ap_glb_param
WHERE ap_descr = 'Version of SA Web application'
      OR ap_descr = 'Version of HotFix';

 

This will return results similar to below:

ap_descr                                           ap_glb_param_val
Version of SA Web application    15.03.0
Version of HotFix                           15.03.0.3

In this case, the Alliance version is 15.3 with HF3 deployed on top of it.

 

If you have database that was neglected to be upgraded by the Alliance HF installer, you can run the installer again with a text file named dbupgrade.txt located in the same folder as the installer.  This will only execute the database upgrade process allowing you to complete the upgrade on the missed databases.  Also useful if you restore an older database to an already upgraded environment that needs the SQL scripts executed.

 

 

Thanks for the information. Keep ‘em coming 😃