Using an OpenInsight watchdog stored procedure to confirm scheduled processes are running as expected requires RTP27 be used to reload the watchdog function before each use otherwise errors might go unreported as explained in this blog article.
When launching OpenInsight using the Universal Driver 4 error FS1104 Group 2101 can occur if OpenInsight was previously configured to use the Universal Driver 5 but then switched back to Universal Driver 4. This article discusses how to switch between the two.
This blog article provides a solution to working with git subtrees when you encounter a 'cannot bind' error or subtree merges into the wrong folder.
Included in this blog article is another tool to help when benchmarking OpenInsight systems. The PERSON_INFO_FREEBASE_TEST table available for download below is an extended version of the PERSON_INFO_TEST table that include a multi-value field containing references to records in the CS_FREEBASE_TOPICS table. The test table is 1 million rows of fake person information. Records are sequentially keyed from 1 to 1,000,000.
Utility to get the last compile date time stamp from a stored procedure by extracting it from the compiled OpenInsight routine.
There are various references in the OpenInsight documents directory on the web for configuring Apache on Windows to run OECGI3.exe and O4W but some methods reffer to out-dated configuration directives or CGI only configurations. The blog DSig's Adventures in Revelation's O4W had an excellent summary of configuring O4W and Apache 2.2 but some of those configuration directives are out-dated in Apache 2.4.
Simple Hello World program for OpenInsight O4W. Great starter if you need a basic program to test out some new code.
Out of the box OpenInsight 9.4 O4W ships with a depedency on JQuery library hosted at Google. If you are unable to access the internet or are blocked from accessing Google trying to load a local O4W page will fail. The start.htm login prompt is a quick and easy indicator. If your login box is in-line as shown below the JQuery libraries didn't load:
Viewing the page source reveals a script dependency to googleapis.com.