Remotely Accessing Universal Driver Manager
This blog article demonstraites a technique to access the LinearHash service Universal Driver Manager console through custom OpenInsight BASIC+ code.
Clearing OpenInsight SYSLISTS Table
The SYSLISTS table in OpenInsight can become cluttered with old records and much like a TEMP directory it can and should be cleared out. When it comes time to clear the table the clear_table command won't work because SYSLISTS is a protected system table. Instead the easiest thing is to simply select and delete all the records.
Here is a sample routine to do the task.
Person Info Test Data Table for OpenInsight
Benchmarking with real data or copies of real data is useful but it becomes problematic if you want to compare the performance of one site with another site and can't use the same data set at both sites. Having a consistent data set that is sanitized and can be used at any site can be a useful for performance benchmarks and consistent testing.
Below is a download link for a LinearHash table and accompanying source data table of a 1 million row person information table. Records are sequentially keyed from 1 to 1,000,000.
PERSON_INFO_TEST Dictionary:
OpenInsight Dedicated Indexer Health
OpenInsight supports updating indexes directly on the server by running the index update process through the Windows Task Scheduler. If you use that process it has probably silently failed at some point leaving you without indicators until customers call with problems. The article walks through setting up notifications for failed indexes.
Wireshark: Capturing Re-transmissions for Specific Host
Here is a little tip when working with Wireshark to diagnose problems with traffic flow to a remote host. This filter command shows resent TCP packets for a remote host.
Hiding O4WDialog Close Button
The O4WDialog function is used to generate and display dialog boxes. This post shows you how to remove the default close button in the title that cannot be handled as an event in OpenInsight.
Writing to the Event Log From OpenInsight
This article contains a sample BASIC+ routine for use in OI (OpenInsight) that a developer can use to log information to the Windows Event Log on the system running OpenInsight. Writing to the event log is useful for web applications that need to log server exceptions that a system administrator can review later but it's also useful for desktop applications that need to do the same thing without bothering the user.
RTI_CDOMail No Control Specified Error
This is a short tech tip for working with the OpenInsight RTI_CDOMail function. I recently uncovered a situation where the function was returning "Error at step create No control specified" when trying to send email from a newly setup workstation.
Run or Eval VBScript Embedded Code in OpenInsight
Interacting with VBScript code embedded in OpenInsight BASIC+ code is a useful technique. This article provides an example and discusses the difference between using Run or Eval methods to call the embedded code.
Using Regular Expressions in OpenInsight Coding
Regular Expressions are short and often complex pattern matching statements that can do the work of an entire pattern matching function. This blog post provides an example of how to harness regular expressions from inside OpenInsight BASIC+ code.