OpenInsight Authorisation Process

reauthI have recently been asked several times about the OpenInsight Reauthorisation process, how easy it is to use the process and what issues people might face.

The process is extremely easy when planned for because you have to get everyone off of the system and you need to make sure that there are no locks on the system, services running, etc.

The OpenInsight License Renewal and Installation/Upgrade Authorisation Process .pdf file that is located in the Documents folder under your OpenInsight installation contains ‘full’ details, but I have created a couple of videos and uploaded them to my usual RevSoftUK YouTube channel.

There are two videos.  The short video shows how quick and easy it is to authorise systems when the correct procedure is followed.  The longer video goes into a little more detail about why we need this process and some of the usual gottchas that we come across.  The longer video also has a couple of annotations about running the reauth.exe routine with administrator privileges if users don’t have adequate permissions and also about restarting the OEngineServer and other services that might be needed to run the application.

I hope that these videos are useful to developers and end users when reauthorizing their OpenInsight based systems for the annual renewals and also when adding additional users.

This process is applicable to OpenInsight 8.0.3 to 8.0.8, 9.x and it might be different for other versions of OpenInsight (i.e. the forthcoming OI10).


Delving Deep into the OI BRW


I have been a long term fan of the new OpenInsight Banded Report Writer and those goes back to it’s introduction early in the OI 9.x series of releases.  So much so, I decided to take the stand at one of our RUGs and attempt to show our attendees what the new tool set was all about and what it is capable of.

It is a very powerful tool with a familiar design interface that most developers and power users should be happy with following a quick run through the BRW Reference Guide and working through the first few pages of the guide which builds your first report.

However, Don at SRP is in the process of taking the BRW and delving deep into the tool and he aims to reveal how developers can better understand the tool, its configuration and how to get the most from this powerful addition to the suite of OI tools.

His first article has just appeared on the SRP blog and its looks at Unpacking CFG_OIBRW, or more specifically the options for configuring the OI BRW for use and the advantages and disadvantages of each of the options.  There is also a link to the Wiki that he has set up and in which he plans to continue to delve deeper into the tool over the coming weeks.

If you are working with OI 9.x, planning a move to OI 9.x or want to get more from your reporting within OpenInsight, then this series looks set to be a must read.

>Two new OpenInsight WORKS downloads


Some of you will have noticed that I recently pulled the 7.2 to 9.2 one hit upgrade from my blog. This has now been released as a pre-release package and it is now available from within the WORKS area on

The release is in response to customer demand around the world for a single update to OpenInsight 9.2 from OpenInsight versions 7.2 through 8.0.8. Please note that this is a pre-release beta upgrade for testing purposes only. If you are currently running version 7.2 through 8.0.8 and you need a supported upgrade path to 9.2, then we recommend applying the individual patches and upgrades, or installing a fresh copy of 9.2 and using APPBACKUP to backup and restore your applications in the new installation of 9.2 – I recently undertook this route (downloading and applying each patch and upgrade in turn) and it only took about 10 minutes or so to apply the patches and upgrades once I had them downloaded.

Alternatively, if you have the time in your release schedule to fully test your applications features on OpenInsight 9.2 before doing the final upgrade, then this one hit upgrade to 9.2 is perfect for your needs.

Revelation will be pleased to hear of any issues from those of you who do opt for the one-hit upgrade and your assistance in getting this to a supported release will be greatly appreciated. Please email with your questions and comments, or post your comments on the WORKS discussion board on For those of you in the EMEA region, I’ll also be pleased to hear from you and to take your questions and comments.

Whilst in the OI WORKS downloads area, you’ll also notice that Revelation have also recently released a Patch for O4W, names 1.0a. This patch applies to the O4W component that ships with OpenInsight 9.2 and it addresses two issues:

  1. In the O4W form runner, a ‘datepicker’ control generates a browser error when used with European formatted dates.
  2. The URL used by the ‘on-line’ configuration of O4W for loading proper theme has changed.

>3 reasons to take a look at OI 9.2.


As if you needed them, here are just three of the countless reasons why you, as a MultiValue developer, should be looking at OpenInsight 9.2. Using one fully integrated toolset, OpenInsight 9.2 now enables you to:

  1. Very quickly and easily extend the life of your leading MultiValue applications for LAN, WAN and the Web deployments. Creating a web interface for your application can be done in just a few minutes using OpenInsight 9.2’s O4W.
  2. Interact with the entire Windows world in the easiest ways possible. This includes consuming .NET controls, ActiveX controls, Widgets, API’s, Windows hardware, third party applications and more.
  3. Seamlessly support multiple databases from within your application using OpenInsight 9.2’s data connectors. Currently supported databases include OpenInsight’s linear Hash, Rocket Software’s Universe and Unidata (U2), TigerLogic’s D3 and numerous flavours of SQL (including mySQL, MS SQL Server, Oracle, etc.). Support for Univision will follow in a few weeks time.

    This can enable you to enhance your users experience and workflow by aggregating disparate data sources into one interface, whilst continuing to maintain those separate islands of data. This ensures data integrity is retained, whilst enabling your application’s users to read, write and maintain those islands of data AND it enables the users of those islands of data to continue to work with them outside of your application, as they do now.

OK, so there is a fourth reason. Revelation Software has just recently released a free to use OpenInsight 9.2 evaluation version of the toolset – including the data connectors and O4W.

Mention this code (MDP92100810) and you’ll receive an installation key for a full 60 day period, rather than the usual 30 days.

>Back to rumors of a SCM tool in 9.2x


Well I’m now back from basking in the sun (mid 40’s Centigrade) and snorkeling over the Red Sea reefs in warm to hot water – fun. For those of you that are divers, Sharm El Sheik has some wonderful diving spots and those a little less adventurous; snorkeling with hundreds of fish over the inner reef is just amazing.

Anyway, annual vacation over and it’s back to work and back to some more OpenInsight development rumors. The first of which is very exciting as OpenInsight Source Code Management (SCM) tools were requested at the recent EMEA RUG in London and I hear that the guys at Revelation have been working on that request over the last couple of weeks.

My spies tell me that the SCM is invoked by simply setting an environment setting. The editor apparently saves a version of the code every time a program is saved or compiled, but only saved if it is different than the prior version. The versions of the source code are stored in a new table, with an associated ‘control’ table. Groups of code can be associated with version numbers, and an entire version can be rolled out for deployment, or rolled back and made the live version of the software. There’s also seems to be a comparison tool that lets a developer examine differences between different versions of code.

This new OpenInsight feature continues in development, but it is looking very exciting and I hope that many of you will find it hugely useful. It is certainly something that I have constantly been asked for over the last few years and it is great to, yet again, see that Revelation are listening to their developer community and delivering tools that are beneficial, rather than just fun to create.

Watch out for more on the SCM and more rumors about the next OpenInsight release as and when I learn about them.

>OpenInsight 9.x End-User Benefits


Since the RUG and my road trip with Mike, I have had a number of requests for a document that details the benefits to end-users in the 9.x series. Whilst the majority of the benefits are for developers, there are a large number of enhancements that will benefit end-users.

I was planning on blogging the list, but the document grew to a size where this is not effectively possible. Revelation have packed so much into the 9.x release :). For this reason and a few others, I am planning on making the document available on request. Please drop me an email to my usual address (or comment below) and I’ll get a copy to you via email.

The document itself is divided into two main sections. The first is divided into categories based on the tools and each benefit is listed with a few lines of explanation. The second section is a two page bullet point list that simply summarises the key points.

I hope that this will become useful for those of you, like me, who need to justify the annual license fee to your end-users who are currently on 8.0.8 or prior and who you now need to move into the 9.x series.