Sometimes you come across a situation in the wild that seemingly defies all logic. This week was one of those. A European client (you can tell this is being written by a Brit as we tend not to see ourselves as European by default - even though we patently are) running a new hybrid AREV32/OI system reported a most unusual scenario. It manifested itself during a batch process - rows would be altered in AREV32, then the table would be selected on an indexed column and the resulting row set would omit the altered rows. If the rows were selected in OI then the altered rows would reappear as if by magic.Obviously, the client had forgotten to set the "Update before select flag" in the environment. Except they hadn't - it was there. So we span it on its head and created new indexes in AREV32, made alterations and retried selections. Now they worked in AREV32 but the same process failed in OI. To sum up, indexes would only be updated in the environment in which they were cre...
A client enquiry brought out some interesting discrepancies in the way in which the Universal Driver Heavy (UDH) communicates the fact that it has stopped. The client in question wanted to be able to monitor the UDH to create alerts when it flipped into journaling mode so that corrective action could be taken. Initially they thought that it would be enough to check the registry key value "MirrorInBackup" but they quickly ascertained that whilst this could be relied upon to show whether the UDH had been put manually into journaling mode, the registry key was not updated when the UDH flipped into journaling mode because of some failure. Revelation very kindly provided us with the workaround - which was to check for the existence of journal files - if they exist then we're journaling regardless of what the registry value may say! As there are a variety of journal files this isn't a completely straightforward task but the required logic can be represented as follows ...
We recently undertook a consultancy exercise on a client's site, where, to cut a long story short, the system started failing with C0000005 exception errors. This was a new development as the system had been stable for some time beforehand so we were at a loss to explain why. Every other time we'd encountered this error it had been shown to be DEP related so we confidently asserted that this must be the case now. We suggested disabling DEP for OI and rebooting the server. This suggestion was not met with universal acclaim as this was a UDH site and the client wanted 100% up time. Reluctantly a window was scheduled to log everyone out of the system and the modifications were made and the server was cycled... And the system kept failing with C0000005 exception errors. At our wit's end we again resorted to installing an oeprofile.log to see what was going on at the time of the crash. Now a quick caveat - the site was not at 9.4 so the SQL Bond was not as r...
Recently when working at a client site with a mixed OI/AREV32 environment we were asked if it was possible to call AREV32 programs within OpenInsight - a perfectly valid question when so much historical business logic already exists in that environment. We considered that this was a perfectly reasonable request and set about establishing whether this was possible in a straightfoward manner. Now to investigate this it is necessary to know a little about how OpenEngine loads programs to be run. This is all done via the RTP27 program loader. To simplify, RTP27 firstly looks to see if the program requested is already on the program stack and if it isn't it looks for it in SYSOBJ. Naturally it does this following the application inheritance chain. So assuming an application called SATS, which inherited from SFX, which in turn inherited from SYSPROG. If you were trying to run a program called GEN_CONV, RTP27 would first try to load $GEN_CONV*SATS then if that failed $GEN_CONV*SFX and...
The Problem A client contacted us recently to complain that when they were running long reports, the OpenInsight Window would freeze and the caption bar would have "(Not Responding)" added. Rather cleverly the client had got around this by generating the source code for the RLIST routine (a trick we haven't used for quite some time) and adding calls to yield().But as they pointed out, it would be a lot of work to do this for every report in the application. They wanted to know if there was a better way. Discussion Well here at Sprezz Towers, providing better ways is our raison d'ĂȘtre, so we provided an answer. But before examining our response it might be instructive to examine exactly what is going on and why. Applications running on the Windows desktop run under the control of the Desktop Windows Manager (DWM), which places any messages for the application (such as mouse movements or keystrokes) into a queue for processing. If the application doesn’t chec...