API Error : The API call to NIFindDesignNote returned an error : Error 17412:
A document was created with some interesting values, but some values are set to 0 (DB size, view size, etc...) Do you know why?
The database size is looked up in the Notes log database on the server (in the Database\Sizes view). It searches each Database Activity log document until it matches the full file path of the specified database. If the database cannot be found, then it will return the database size as 0. Make sure that the user triggering the analysis has rights to read the Notes log database on the server.
The view sizes are also looked up in from the same Database Activity log document. There are a number of reasons why the view size might be returned as 0.
- If a view has not been opened in a specified period of time (depending on the view's index settings), the server can drop the view index, which means it is taking up no space. (The index will be rebuilt the next time someone opens the view.)
- View sizes would also be returned as 0 if the database cannot be found in the Database\Sizes view in the server's log.nsf, or if the user triggering the analysis does not have rights to read the database.
- It appears that the R6 version of the Notes Log database stores view titles and sizes differently. This application was developed in R5, where the Notes log stored lists of view names and view sizes (in multi-valued fields called ViewTitles and ViewSizes). In the R6 design, the sizes and titles are lumped together in a field called AllViewInfo. In order to work in R6, the code would need to be modified in order to accommodate this new design.
Do you have comments on this Ask the Expert question and response? Let us know.
Dig Deeper on Lotus Domino Designer
Related Q&A from Brad Balassaitis
Upon moving to Lotus Notes 8, some Lotus Notes users received an error message stating: 'Database has not been opened yet.' Find out why here. Continue Reading
Discover what security settings you need to fix if you encounter the Lotus Notes database error: 'database is not opened yet.' Continue Reading
Learn the Formula language code that you can use if you'd like your Lotus Notes form with embedded views to stop displaying all response documents. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.