OpenInsight Development Suite 10.0.7 Update

This is an update of Revelation Software’s flagship product OpenInsight Development Suite v10.0.7. OpenInsight 10.0.7 includes:

    • OpenInsight for Web (O4W)
    • OpenInsight Management Console
    • SQL Connector
    • MultiValue Connector
    • Cloud Based Filing System
    • OpenInsight Git
    • NetOI / RevDotNet
    • OpenInsight Converter Utility
    • OECGI4
    • Arev64
    • Character to OpenInsight (CTO),
    • OpenInsight Authentication Module
    • OpenInsight Single Sign-On
    • OpenInsight Banded Report Writer
    • OpenInsight Presentation Server

Major Changes in the OpenInsight 10.0.7 Release

OpenInsight now provides an option to change the precision of mathematical operations. This can be set by calling the setEPMode stored procedure, passing in 1 to enable and 0 to disable the functionality. By default, the extended precision math will maintain 32 digits of precision, but this can be modified by calling the setEPModePrecision stored procedure, passing in the number of digits of precision desired. Both the enabling of extended precision, and the default number of digits, can also be defined in the application properties. The following operators/functions are affected: +, +=, -, -=, *, /, ==, =, !=, <>, >, <, >=,<=, mod(), int(), abs(), atan(), cos(), exp(), ln(), pwr(), sin(), sqrt(), tan()

OpenInsight's RLIST functionality and performance have also been improved starting with the 10.0.7 release. A new version of RLIST (RLISTX), which optionally replaces and extends RLIST, is available to enable these enhancements. RLISTX merges the features of RLIST, SELECT_INTO, OLIST/RUN_REPORT, and RTI_XBAND. One obvious change is the ability to pass in multiple select statements to RLIST in a single call, @FM delimited. Using the Record Editor, or the Configuration Record option from the OI Console, you must create a CFG_RTI_RLIST record in SYSENV, with RLISTX in field 1. If this record doesn’t exist, or has anything other than RLISTX in field 1, then normal RLIST behavior ("RLIST 9") and functionality will remain. (Note that the CFG_RTI_RLIST information is cached by your system; after changing this value, you should exit and re-enter OpenInsight).

The MultiValue BFS (MVBFS) connections for QM, D3 and U2 have been enhanced to submit multiple select lists to the "back end" host for bulk processing whenever possible. This enhancement can result in significant performance improvements when using an MVBFS connection. Note that these changes work in conjunction with the RLISTX changes discussed above; you must enable RLISTX and install a "plugin" stored procedure on the host system to access these changes. There is now a button on the MVBFS connection designer which will install this plugin (a program named RTI_MVBFS_SERVER_PLUGIN_U2, RTI_MVBFS_SERVER_PLUGIN_D3, or RTI_MVBFS_SERVER_PLUGIN_QM).

Starting with OpenInsight 10.0.4, "child" processes launched from OpenInsight can be configured so that they do not consume
additional license seats. In particular, CTO, AREV64, BRW, and O4W calls (using the engine server's built-in web server)
made from a copy of OpenInsight will not count against the licensed count of users.

For example, a single user copy of OpenInsight can now run the IDE, a CTO session, and generate a BRW report at the same time.

Note that this enhancement requires both OpenInsight 10.0.4 (or above), and the Universal Driver 5.2 (or above).
OpenInsight 10.0.7 will work with the Universal Driver 5.1, but it will not exhibit these license enhancements until it is
"paired" with a UD 5.2.

To take advantage of this license enhancement for O4W and engine server tasks, users/developers must update their eserver.cfg file (either directly or through the Settings dialogs). In particular, any passwords that are currently explicitly embedded in the eserver.cfg can be replaced with an asterisk ("*"); this indicates that the specific connection should use the enhanced licensing. This also has the additional advantage of no longer requiring manual updates to the eserver.cfg file when passwords are changed for the applications or users defined in the connection string. (As an additional enhancement, the username can also be replaced with "*" if you wish to use the 'default user' created for an application).

For example, if your eserver.cfg previously contained the following lines:


They can now be replaced with the following lines:



NOTE: This version of OpenInsight 10 (10.0.7) targets Microsoft’s .Net framework version 4.7.  Certain versions of Windows (for example, those running Windows 10 version 1507 or earlier) may have difficulty installing the .Net 4.7 framework.  Before you install the next release of OpenInsight 10, please ensure that all required systems have been upgraded to .Net 4.7.  For more information, see this:



Works Members can download OpenInsight 10.0.7 from the Works Downloads section of our web site.