iFind index missing data
I've been using iFind indices in one of my applications but this morning discovered that the index is missing data. I confirmed the issue also exists in our test environment and rebuilt the indices there. That seems to have fixed the immediate problem. However I'd like to understand how this came about to avoid it happening in the future.
Has anyone encountered this before and know the cause?
We've regularly upgraded the Ensemble instance when new releases come out and are now on 2016.1. We've been using the indices for just over a year without issue except that sometimes this error comes up:
ERROR #5821: Cannot instantiate query: 'SQLCODE = -149, %msg = Index method crm.Question.QuestionIndexFind(...) failed with error: SQLCODE=-400,%msg=ERROR #5002: Cache error: <CLASS DOES NOT EXIST>zQuestionIndexFind+2^crm.Question.1 *crm.Question.gZOndQ [zQuestionIndexFind+2^crm.Question.1:HERMES]'
We're been able to resolve that by recompiling the class, but I'm not sure what the root cause it.
Any help would be appreciated.