4_3:upgrade_guide:patching_server

Patching the Server

The PIAB server consists of an ASP.NET web and web services application and a SQL server database called 'piab'. The default install folder is

Program Files\PROJECT in a box Professional\

Step 1 - Run the Server Upgrade Patch

Download the following patch installer and run it on the server. This updates the web and web services application files. NB Make sure to run the patch installer, not the new setup installer, or you may lose data. The new setup installer will prompt you if it finds an existing installation but as an administrator you can still proceed.

piabpe-patch-server-4.3.1.xxx.exe

When you run the patch it will place a timestamped Patch Log file in the install folder as below. This file contains useful information about the progress of the patch and should be retained for reference and troubleshooting, e.g.

piabpatchlog-4.3.1.001-build-1-[2012-11-21_10-30-00].txt

Step 2 - Run the SQL Upgrade Scripts

If your SQL Server is on a remote PC then it is possible that you will need to apply the SQL scripts separately. For instance, if the patch installer isn't running with permissions to modify the database. Please review the Patch Log to check that whether the SQL upgrade scripts have run successfully.

In this case, navigate to the folder:

Program Files\PROJECT in a box Professional\patch-4.3.1.xxx

The SQL upgrade scripts are as follows (in order of how they should be applied):

  • piab-4.3-1-table.sql
  • piab-4.3-2-view.sql
  • piab-4.3-5-sproc.sql
  • piab-4.3-6-data.sql

You can run these with the Microsoft SQL management tools (e.g. Enterprise Manager) or edit and run the command scripts provided for your version of SQL Server e.g.

sql-update-2008.cmd
4_3/upgrade_guide/patching_server.txt · Last modified: 2017/06/22 13:19 (external edit)