Problem opening a view xith @allchildren in the select

I have this error message in opening a base in V6:This database must be compacted to support the use of @AllChildren or @AllDescendants in a formula

Annyone has an idea what to do

thanks

Subject: Problem opening a view xith @allchildren in the select

We notice the same problem, openning a database created with Domino R5 on a Domino R6 server. This is an alternative response to this problem.

The error message was not significant for us. The problem is not coming from compact task running or not running.

For us the problème was coming from the selection attribute of the view. We replace “simple search” type of selection by a “Formula” type of selection. I do not know why the simple search was working with R5 and it is not working with R6. The database was correctly indexed.

It works with a formula for the selection, no error message anymore.

Subject: Here’s what HELP says…

Found under Properties that improve database performance.

Disable specialized response hierarchy information

By default every document stores information that associates it with a parent document or a response document. Only the @functions @AllChildren and @AllDescendants, which are often used in view selection and replication formulas, use this stored information. Maintaining this information has a significant, negative effect on database performance.

To improve database performance, disable the response hierarchy information in databases that don’t use these @functions by selecting the Advanced database property “Don’t support specialized response hierarchy.”

Disabling the response hierarchy information has no effect on views and replication formulas that display information hierarchically without using @AllChildren and @AllDescendants.

Disabling the response hierarchy information sets NotesDocument.Responses to 0 documents.

If you select or deselect the “Don’t support specialized response hierarchy” property, you must compact the database so that the setting takes effect. Compacting in this case makes a temporary copy of the database, so your system must have the disk space to make the copy.

Tip You can also run the Compact server task with the -h or -H option to enable or disable this property and then compact.