While performing Classification Search, the number of rows returned in results is based on Preference->Search-> Latest Version Search (Yes/No). I get all the data when the option is set to NO. Although when set to YES, the result set gets truncated while displaying an "Incomplete Results" Message. When the data gets truncated in search results and a lot of rows do not show up, the same rows show up when data is refined using Facets. This tells me that there may be something to do with the number of Search results that can be displayed. I checked the QueryLimit Values in wt and db properties and they seem fine. Any idea why this may happen?
Also, the 2 seem unrelated - The table size limit showing up when the Search preference is set up a YES.