Server restart and now $$return won't return anything I specify

HCL Domino Domino Forum
1

I restarted my server and now my web search (which has worked for months) will only return to the server console “Entry not found in index”.

Nothing’s changed in the search form and the $$Return formula has always been:

DBName:=@Subset(@DbName;-1);

“[[/”+DBName +“/” + ViewName + “?SearchView&Query=”+Query+“&SearchOrder=”+@Text(Sort)+“&SearchMax=”+@Text(MaxResults)+“&SearchWV=”+@If(ExactMatch=“”;“TRUE”;“FALSE”)

+@If(UseThesaurus=“”;“FALSE”;“TRUE”)+“]]”

which I believe was copied directly from the searchsite template and has always delivered.

Now, just for testing purposes I’ve tried any/everything in the $$Return field and it’s the same “Entry not found in index” thing. Here’s what I’ve tried so far:

“[[/” + “http://www.google.com” + “]]”

“[[/” + “www.google.com” + “]]”

“[[” + “http://www.google.com” + “]]”

“[[” + “www.google.com” + “]]”

“[/” + “http://www.google.com” + “]”

“[/” + “www.google.com” + “]”

“[” + “http://www.google.com” + “]”

“[” + “www.google.com” + “]”

among many other things just to see if the $$Return works.

Does anyone know of a test I can do to see if $$Return is awake?

Of course gravy would be to get my actual search formula to work,

Thanks so much,

-MC

2

Subject: SOLUTION: server restart and now $$return won’t return anything I specify

turned out my database was corrupted so I:

a. went to the server console and issued the following commands:

  • load fixup directory/databasename.nsf

  • load updall directory/databasename.nsf

  • load compact directory/databasename.nsf

  • dbcache flush

  • exit

b. From the server’s Notes Client, I opened databasename.nsf (from local not server since the server was previously shut down in step a above) and did a File/Database/New Copy to databasename2.nsf

c. From Windows Explorer I renamed databasename.nsf to databasename.old

d. From the server’s Notes Client, I opened databasename2.nsf (from local not server since the server was previously shut down in step a above) and did a File/Database/New Copy to databasename.nsf making sure the option to create full text index was checked off (for purposes of searching)

e. I restarted the server, problem solved

Hope this helps someone,

-MC