Error: Server Error: Entry not found in index

HCL Domino Domino Forum
1

Hi, I’m having troubles with the @DBlookup function. I’ve imported some data from a Lotus 123 spreadsheet and when I run the follwing code I get “Error: Server Error: Entry not found in index” error message. Look forward to some feedback.

@If(@IsNewDoc;

@Do(SrvrNm:=“ACANLM21”;

Code:=@Left(@Prompt([OkCancelList];“Master Agency List”;“Choose the Master from the list below that this record will be associated with. You will be able to set up a Prime code association later:”;“”;@Unique(@DbLookup(“”:“NoCache”;SrvrNm:“Inform\Public\AMPals.nsf”;“MtrLookupCd”;“Lookup”;2)));6);

NM:=@DbLookup(“”:“NoCache”;SrvrNm:“Inform\Public\AMPals.nsf”;“ByHcdOnly”;CODE;4);

@Command([ViewRefreshFields]);@SetField(“NM”;NM);@SetField(“Master”;Code);@Command([FileSave]);@Do(@Command([EditMakeDocLink]);

@Command( [EditGotoField] ;“L” );@Command([EditPaste]);@Command([FileSave]);@Command([EditGotoField];“SCallBus”)));

@Return(“”));

2

Subject: Error: Server Error: Entry not found in index

Not sure what your keys are, but is there a field on the form named CODE that can be matched in the view that you are looking to? Also, is the first column of the view sorted? Lastly, in the other lookup, you have the key set to “Lookup”. Is that the key or should it be using a field?

3

Subject: RE: Error: Server Error: Entry not found in index

Hi, I don’t have a field called CODE on the form. Yes, the first column in the view is sorted/categorized with the key value LOOKUP. The key value in the view is LOOKUP.

Look forward to your response.

Thanks,

Courtney