5_2:upgrade_guide:patching_server

Patching the Server

Locate the PIAB install folder. The default location 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-5.2.0.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-5.2.1.001-build-1-[2019-01-01_10-30-00].txt

Custom Content: Update or Reset?

The application includes 'Custom Content' of various kinds, much of which you are able to edit or extend to modify. When you patch, you have the choice to update or reset this content. 'Reset' replaces the content with a complete set of current custom content. 'Update' attempts to patch your existing data - but of course it can only do so much. Custom Content includes

  • Reporting templates in 'etc/clientsupportfiles/xsl'
  • Project Methods in 'template2.0'
  • Browser App welcome messages and other static text, html and images also in 'piabws/customcontent'

The patch installer keeps a copy of your old content, but we recommend you make a manual copy too, in case you want to reverse any of the changes.

Note that the Browser App CSS styles have changed considerably in this version, so by default the customercontent/Styles.css file will be replaced with the current version.

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-5.2.1.xxx

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

  • piab-5.2-1-table.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
5_2/upgrade_guide/patching_server.txt · Last modified: 2019/03/02 17:14 (external edit)