From Sprezz Towers

Notes from the workshop.

Technical discoveries, field notes, unlikely bugs and the occasional opinion.

You are Auth-ful - but I like you

Recently, a client was a little late in applying their authorisation code to their copy of OI10, and attempts to access OI were met with error messages "PSSI.66: ???". This seemed a strange message and at first we suspected that it wasn't even an OI message. However chatting to the Rev developers, it seems that an insert (PS_RESOURCES) was missing from SYSENV and that it should in fact have had the following values  /////////////////////////////////////////////////////////////////////////////// //[PS_SYSINTIALIZE]//////////////////////////////////////////////////////////// PSSI.00: No entry window defined for the %1% application. PSSI.01: No visible entry window started for the %1% application PSSI.02: Unable to start entry window "%1%" for the %2% application PSSI.20: . Process aborted PSSI.21: %1% initialization PSSI.60: This Developer Class Server Deployment Pack for OpenInsight is due to expire on %1%.|Please contact Revelation Software at +1-800-262-4747 to...

Read article →

OI 10 makes it easier to get onto the Property ladder

One of the intermittent problems we face when developing with OI 10 is knowing about the new properties and features that we now have access to. The pace of development is so rapid that the documentation just doesn't keep up. There's a fine source of documentation at  revDevX.com  along with multiple blog posts at the same site but sometimes the Lord helps those who help themselves. With this in mind, we'll use a real world example to illustrate how much easier life can be when we have access to such new features. We recently wanted to have a radio button contract or expand based upon a control record. We knew how we would have accomplished this in the past - we'd grab the button control object, destroy it, modify it then recreate it. That's all well and good, it works and the control stays at the right place in the tab order - but it can change the Z-Order of the control which isn't always desirable. Naturally we wondered if there was a better way in 10. Of cou...

Read article →

Indexing issues on LARGE tables

 We've been doing a lot of stress testing of LH at Sprezz Towers to help a client with speed issues on large tables. As part of that we've created some 60 million row tables to play with combinations and permutations of differing indexing setups. In so doing, we came across a situation where the index sort would get to 80% and then just exit with an FS220 error. (FS_REL_NEED_REBUILD_ERR$). Now to be honest, this was confusing to us as there wasn't a relational index on the table. So speaking to the good folks at Rev, it was clarified that this was the wrong error but for fairly obvious reasons we were the first to notice. After discussing further with them we came to the conclusion that it must be related to disk space. So began an increasingly frustrating attempt to free up disk space (why oh why did I format my USB sticks with FAT32 and its 4GB file size limit?). Subdirectories were zipped, old files deleted until - finally we had the 40GB or so free that we needed.  We t...

Read article →