On This Page:

Insight Server

The Insight server is a document-oriented database (Apache Lucene Solr) that is used for  Reports. The Insight Server software is included in the tomcat bundle. The Insight Server works in conjunction with and a web app (insight.war) to retrieve the information for the  reports.  Here is how it works:

Always use a fresh Insight instance for . Multiple databases should never point to the same Insight instance.

Insight Server Files

When you unzip the tomcat bundle, you will see a new <frevvo-home>\solr-5.4.1 directory that contains the Insight Server software.


Insight Server Location Configuration parameter 

The default server and port are localhost:8983. The Insight Server URL configuration parameter is located in the <frevvo-home>\tomcat\conf\Catalina\localhost\context.xml.default file. Configuring the location of the Insight Server in this file makes it available to the insight and frevvo web application warfiles.

<Context swallowOutput="true" unloadDelay="40000" useHttpOnly="true">
        <Manager className="org.apache.catalina.session.PersistentManager" saveOnRestart="false">
                <Store className="org.apache.catalina.session.FileStore"/>
        <Parameter name="insight.server.url" value="http://localhost:8983/solr" override="false"/>

Running Live Forms and the Insight Server as Windows Services

The Insight Server must be started BEFORE from a command prompt, or you will see a Configuration Checklist warning and you will not be able to proceed. If you close the Insight Server startup window, on a Windows system, the server will stop running. You can leave the window open or set up Live Forms and the Insight Server to run as Windows services.

If you are using the frevvo tomcat bundle, follow the steps below to run the Insight Server (Solr) as a Windows service. Otherwise, general instructions can be found on this website.

  1. Install the Insight Server as a Windows service
  2. Install Live Forms as a Windows service
  3. Add a Dependency to the Live Forms service

Install the Insight Server as a Windows Service

We will use a service helper such as NSSM (Non-sucking Service Manager). NSSM requires Java 7 or higher. You can download it from here.

  1. Extract the NSSM zipfile to a Program Files\nssm directory
  2. Open a command prompt. Run as an administrator
  3. Navigate to the directory under c:\Program Files\nssm\ that contains the nssm.exe file for Windows64 or Windows32

    For example, the path in Windows 7 would be C:\Program Files\nssm\nssm-2.24\win64
  4. Type: nssm install <service name> - Replace <service name> with the name you want to use for the Insight Server service.

    Ex: nssm install insightserver
  5. Browse to the location of the solr.cmd script by clicking on the three dots to the right of the Application Path field.

  6. Click on the solr.cmd file, then click Open.  The Application Path field will populate.

  7. Notice the Startup directory field also populates. REMOVE bin from the Startup directory field. The Startup directory should be: c:\<frevvo-home>\solr-5.4.1\

  8. Enter these Arguments:

    start -f -p 8983

  9. Optionally, click the Details tab to specify a Display Name and Description - Ex: Insight Server, Script to Stop/Start Solr5. Notice the Startup type is set to Automatic.

  10. Click the Install service button. A success message displays:

  11. Start the Insight Server service from the Computer Management Services pane.

  12. Browse http://<your server:port>/solr to verify the Insight server is running. The <server:port> default values are localhost:8983. Change <your server>  to the server name and <your port> 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 dashboard with the current status:

Install Live Forms as a Windows service

There are batch files in the <frevvo-home> directory to Install/Configure as a Windows service. Refer to Installing Live Forms as a Windows Service for more details and troubleshooting tips.

  1. Navigate to <frevvo-home>. Install as a service by running the Install-Service batch file as an administrator.
  2. Configure the service if you are using Windows 64 bit by clicking on the Configure Service batch file. You must run the Configure-Service batch file as an administrator.

    1. Change the mode on the Startup and Shutdown tabs from jvm to java. Save the changes.

  3. will appear under Windows services with the name frevvoforms with a Startup type of Manual. Change this to Automatic and start the service.

Add a Dependency to the Live Forms service

Once the two services are installed and started, add a dependency to the Insight server for the frevvoforms service. With the dependency in place, the frevvoforms service cannot start unless the Insight service is running.

  1. From the administrative command prompt, type the following command with the name you gave to the Insight Server service:

    sc config frevvoforms depend= <name of the Insight Server service>

  2. Check the Dependencies tab of your Insight Server service in the Windows Services list, It should list frevvoforms as a system component that depends on the Insight service

  3. If you manually stop the Insight Server service, it will ask you if you want to stop Live Forms.

Troubleshooting Tips

Indexing related messages are captured in the <frevvo-home>\tomcat\logs\frevvo.YYYY-MM-DD file. For example, if you run the Insight Data Batch process manually or if it runs automatically during an upgrade, messages from the process are found in the frevvo.log.