We have a db or around 800MB, 170k documents, many complex views, with hierarchy. On both R5 (5.0.12) and 6.0.1 only some views will open, others simply hanging and never completing the open. R6 opens a few views, while R5 open one of them. It happens quite consistently on a variety of replicas, so I don’t see how it could be simple file corruption.
The database replicates quite happily though.
We saw something like this in the past when we accidentally created hierarchy loops, but now we check for that and none show up.
My theory is that it could be either some really exotic hierarchy problem, or perhaps a scrambled UNID.
Any other ideas for things we could look for?
BTW a compact on this db truncated it to 17MB. Fixup never completes. All of this is complicated by our main server taking .5 to 1.5 million web hits a day (though not on the db in question).
Cheers and TIA
Andy =B-)