This article provides an overview of patching a PROJECT in a box client-server installation from Version 2.2 to Version 2.3. Please note that patches must be applied incrementally e.g. if your installation is at Version 2.1 you must patch to 2.2 then 2.3. All downloads are available from your client page.
PROJECT in a box (PIAB) is a client-server application consisting of:
Program Files\PROJECT in a box Professional. Note: Depending on your backup software, the search index catalogue, contained in the idx folder may not be copyable until you have stopped the Microsoft Indexing Service. However, it is not necessary to backup this folder as it is rebuilt by the Indexing Service itself.
Rollback consists of restoring the original installation folder and restoring the 'piab' database from backup file.
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
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.
When you run the patch it will place a timestamped 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.
If your SQL Server is on a remote PC then it is likely that you will need to apply the SQL scripts separately. Navigate to the folder:
Program Files\PROJECT in a box Professional\patch-2.3.1.001
The SQL upgrade scripts are as follows (in order of how they should be applied):
piab-2.3.4-reset-roles.sql(optional: sets up a standard set of project roles)
You can run these with the Microsoft SQL management tools (e.g. Enterprise Manager) or edit and run the command scripts provided for SQL Server 2005 or 2000 respectively.
The PIAB client is a .NET Windows Application, consisting of a set of folders and files normally located on the client PC in folder:
Program Files\PROJECT in a box Professional
The clients can be upgraded individually using the following client upgrade patch. These do not need to be applied incrementally.
An alternative is to prepare and deploy the client using a web page. The PIAB client is a files-only, XCOPY type installation and can be deployed as a self extracting download. For more details please see: KB2310032 Client Deployment
Program Files\PROJECT in a box Professional\piabws
Note: These tests must be carried out on a client PC that has the necessary client software installed to work with the project files (e.g. Microsoft Office, Microsoft Project). Basic connectivity tests can be carried out on the server.
|1.1||Login||Run the client and login as a PIAB Administrator||Login successful|
|1.2||Version Check||Do 'Help/About' and check the client and server versions are correct||Both show the correct version|
|1.3||Select Project||Do 'File/Select Project' and choose a project||The project opens with a process overview diagram|
|2.1||File Explorer||Click a process box(s) to open the File Explorer||File explore opens|
|2.2||Navigate Explorer||Use the document tree to navigate to a document and file||File details appear in the RH pane|
|2.3||View File||With a file selected, click the 'View File' button||File opens on the client PC|
|2.4||View File Version||If present, select an older version from the file version list. Click the 'View Version' button||Older version of the file opens on the client PC|
|2.5||Check Out File||If permissions allow, click on the 'Check Out File' button||File opens on the client PC; The file is marked in the client as Checked Out.|
|2.6||Check In File||If permissions allow, click the 'Check In' button and follow the instructions to check in the file||The file checks in to the server; The file is shown as 'not checked out'; The file version history table is updated;|
|2.7||Copy to Email||Click the 'Email this File' button||A new email opens in Outlook with the file attached|
|3.1||Keyword Search||Click 'Search'; Type 'mandate' into the 'keyword' field and click the 'Search' button.||The search list is populated with a document tree containing documents and files that match the search|
|4.1||Project Report||Click 'reports/project report' and click OK||A report appears in a browser or in Word containing the project report. Note that the success and contents of this operation depend on correct set-up of the project, report options and client applications so you may see warnings before the report appears.|
|5.1||Connectivity|| In a web browser, navigate to the PIAB Enterprise hub URL e.g. ||The PROJECT in a box Enterprise Hub application opens either with a login page, or already logged in depending on your system settings.|