@DBLookup Formulas

HCL Domino Domino Forum
1

I have two 6.01 servers running.

  1. An application on Server A, with extensive DBLookup fields, works perfectly.

  2. When a New Copy (including design & documents and ACL) of the database is made on Server B, DBLookup fails with a “A view of that name cannot be found” error.

  3. Then tried making it a template and putting it in the root of the Server B data directory and refreshing the design of the database. Result -

design was not replaced. Problem persisted.

  1. To make sure that the servers weren’t acting differently, I copied the non-working DB back to Server A, it didn’t work on Server A either.

For some reason, on Server B, the design is corrupt somehow. Any ideas???

2

Subject: @DBLookup Formulas

Are you sure that the wanted view is available in the copy or template of the db. Maybe it*s a private view. This could be a probleme.

3

Subject: @DBLookup Formulas

If you use @dblookup with the replicaid of the database (hardcoded), it will fail : @dblookup(“”;“12345678:12345678”;“view”;“key”;“result”)

If you use @dblookup with the name of the database hardcoded, and you copy it to a new location, it will fail :

@dblookup(“”;“server”:“hardcodeddatabase.nsf”;“view”;“key”;“result”)

So please give an example…

cheers,

Tom

4

Subject: Please give an example @DbLookup that fails.