9 1:Upgrade Project.net-Windows

From Pnet-Community

Jump to: navigation, search


[edit] Upgrading Project.net on a Windows System

[edit] Overview

This document guides a user through the process of upgrading a production installation of Project.net on a Windows platform from version 9.0.* or 9.1.*. This procedure will update both the application and its related database.

The upgrade consists of the following steps:

  1. Update the Oracle database
    1. Turn off the application and backup the database.
    2. Apply any database table updates.
  2. If you are upgrading from a version prior to 9.1.0 you will need to install Apache ActiveMQ.
  3. Update the Project.net application
    1. Deploy the new version of the application on the application server.
    2. Restart the application server.
  4. Set any site-specific configuration values.

[edit] Unpack the Project.net installation package

The upgrade package includes everything you need in zip archive file except Apache ActiveMQ. The first step to upgrading Project.net is to unpack the software onto an accessible file location.

  1. If it does not exist, create a temporary directory to unpack the upgrade package, suggested C:\pnet or C:\tmp\pnet.
  2. Right-click the the installation package zip file and select [Extract all...] from the pop-up menu and extract the files into the directory chosen above. Once unpacked, you will have C:\pnet\v9.1.1-OS, for example. These instructions will refer to this location as INSTALL_PACKAGE throughout these steps.

[edit] Upgrade the Project.net Oracle database

Before installing any upgrade to the Project.net system it is important to back-up the Project.net database. This requires that you stop the application to prevent changes to the database during backup.

[edit] Prerequisites

  • Assumes the database on an Oracle database server.
  • You will need to know the database server’s hostname and the system password for the Project.net database instance.
  • A working copy of sqlplus. Normally, this is installed with the Oracle database, but if not, the Oracle instant client is sufficient.

[edit] Instructions

  1. Stop the Apache Tomcat server (see Starting and Stopping Project.net).
    • Confirm Project.net is no longer running by attempting to open the Project.net login page; the browser will give a “Page not found” error.
  2. On your database server, follow the instructions to perform an off-line backup. You do not need to back up the document vault, unless you want to.
  3. To update the database execute the following commands from a command window:
    1. cd $NSTALL_PACKAGE/database/create-scripts (The following step must be run from this directory.)
    2. version_update.bat <pnet username>/<pnet password>@<database SID> <update version number> <pnet_user username> <pnet_user password> <database SID>
      • A typical command would look like this:
        version_update.bat pnet/<pnet password>@XE 9.2.0 pnet_user <pnet_user password> XE
      • For Oracle XE, the database SID is XE.

[edit] Install Apache ActiveMQ (if upgrading from Project.net 9.0.*)

Complete this section only if you are upgrading from Project.net 9.0O; 9.1.0 and above currently have Apache ActiveMQ installed.

On the application server the JAVA_HOME environment variable must be set to the directory where the Java runtime (JDK or JRE) is installed.

  1. On the [Start] menu or the desktop, right-click My Computer, then [Properties].
  2. Click [Advanced] tab.
  3. Choose [Environment Variables] button.
  4. Look in System Variables for the JAVA_HOME environment variable. If it is not there, use the [New] button to create it. Most likely, Java is installed in C:\Program Files\Java\<version name>.
  5. Click [OK] to close the dialog
  6. Download the latest stable Windows Distribution of Activemq from http://activemq.apache.org/download.html
  7. Unpack the zipped package into your Program Files, for example C:\Program Files\apache-activemq-5.3.0
  8. To install Activemq as a Windows service please follow these instructions
    1. Run the InstallService.bat script located in <apache_activemq_install_dir>\bin\win32
    2. Open the Windows Services panel through Control Panel -> Administrative Tools or using Run: services.msc.
    3. Check for a Service named ActiveMQ, right-click on it and start it
    4. Check the log file at <apache_activemq_install_dir>\data\wrapper.log
      • You should have the message "INFO TransportConnector - Connector vm://localhost Started"

For more information please visit the ActiveMQ website at http://activemq.apache.org

[edit] Update the Project.net application

[edit] Prerequisites

  • You will need to locate the directory where Apache Tomcat is installed, referred to as CATALINA_HOME. Look for a directory starting with "apache" or "tomcat" in C:\Program Files.
  • You will need to know whether Project.net is installed as the default (root) or non-root application on Tomcat.

[edit] Instructions

On the application server:

  1. Navigate to the folder CATALINA_HOME/webapps and delete the files ROOT folder and ROOT.war file (or the appropriately-named folder and file).
  2. Copy pnet.war file from INSTALL_PACKAGE/app/ to the CATALINA_HOME/webapps/ folder, naming it either ROOT.war or the application's name.
  3. Start the Apache Tomcat server (see Starting and Stopping Project.net).

[edit] Apply site-specific configuration changes

When installing a new version of Project.net some of the configuration settings may reset to their default values and you may need to re-configure them; these values are set through the Application Administration interface. Follow Configure Project.net System Settings to make sure the values are correct for your installation.

Once verified, logout as the administrator and your new version of Project.net is ready to go.

[edit] More Help

Personal tools