Views:

Hotfix files usually comprise of different file types contained in a .zip file for you to download. Below we explain how to install the hotfix components for the APS product range, not all steps are required for every hotfix, take the steps applicable for the particular hotfix you are installing. 

Step 1 - Component Installation

A large number of these hotfix components are interdependent. ALL components must be applied on all machines where APS software is installed. All users need to be logged out of all APS applications prior to installing the hotfix files either on desktop or terminal server. 

Instructions to install APS Hotfix files

  1. Download the hotfix file 
  2. Extract/unzip the files to your APS Downloads folder or suitable software folder on your network.
  3. Ensure that all Advance applications are closed.
  4. Copy all the component files (.dll and exe) to every users Adv2000 folder or all terminal servers where APS is installed (i.e. everybody’s workstation), replace the existing files.
 
 Important 
- Some operating systems will lock DLL files by default, copying hotfix files containing DLL files may result in problems during and after installation.
- Prior to copying any files to Adv2000 please ensure that each file is unblocked first. This can be done by File right click > properties 
 

Example:

 
Note - NZ Tax users  - aps_t.mde files Depending on how your APS environment is set up, this file must be copied to either your ADV2000 folder or in your network drive.
 

Step 2 - Run the version control

Some hotfix downloads may contain a version control or .mdb type file. Below are the steps to follow if a hotfix file contains a version control. If no .mdb file exists in the download then move onto step 3 
 

  1. Copy the version control file into the Adv2000 folder on one workstation 
  2. Take a backup of the aps_dsql database
  3. Locate the version control file you copied into the Adv2000
  4. Double click to run the file
  5. Follow onscreen instructions to upgrade the database.
    • This file only needs to be run once from one workstation.



Step 3- SQL Scripts

Some hotfix downloads may contain sql scripts. Below are the steps to follow if a hotfix file contains a SQL script. If no .sql exists then your install of hotfixes is complete. 

  1. Ensure all users are out of APS.
  2. Go to SQL Server Management Studio
  3. Take a back-up of aps_dsql database
  4. Copy the .sql file to a folder on the SQL Server.
  5. Double click on the .sql file – it will open directly on Microsoft SQL Server Management Studio
  6. It will prompt to Connect to Server, once connected
  7. Ensure that the aps_dsql is selected as the database
  8. Execute the script using the execute button
  9. Exit out of SQL Server Management studio. 



 
Related Products: APS Support Services