Entry not found in index or view's index not built

Strange error now getting when I open a new form request.  I made no changes to the form, but nosw I'm getting this error.  billable_lookup: entry not found in index or view's index not built.
This billable_lookup is a hidden field on the form that perms this dblookup
temp := @DbLookup("":"NO CACHE"; ""; "GThidden";OOusername; "Billable");
@If(@IsError(temp) & OOusername != "";
@Prompt([Ok];"Automation Error";"Billable hours look up error.");temp)
the gthidden is a view to a different memberprofile form that someones doc would have a field called Billable checked as yes or no.

Always worked, but now when I open a new request I'm getting that popup error box.

Ideas ??

Thank You !
Paul
LVL 4
pratiganAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Steve KnightIT ConsultancyCommented:
Ok so there is something in the view GTHidden that is wrong, maybe replication conflict documents, someone has fiddled with the view and broken it or maybe the username doesn't match any more.

For starters I would:

Open the GTHidden view to have a look - if it is actually a hidden one with ( ) around name and not shown in View menu then hold down Control Shift while you select View menu and Goto and can select it from there.

Look at the form of hte document you are creating.  What is the value of the OOUsername field - is that exactly the same as the entry in that view, e.g. unhide the field or put in @prompt([OK];OOUsername); to appear when the form opens temporarily.

Could be just going into the view and pressing Shift-F9 to rebuild the view will help, or press Control Shift F9 and rebuild all views in the database.

Steve

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pratiganAuthor Commented:
You had me looking in the right directions.  Once I went in and looked closer at the billable_lookup field, I noticed the:
temp := @DbLookup("":"NO CACHE"; ""; "GThidden";OOusername; "Billable");
 @If(@IsError(temp) & OOusername != "";
 @Prompt([Ok];"Automation Error";"Billable hours look up error.");temp)

logic was in the default value section of the field instead of in the Input Translation section.  This is why the DBLookup was trying to execute when I would click on create new request and the OOusername wasn't even populated yet.  I moved the lookup to the Input Translation and no more error.
Thank You !!
pratiganAuthor Commented:
Great redirect.
Thank You !!  Very much appreciated.
Steve KnightIT ConsultancyCommented:
Glad you sorted it!

Steve
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.