It has been very frustrating when the changed Universe 12.1.1 to no allow updating indexes while people are accessing the file. This worked before from 9.6 to 11.3.1 but not 12.1.1. We have clients that run 24/7 and we have to stop our Web-based applications running under Apache Tomcat, make sure no one is using our Eclipse IDE tools and kill any phantom jobs before you use CREATE.INDEX. Otherwise, you get this:
>CREATE.INDEX ACCT.CHECKS BANK.NO NO.NULL
Unable to open "ACCT.CHECKS", file open by other users, exclusive access failed.
Here is what Rocket said in my case:
Advice from our ATS engineer:Reverting functionality to how it was prior to UniVerse 12.1.1 can cause issues where a newly created and built index can be out of sync if existing users have the file open. As long as our customers acknowledge the risk, we could create a new story which would allow customers to have their installation behave as it was prior to UniVerse 12.1.1 if they choose. This would be something that is configurable.------------------------------
Doug Averch (Owner)
U2logic, Inc.
daverch@u2logic.com303-946-5226 (cell & text)
------------------------------