Field: 'AAcct': Entry not found in Index

HCL Domino Domino Forum
1

I am a Domino Administrator with a little Design knowledge but, I have a problem with the DBLookup function. I have looked through all the forum entries and tried several suggestions from the forum and the Designer help but, still having a problem.

I am trying to get a DBLookup to work against the names.nsf file. But, regardless what I try, I still get the wonderful error message "Field: ‘AAcct’: Entry not found in Index

I have the following field built into a form (Field name=AAcct). It is a Computed Text field:

FIELD BUN:=@Text(BUNum);

FIELD LUBUN:=@Text(“A”+BUN);

LUBUN;

FIELD ANameLU:=@DbLookup(“”:“NoCache”;“88796F93:007036DF”;“by Alias Name”;“ShortName”;1);

@If(LUBUN=ANameLU;@DbLookup(“”:“NoCache”;“88796F93:007036DF”;“by Alias Name”;“ShortName”;2);LUBUN)

I am stumped and would appreciate any help.

Thank you in advance.

Marcie

2

Subject: Field: ‘AAcct’: Entry not found in Index

What are you trying to achieve actually ? Check any @DBLookup example in designer help …

3

Subject: RE: Field: ‘AAcct’: Entry not found in Index

Thank you for that suggestion but, I have already been through the Designer Help (stated earlier) and tried various examples that did not work.

Thanks anyway.

4

Subject: Field: ‘AAcct’: Entry not found in Index

The error likely means one of your lookup’s are not working.

I suspect the problem are the view names as I don’t know any views called “By Alias Name” in the address books, and I would think they would likely be “People \ by Alias Name” or “Server \ by Alias Name” or “Business Unit \ by Alais Name.”

If this is the case, you will probably need to place / in front of the \ or better yet use the view’s alias which hopefully do not have the 's

A few other suggestions.

I’m guessing a lot of the fields you’re using below are just temp values, if so you don’t need to store the values the FIELD variable := function can be changed to variable := @Function. Then add some error checking

BUN:= @Text(BUNum);

LUBUN:=@Text(“A”+BUN);

ANameLU:=@DbLookup(“”:“NoCache”;“88796F93:007036DF”;“by Alias Name”;“ShortName”;1);

ANameLU := @if( @IsError(ANameLU); “”; ANameLU);

@If( ANameLU = “”;

	"Unable to Locate ShortName";

LUBUN=ANameLU;

	@do(

		ANameLU := @DbLookup("":"NoCache";"88796F93:007036DF";"by Alias Name";"ShortName";2);

		@if( @IsError(ANameLU); ""; ANameLU)

	);

	LUBUN

)

5

Subject: RE: Field: ‘AAcct’: Entry not found in Index

Hi Stephen, Thank you for your response. However, I do have a view that I created in the Names.nsf that is “by Alias Name | vAliasName”. It is an added view to the names.nsf so that all users do not see this view.

6

Subject: RE: Field: ‘AAcct’: Entry not found in Index

Then change it to:

BUN:= @Text(BUNum);

LUBUN:=@Text(“A”+BUN);

ANameLU:=@DbLookup(“”:“NoCache”;“88796F93:007036DF”;“vAliasName”;“ShortName”;1);

ANameLU := @if( @IsError(ANameLU); “”; ANameLU);

@If( ANameLU = “”;

	"Unable to Locate ShortName";

LUBUN=ANameLU;

	@do(

		ANameLU := @DbLookup("":"NoCache";"88796F93:007036DF";"vAliasName";"ShortName";2);

		@if( @IsError(ANameLU); ""; ANameLU)

	);

	LUBUN

)

7

Subject: Field: ‘AAcct’: Entry not found in Index

Take the quotes off of “ShortName” (unless you are really looking for info for somebody named “ShortName”).