10.15 Upgrade to OpenClinica 3.1.x on Windows

These instructions are for upgrading from OpenClinica 3.0.x to version 3.1 , 3.1.x maintenance release or to a 3.2 on Windows systems running the essential software dependencies: Java 6, Tomact 6, and PostgreSQL 8.4. When you see v.x or v.x.x or similar in the instructions, use the version number you are upgrading to, e.g. 3.1 or 3.1.2.

The instructions apply only if you followed the upgrade instructions to get to 3.0.x; if you did not, you might need to do other things in order to upgrade your system.

If you are running an earlier version of OpenClinica and/or its related software dependencies, make sure you upgrade these to the required versions before upgrading beyond OpenClinica 3.0.x. Please note that these instructions do not cover upgrading related software dependencies for 3.1.x. To upgrade these components, you'll need to follow the instructions provided by those technologies. Make sure you back up everything so your existing files are not lost.

If you are upgrading from OpenClnica 2.5.x, you need to first upgrade to 3.0.x, and you will need to upgrade the software dependencies so they meets the requirements for OpenClinica 3.0.x. Perform a full backup of your 2.5.x instance, perform a fresh install of 3.0.x, and then restore your 2.5.x data. For information about backing up your 2.5.x instance, see the 3.0.x upgrade documentation that is included with the downloaded files for 3.0.x.

You may also need to configure OpenClinica for internationalization should you wish to utilize OpenClinica in different languages. Also, if you need to use some UTF-8 characters in your application, you may need to modify your default connecter configuration. For more information regarding configuring OpenClinica for internationalization and using UTF-8 characters, please refer to https://docs.openclinica.com/3.1/technical-documents/openclinica-and-internationalization

Verify the upgrade.

Make manual updates to the database. The instructions are the same as for upgrading OpenClinica on Linux systems, except the README file on Windows systems is located at:c:\oc\install\OpenClinica-v.x.y\config\databases\PostgreSQL

Now, you'll need to make database updates for your database: either PostgreSQL or Oracle. The instructions apply to upgrading OpenClinica on Linux and Windows systems:

PostgreSQL

Open the file README_Instructions_for_Duplicate_Row_Fix.txt, located atc:\oc\install\OpenClinica-v.x.x\config\databases\PostgreSQL

Follow the instructions in the README file.

Oracle

At the location c:\oc\install\OpenClinica-v.x.x\config\databases\Oracle\upgrade, open the file README_Instructions_for_Duplicate_Row_Fix.txt, and follow the instructions in the README file.

As the sysdba user, run the Grant_View.sql script located in c:\oc\install\OpenClinica-v.x.x\config\databases\Oracle\upgrade

The script prompts you for a user name: provide the user name for the database user OpenClinica is set up to use, as specified in the datainfo.properties file that you configured during installation. Run this script before starting Tomcat. There is no risk in running this script on a database that has already been upgraded to 3.1.x.

Create the following directory, if it does not already exist:c:\oc\install

Download the OpenClinica software, OpenClinica-v.x.x.zip, from the OpenClinica website: https://community.openclinica.com/project/openclinica. To download the software, use your free community account; you will be required to log in to the account to download the OpenClinica software. If you do not have an account, you may get one here. After downloading the OpenClinica software, extract the files to:c:\oc\install.