Dblookup error

HCL Domino Domino Forum
1

Following error displays when dblookup is run:

entry not found in index or view’s index not built.

my code snippet is below:

===

keytouse := new_book;

luvalue := @DbLookup(“” : “NoCache” ; “” : “” ; “Book”;@Text(keytouse);3);

@If(@IsError(luvalue);“no data found”;luvalue);

the “Book” view has been set up “sort by descending” on column “Book”

What can I do to fix this?

2

Subject: dblookup error

When/where is this dblookup used? for example, are you authenticated and autorised to read the document you are trying to collect through this dblookup?

Can you give a little bit more information?

3

Subject: RE: dblookup error

this dblookup is used in “input validation” of a field in a form. whenever I tried to save a document of the form, I see this error. I was given “manager” ACL for the database. database is local.

4

Subject: RE: dblookup error

I can’t see either where this formula goes wrong. I presume the following:

  • the field new_book that you’re using does specifiy an existing book in the lookup view

  • the book column in the lookupview is the first sorted column

  • no document acces rights through reader field for example. (you can see the document when you open the view?)

5

Subject: RE: dblookup error

thanks. your assumption are correct. I just fixed the problem. what I did is:delete the view and recreate it from the scratch.

lotus development makes me crazy sometimes, since I don’t know why things work and why things don’t work in some cases.