Error 404; "Lotus Notes Exception..." Accessing Form over the Web Which Uses @DbLookup

Technote (FAQ): 

Problem:

A 404 Error page is returned to the browser when accessing a form in a Domino database over the web. The browser shows the error: "Error 404 HTTP Web Server: Lotus Notes Exception - Entry not found in index." The server console returns the error: HTTP Web Server: Lotus Notes Exception - Entry not found in index [/MyDatabase.nsf/Myform?OpenForm]

Solution

If the form in the database contains a field that uses a @DbLookup formula for its choices, and the @DbLookup results in an error then the Web Server will throw a Lotus Notes Exception and return a 404 Error page. For example: Create a Dialog List field in a form and use a @DbLookup formula for its choices. @Unique(@DbLookup("";"":"";"Main";@Name([CN];@UserName);"UserName")) If the @DbLookup fails to find the expected entry in the given view the page will NOT load. To work around this issue one should use proper error handling to catch the possibility of the @DbLookup failing. This can be done by using @IsError on the result of the @DbLookup and return a null string if the result fails. For example: result:= @Unique(@DbLookup("";"":"";"Main";@Name([CN];@UserName);"UserName")); @If(@IsError(result);"";result) Variations of the error message may also occur. For more details on the common error messages which can occur with the @DbLookup and @DbColumn functions see the following document: " @DbLookup and @DbColumn Error Messages in Notes" (# 1084493)