In this article  :

• Issue description

• Prerequisites

• Possible causes

• Resolution

• Related topics and articles

• How to reach support

 Issue description           

When trying to upgrade ADAudit Plus specifically from build 8500, 8511, or 8512, the following error message may appear:

 "Please note that support for PostgreSQL 9.4.X has been discontinued as of ADAudit Plus build 8500. We strongly recommend that you migrate to the latest PostgreSQL version or MS SQL to avoid disruptions. For more details, contact support@adauditplus.com." 

This occurs because ADAudit Plus no longer supports PostgreSQL 9.4.x and earlier starting from build 8520.
If you are using PostgreSQL version 9.4.x or earlier, you must upgrade the database to PostgreSQL 17.5 before applying the ADAudit Plus service pack or upgrading to later builds.

 How to check your database type and PostgreSQL version   

 Check database type   

1. Log in to the ADAudit Plus web console, and click the Support tab.

2. On the Support Info tile, click More.

3. Under Basic Check, expand the Machine Details section.

4. The Database and Build Number will be displayed at the bottom.

 Check PostgreSQL version   

1. Open Command Prompt as an administrator in the <product_home>\pgsql\bin> directory.

2. Run the command:

 postgres.exe -V 

3. The installed PostgreSQL version will be displayed.  

 Important note   

If you are using PostgreSQL version 10.x, the steps below do not apply. We can directly proceed with the service pack upgrade.

 Prerequisites   

Storage  

Ensure at least twice the size of the current <product_home>\pgsql folder is available before upgrading.

Product build  

These steps apply only to builds 8500 and above.
If you are on a build earlier than 8500, upgrade to build 8500 first, and then follow the steps below.

Required files  

Download and extract the required component files prior to beginning the PostgreSQL upgrade.

Possible causes       

• PostgreSQL 9.4.x support has been discontinued from ADAudit Plus build 8500.

• Attempting to upgrade ADAudit Plus without upgrading PostgreSQL results in compatibility errors.

 Resolution   

 Backup and initial setup 

1. Stop the product.

2. From the <product_home>\lib folder, move the existing AdvTools.jar and AdventnetADAPCmdUtil.jar to a safe location.

3. Place the newly downloaded AdventnetADAPCmdUtil.jar file into the <product_home>\lib folder.

4. Place the newly downloaded patched AdvTools.jar into the <product_home>\lib folder.

5. From the <product_home>\bin folder, open Command Prompt as an administrator and start the database by running:

  startDB.bat 

6. Run a database backup using backupDB.bat from the <product_home>\bin folder, specifying your preferred backup location and password.
   

 backupDB.bat 

 Note: 

 The backup file will be saved by default in <product_home>\backUp folder as OfflineBackup_<timestamp>.ezip 

 An EventData back up folder will also be created under <product_home>\backUp\EventData\<timestamped-folder>. 

7. Once the backup is complete, stop the database by running:

 stopDB.bat 

 Configure database parameters   

8. Back up the <product_home>\conf\database_params.conf file by copying it to a safe location.

9. Open Command Prompt as an administrator from the <product_home>\bin folder, and set the product to standalone mode by running:

 cmdUtil.bat 

10. Sign in with the default product admin Username and Password.

11. Once you see the message "Welcome admin!", retrieve your PostgreSQL database password by running:

 servicepack getting-db-password postgres 

12. Note down the password in a text editor.

13. Stop the Command Utility (cmdUtil.bat) by pressing: Ctrl + C

14. Open the <product_home>\conf\database_params.conf file in a text editor and add:

 superuser_pass=<Noted password> 

15. Save and close the file.

 Replace the pgsql folder   

16. Rename the existing pgsql folder in <product_home> to pgsql_old.

17. Copy the newly downloaded pgsql folder and place it into the <product_home> folder.

18. Navigate to the <product_home>\bin folder, open Command Prompt as an administrator, and run the command:

 startADAP.bat 

19. After verifying that the product starts successfully, stop the service by pressing: Ctrl + C.

 Restore the database     

20. Restore the database using the previously saved backup by running:

 RestoreDB.bat <product_home>\backUp\OfflineBackup_<timestamp>.ezip -p Backup@123$. 

 Note:   When backupDB.bat is run, the backup zip file is secured with the default password: Backup@123$ for restoration. 

21. From the <product_home>\bin folder, open Command Prompt as an administrator and start the database by running:

 startDB.bat 

22. Restore event data using the previously saved backup by running:

 RestoreEventTables.bat <product_home>\backUp\EventData<timestamped-folder> 

23. Stop the database again by running:

 StopDB.bat 

Related topics and articles  

• How to upgrade ADAudit Plus to the latest build

 How to reach support         

If the issue persists, contact our support team here.