Corrupted Repository Indexes on Upgrade 3.7.5 to 4.0.2 (OpenInsight 32-bit Specific)
At 04 JUL 2002 01:46:01PM Richard Guise wrote:
Recently upgraded single-user development copy OI 3.7.5 to OI 4.0.1 and thence to 4.0.2.
Some windows now don't appear in the Form Designer's open file list - seems about 15% to 20% affected. If I type in the name of one it says it don't exist. However, system editor shows that it's there in SYSREPOSWINS and that there's also an entry in SYSREPOS.
I've tried rebuilding system indexes, etc. and nothing cures.
Similar problem but seemingly on smaller scale with stored procedures.
Only cure so far is simply to remove the records and reload from my OI 3.7.5 backup copy.
Anyone else met this? Anyone got an easier way of rebuilding the rogue index?
T I A
At 04 JUL 2002 04:00PM Richard Guise wrote:
Since posting this - a solution.
FIRST I BACKED UP!!!
Then I wrote a simple program which SELECTed SYSREPOS via RList - as a RESOLVED select list.
Then it looped through SYSREPOS reading each record, deleting it and rewriting it.
It took a while to process…
Then, Hey Presto! The screens seem to be all present and correct in the form designer, etc.
Which suggests that a repository index got corrupted but the procedure to rebuild repository indexes didn't in fact rebuild the guilty index.
Comments, RTI or anyone???