OpenInsight 9.4 “Roll Up” Patch v3


OpenInsight 9.4

 Revelation Software have recently released a third roll up patch for OpenInsight making it much easier for developers and users to keep their systems up to date.

This patch includes all previous fixes for OpenInsight 9.4 and replaces the original  “Roll Up” Patch v1 released on March 3, 2016 and the second “Roll Up” Patch v2 released on March 8, 2016. The patches included are as follows:

  • BUTTONDOWN Event Handler Patch for OI 9.4
  • SQL Connector Patch for OI 9.4 v2
  • Buffer Overflow Error Patch for OI 9.4 v2
  • RevelationDotNet 9.4 “Roll Up” Patch
  • RTI_TASKMANAGER 9.4 Patch v2
  • O4W Validation Patch for OI 9.4
  • QBF Patch for OI 9.4
  • Arev32 Descending Sort Issue Patch for OI 9.4 v2
  • Single Sign On Patch for OI 9.4
  • CTODICT.MFS Patch for OI 9.4 v2
  • Arev32 Conversion Utility Patch for OI 9.4
  • Socket Functions Patch for OI 9.4
  • O4W Popup Patch for OI 9.4
  • Base64 Encode/Decode Patch for OI 9.4
  • PREVVAL Patch for OI 9.4
  • O4WGRAPHDATA Patch for OI 9.4
  • RTICDOMAIL Patch for OI 9.4
  • Banded Report Writer Patch for OI 9.4 v2
  • Engine Server Patch for OpenInsight 9.4
  • Listbox Patch for OpenInsight 9.4

Works members can download this patch from the Works Downloads section of our web site.

Advertisements

List User Locks Administration Tool for OI v9.4


OpenInsight 9.4

Revelation Software have released a new RDK via the WORKS section of http://www.revelation.com which contains an updated LIST_USER_LOCKS window, along with supporting LIST_USER_LOCKS and RTI_LH_INFO procedures.

This utility has been tested with OpenInsight 9.4 and above and the Universal Driver 4.7.2 and Universal Driver 5.0.0.5.

Execute the window LIST_USER_LOCKS. The window will display a list of locked records. Each line item will display computer name, volume, table and record keys. With the Universal Driver 5.0.0.5 the computer name will include the network logon and process ID so that you can determine exactly which session holds the lock on a terminal server.

Works members can download this utility from the Works Downloads section of the web site.
Read On….

New OI User Story


Plumbing Company Modernizes Services with Revelation Software
By Joyce Wells

New England Water Heater is a plumbing services company specializing in water heater repair and installation based in North Waltham, MA. The company provides a centralized service through a network of geographically dispersed plumbing companies in the surrounding region, including its own company, Home Services of New England (HSNE) Plumbing.

NEWH’s services include the sale, lease, installation, and repair of water heaters for non-commercial customers in the New England states, as well as other plumbing services, ranging from fixing leaking faucets to handling oil-to-gas conversions.

To support this work, the company provides a customer hotline in Massachusetts for more than 20,000 accounts. Revelation Software is the backbone of the overall IT system.

Goal
Today, businesses of all types are changing the way they operate. They are adopting hosted services rather than purchasing and maintaining software and hardware on-premises, and, as a result, employees also now frequently work remotely.

With the advances in IT services that have taken place over the past 5 years, NEWH saw an opportunity to move to a cloud-based system to support its employees and customers.  The goal was to improve its overall quality of service while also enabling office staff to access systems from home.

In addition, the company wanted to eliminate the overhead costs of office space, a local area network, and shared printers. Critical to the new set-up was the ability for its affiliated plumbing companies, as well as its own HSNE staff, to input information about service visits and billing into the system and access new assignments while on the road.

Process
In September 2015, NEWH and HSNE decided to eliminate their physical offices, where each employee was provided with a desk, telephone, shared printer, and a desktop computer connected to a local file server to perform their job, said David Harmacek of Harmacek Database Systems, who specializes in Revelation Software products. The process of publishing the company’s 28-year-old Advanced Revelation application to the cloud was handled by Harmacek, who has been a consultant to NEWH since 1994.

When the decision was made to migrate the system, NEWH had a typical Windows Server, internet connections, IP phones for customer support, and a range of website-oriented support interfaces, as well as a hybrid Arev (Advanced Revelation) 32 and OpenInsight 9.4 database system.

To modernize the operations, Harmacek put a plan in motion to switch to a hosted system and began implementing this new approach in February 2016.

The Arev32/OpenInsight system was migrated to a Parallels server. Since the telephones were already on an IP system, no adjustment needed to be made, but office documents and storage outside of the database needed to be moved to Microsoft Office 365 and OneDrive.

As a long-time Revelation Software customer, NEWH uses a system on Revelation’s OpenInsight 9.4 for business processes such as document management, phone calls, and customer support—everything but accounting.

Because the system is so critical to its business—handling processes such as document management, phone calls, and customer support—the NEWH migrated the system to the Parallels 2X RDP server, while also maintaining the physical system, to make sure that everything transitioned flawlessly.

Eventually, even though the company had not yet moved from its physical office space, it began using only the remote services, as if all the employees were working from home, said Harmacek. The dual on-premise and cloud approach lasted until late spring. By June 2016, the company no longer had physical offices, said Harmacek.

Biggest Challenge
“Working with a 28-year-old application, we found that there are many features that are no longer in use, while other capabilities are leveraged all the time and have been just working forever,” said Harmacek.

“The biggest challenge was eliminating the dependence on a local network for file storage and local printing, since the employees could no longer walk over to an office and hand someone a piece of paper, and they could no longer print anything,” he said.  This issue has been solved by using the feature in Parallels 2X that allows a local folder to be managed from the application. Reports and PDF files can be placed onto the remote desktop. Files, both PDFs and images, can be uploaded and integrated with the hosted database.  “Anything that needed to be done had to be accomplished by interacting with the system. I had to find all the places in the processes where this was needed and change the system to allow it to be done that way.”
Read On…

Listbox Patch


OI Eye SquareFollowing the release of the Windows 10 Creators Update by Microsoft recently, Revelation found that OpenInsight Listboxes were affected by the update.

A Listbox Patch for OpenInsight 9.4 has therefore been released to address this issue.   The Windows 10 Creators Update has caused Listboxes to no longer display properly in OpenInsight 9.4 and this new patch resolves this issue through the replacement of the existing OInsight.exe.

OpenInsight will show the version as 9.4.2 which can be viewed in the top left corner of the IDE.  OpenInsight Works Members can download the Listbox Patch for OpenInsight 9.4 from the Works Download section of our web site.  If you are an end user, please contact your application author to obtain your application upgrade accordingly.

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).

Linear Hash Sizelock Administration Tool for OI v9.4 released


In conjunction with the Linear Hash Reporting and Resizing Tool released in March 2016, Revelation Software are publishing a sizelock administration tool called RTI_SET_SIZELOCK.  This tool will enable OpenInsight system administrators to view linear hash statistics within an application and identify and modify the file sizelock parameter.

The sizelock parameter is used to control the automatic resizing of the primary address space. A sizelock of “0” indicates that a table should be allowed to expand as more rows are entered, and become smaller as rows are deleted. A sizelock of “1” indicates that a table should be allowed to expand, but should not become smaller. This is useful in cases of a presized table, when a preliminary expectation is for the table to hold 1000 rows, but more rows may be added. If a sizelock is set to “2” or more, the table is not allowed to expand or contract. A sizelock of “2” is very important during a select operation executed on a network, when one user is searching a table for information while another user is entering new data.

OpenInsight increments the sizelock by 2 for the duration of the select operation. If another user is adding information, it is possible that the system could determine that a table needs to be resized. If this were to occur during a select operation, the process might yield unpredictable results: rows that have not yet been evaluated might be skipped, or rows might be processed more than once. Because the sizelock is “2”, no resizing takes place. Once the process is finished, the sizelock is decremented by 2, restoring it to the table’s original sizelock value. While the table might now be slightly out of size, the addition or deletion of another row will result in correct resizing.

The RTI_SET_SIZELOCK tool will allow an OpenInsight system administrator to globally set the sizlelock parameter on all or select tables.  For instance if a sizelock parameter is set to “2” or greater the table will not resize.  You can use this to disable resizing during busy periods and then re-enable resizing during quiet periods.

You can use this tool on any table, including ! and DICT files, as well as system files such as SYSLISTS and SYSOBJ.

RTI_SET_SIZELOCK is available at no cost to all current Works members and can be downloaded from the Works Download section of our web site.

Linear Hash Sizelock Administration Tool


sizelocktool

Before I get into the changes to the Universal Driver 4.x and 5.x, I’d like to touch on some of the great work that RevUS have been doing with regards to helping people to get more performance out of their systems.  Most of us use indexing and we try to optimise our code as much as possible, but Revelation are also tinkering with things and they have recently released some tools to help developers to get the most from their systems.

For those of you that have made the move to OpenInsight 9.4, (and those of you that have not yet made the move, now would be an ideal time) Revelation have a Linear Hash Sizelock Administration Tool for you.  This has been key to helping some of our larger clients with large systems to address some intermittent, but nonetheless, troubling issues.

In conjunction with the Linear Hash Reporting and Resiaing Tool released in March 2016, Revelation have published a sizelock administration tool called RTI_SET_SIZELOCK.  This tool will enable OpenInsight system administrators to view linear hash statisitcs within an application and identity and modify the file sizelock parameter.

Why is this important and useful?

The sizelock parameter is used to control the automatic resizing of the primary address space.  A sizelock of “0” indicates that a table should be allowed to expand as more rows are entered, and become smaller as rows are deleted.  A sizelock of “1” indicates that a table should be allowed to expand, but should not become smaller.  This is useful in cases of a presized table, when a preliminary expectation is for the table to hold 1000 rows, but more rows may be added.  If a sizelock is set to “2” or more, the table is not allowed to expand or contract.  A sizelock of “2” is very important during a select operation executed on a network, when one user is searching a table for information while another user is entering new data.

OpenInsight increments the sizelock by 2 for the duration of the select operation.  If another user is adding information, it is possible that the system could determine that a table needs to be resized.  If this were to occur during a select operation, the process might yield unpredictable results: rows that have not yet been evaluated might be skipped, or rows might be processed more than once.  Because the sizelock is “2”, no resizing takes place.  Once the process is finished, the sizelock is decremented by 2, restoring it to the table’s original sizelock value.  While the table might now be slightly out of size, the addition or deletion of another row will result in correct resizing.

The RTI_SET_SIZELOCK tool will allow an OpenInsight system administrator to globally set the sizlelock parameter on all or select tables.  For instance if a sizelock parameter is set to “2” or greater the table will not resize.  You can use this to disable resizing during busy periods and then re-enable resizing during quiet periods.

You can use this tool on any table, including ! and DICT files, as well as system files such as SYSLISTS and SYSOBJ.

RTI_SET_SIZELOCK is available at no cost to all current Works members and can be downloaded from the Works Download section of www.revelation.com.