Only some views will open

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-)

Subject: Only some views will open …

Just a shot in the dark here…

Is the server running out of disk space for the view indexing? Probably too simple and obvious.

Subject: * Nice try, but no, it’s not that. :frowning: Thx anyway. =B-)

Subject: Curiouser and curiouser …

… the only solution we have found is to run the db on 6.0.1 Linux server, Windows does not do the trick. No, there are no platform specific calls. This is a new one on me.

=B-)

Subject: * Moved server to 6 (6.0.1 in fact), this seems to fix it nicely. =B-)