Live Forms Latest - This documentation is for Live Forms v9.2. v9.2 is a Cloud Only Release. Not for you? Earlier documentation is available too.
COVID-19 Response Info: At frevvo, our top priorities have always been employees and customers. We have taken several steps to promote the well-being of our people, to minimize services disruptions, and to help where we can. Visit our website for updates.
v9 License Key Required
A v9 license key is required for this version of frevvo if you are upgrading from a prior version. Request a v9 license by emailing support@frevvo.com before you begin the upgrade.
Your Live Forms Version | Recommended Upgrade Path to v9.0.x |
---|---|
7.2.x | Upgrade directly to v9.0.x |
7.3.x | Upgrade directly to v9.0.x |
7.4.x | Upgrade directly to v9.0.x |
v9.0.0-10 | Upgrade to v9.0.11 (Tomcat Upgrade) |
v9.0.0-11 | Upgrade to v9.0.12 (Tomcat Upgrade) coming soon |
Note: Upgrades from frevvo 6.3.9 - 6.3.12 through v7.4.x are supported but these versions are not available for general release.
frevvo does not support the use of HSQLDB for use beyond demo/trials of the Live Forms software. If by mistake you continued to use the demo/trial HSQLDB database for production use, you will need to first migrate your data to one of frevvo supported production databases BEFORE you can upgrade to later versions of Live Forms.
Please read the following upgrade steps prior to starting the migration. frevvo recommends that you test the upgrade process on your test server before performing it on your production server. Contact your frevvo Account Manager for information if you do not have a test environment.
Please read and understand the Migration Considerations which may require your action before beginning.
Stop frevvo with one of the methods listed below:
Execute <frevvo-home>\stop-frevvo.[bat,sh] for versions previous to v9.x.
If you are upgrading from v7.x, you will also need to stop the Insight Server by closing the window or if you are using the tomcat bundle by typing these commands in the <frevvo-home>\solr-x.x.x directory of your existing installation.
bin\solr.cmd stop -all
Stop Live Forms and the Insight Server through the Computer Management Services console if they are running as Window's services.
Backup the current frevvo server's installation directory so that you have a copy of all custom configuration parameters.
SQL Database Option
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 frevvo v9.0.x. 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:
Using DDL ( Data Definition Language) - Run the commands listed below:
ALTER DATABASE <your frevvo database schema> - replace <your frevvo database schema> with the name of your frevvo database schema SET READ_COMMITTED_SNAPSHOT ON
Using SQL Server Management Studio:
Database and Email configuration is done in the <frevvo-home>\tomcat\conf\server.xml file. The database resource name was changed to jdbc/sharedfrevvoDS in v7.0. When you configure your database, make the changes to the v9.0.x server.xml. Do not copy configured sections from a frevvo.xml of a previous release into the v9.0.x server.xml file.
Save the changes to the server.xml file.
This section applies to upgrades from versions v7.4.x+.
See Installation Tasks for commonly used properties. Read the Detailed Release Notes to be sure that all properties you are using are valid in the upgraded version.
This section applies only to upgrades from versions prior to 7.4.x.
The Refresh Searchable Fields process will run automatically as part of the upgrade. If it does not, you can run it manually once the upgrade is complete. The process should be run after hours when your users are not using your forms/flows.
Follow the steps for your Operating system to start the Insight server BEFORE starting frevvo.
You will see this message:
If you close the Insight server (Solr) startup window, the server will stop running. Leave the window open or see these instructions to remove existing services and set up Live Forms and the Insight Server to run as Windows services:
Browse http://<your server:port>/ solr to verify the Insight server is running. The <server:port> default values are localhost:8983. Change localhost to the server name and 8983 to the port the Insight server is running on if they are different than the defaults. Do not include the angle brackets <>. You will see the Insight server (Solr) dashboard with the current status.
Start the frevvo v9.0.x server by running the start-frevvo.bat or start-frevvo.sh files (depends on your Operating system) in the <frevvo-home>\frevvo directory. Then follow these instructions to login and enter your upgrade license key.
If you are running Live Forms and the Insight Server (Solr) as Windows services, you must delete the existing services then reinstall them for the services to run properly.
Type this command: If your service name has spaces in it, use quotes around the service name.
sc delete <ServiceName>
The message "DeleteService SUCCESS' will display when successful.
Remove the Live Forms service by running the <frevvo-home>\Remove-Service batch file.
Perform these steps to reinstall the Insight Server and Live Form services.
Ensure you upgrade to the supported version of the connectors for your upgraded version of frevvo. Version information can be found at the links below.
All database initialization and/or required upgrade will be automatically done by frevvo.war as part of the frevvo v9.0.x startup.
Verify that any frevvo Connectors are up and running.
Login as the superuser admin.
It is recommended that you do not change or delete the frevvo.users.schemaName property in the frevvo-config.properties file after the first startup of v9.0.x. If the property is changed or deleted post migration you may see this error:
Follow these steps to rectify the situation:
Change the property back to what it was during migration and restart.
If that does not fix the problem, delete all rows from the DATABASECHANGELOG database table and then restart. Use the command: delete from DATABASECHANGELOG.
If you start frevvo before the Insight server, you will see this message when you browse the frevvo login URL. Follow these steps to start the servers in the correct order:
Navigate to your <frevvo-home> directory.
Run the stop-frevvo.bat or stop-frevvo.sh file depending on your Operating system to stop frevvo.
Open a command prompt. Navigate to <frevvo-home>\solr-6.6.2
Start the Insight server. Refer toStart the Insight Server above for the instructions.
Browse http://<your server:port>/solr to verify the Insight server is running. The <server:port> default values are localhost:8983. Change localhost to your server name and 8983 to the port the Insight server is running on if they are different from the defaults.Do not include the angle brackets <>.
Start frevvo.
If you're applying a minor patch update, for example, applying patch 9.0.x to your installed v9.0.0 Live Forms server, you can follow these simple steps instead of the more lengthy upgrade steps.
The latest major frevvo version and the compatible frevvo connectors are available from the frevvo Software Downloads Directory.
If you are applying a patch release that includes an Apache Tomcat upgrade to your installed v9.0 frevvo server, follow these modified upgrade instructions. Refer to the sections above for detailed steps.
Stop frevvo.
Backup the current frevvo server's installation directory so that you have a copy of all custom configuration parameters.