Live Forms v7.1 Documentation

Software Download Directory

Versions Compared

Old Version 28

changes.mady.by.user MaryAnn Rapuano

Saved on

compared with

New Version Current

changes.mady.by.user MaryAnn Rapuano

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Please read and understand the Migration Considerations which may require your action before beginning.

  2. Backup the forms database from your current
    Frevvoproduct
    installation.
  3. Backup the current
    Frevvoproduct
     server's installation directory so that you have a copy of all custom configuration parameters.

  4. Stop the 

    Frevvoproduct
    server using stop-frevvo.[bat,sh]. Stop
    Frevvoproduct
     and the Insight Server through the Computer Management Services console if they are running as Window's services.

    Warning

    If you are using SQL Server as your Live Forms database, it is highly recommended that you turn on the READ COMMITTED SNAPSHOT setting in the database BEFORE performing the upgrade to

    Frevvoproduct
    v7.1.

    You do not have to do this if you are using MySQL or Oracle databases because this option is turned on by default.

    There are two ways to turn on the option:

    1. Using DDL ( Data Definition Language) - Run the commands listed below

      Code Block
      ALTER DATABASE <your frevvo database schema> - replace <your frevvo database schema> with the name of your frevvo database schema 
SET READ_COMMITTED_SNAPSHOT ON
    2. Using SQL Server Management Studio:
      1. Turn on the “Is Read Committed Snapshot On” Option under database properties.
  5. Install a fresh v7.1.x
    Frevvoproduct
     server:
    1. Download the latest v7.1.x software.
    2. Request a v7 license if you are upgrading from a
      Frevvoproduct
      version prior to v7.0.x.
    3. The download is a zip file. Extract the contents to any folder of your choice. This folder will be referred to as <frevvo-home> (note that the zip already contains a top level frevvo folder).
    4. If you increased Memory Settings in your previous installation, make those changes to the appropriate files in the v7.4.x installation. Refer to Hardware and Memory Requirements for the details

    5. Navigate to <frevvo-home>\tomcat\conf\server.xml in the v7.1.x directory structure.

      Warning

      Database configuration has been removed from the <frevvo-home>\tomcat\conf\Catalina\localhost\frevvo.xml file. It is now done in the <frevvo-home>\tomcat\conf\server.xml file. Also, notice the database resource name has been changed to jdbc/sharedfrevvoDS. When you configure your database, make the changes to the v7.1.x server.xml. Do not copy configured sections from a frevvo.xml of a previous release into the v7.1.x server.xml file.

    6.  Point the v7.1.x frevvo database to your current frevvo database . Remember to add the sendStringParametersAsUnicode property with a value of false to your database connection URL if it is not already there.

      Note

      All database initialization and/or upgrade will be automatically done by frevvo.war as part of the

      Frevvoproduct
      v7.1.x startup.

  6. Copy the frevvo.users.schemaName property from <frevvo-home>\tomcat\conf\catalina\localhost\frevvo.xml to the v7 <frevvo-home>\tomcat\conf\catalina\localhost\frevvo.xml.

    Info

    Compare the frevvo.users.schemaName property in the frevvo.xml file from the version of

    Frevvoproduct
    you are upgrading from to the frevvo.xml file in v7.1 installation directory. If they are the same, do not do the copy in Step 6 - proceed to Step 7.


  7.  Configure the new installation

...