On-Premise Incremental Enterprise Search Indexing not working

I have been fighting with Enterprise Search Indexing since upgrading to 2025.2. It has become apparent with the new design introduced in 2025.1 that I have to use incremental indexing. I’m struggling to get this working properly in my test environment. I’ve had a open ticket with Epicor for a month.

I believe I have accurately followed the documentation that I can find. CDC task and Enterprise Search Indexing are scheduled and have been running for several weeks -

An Enterprise Search Index Subscriber is present in Subscriber management. I presume that this was added automatically when the search index was created. I note that there are no rules listed and have found no documentation specifying creation of rules for Enterprise Search Index.

Orders and lines that had been entered into the system since these tasks were put in place had not been picked up by the index, so on 7/1 I started a full index. The scheduled incremental index also continued to run.

At the completion of this indexing, the missing orders and lines were present in the index.

This morning about 8:30 a.m. I added a line to an existing order. I believe that may have been captured by the CDC Log processor at 08:50.

The index process then began at 10:21.

That build did not indicate that it picked up anything -

A search of the index does not find the newly entered order line.

Why isn’t this working???

Tired Tv Land GIF by TV Land Classic

With the assistance of ChatGPT, I belive I got to the bottom of this. First, I only thought that the incremental indexing wasn’t working at all since my test with an order failed. In reality it was working for any thing except Orders and ShipDtl.

The reason those tables weren’t working is because the CDC subscriber rules for those tables were missing. We replace some of the standard BAQ’s with custom BAQs. Apparently, depending on the order that you add the new BAQ and delete the old one, the rules for the table will be deleted.

Incidentally, in 2025.2.16, you can’t see the rules in CDC Subscriber Management and you can’t create new rules to replace the missing rules.

The best workaround to this is to get your custom search index configured with the queries you want, then save it as a new template. After you have the new template, delete the configured index and then recreate with your template.