Problem description
The following error message appears when I read data from a search index that is synchronizing existing data from the table for which the search index is created:
OTSErrorMsg: Disallow read index table in building base state
Analysis
Existing data is read from the table for which the search index is created and synchronized to the search index. Data cannot be read from the search index before existing data is synchronized. You can read data from the search index only after existing data is synchronized to the search index. The time required to synchronize existing data to the search index is determined by the size of data in the table for which the search index is created.
Solution
Read data from the search index after existing data in the table for which the search index is created is synchronized to the search index.