Enterprise search Index error

Epicor ERP 10
1

I’m trying to re-index my DB for enterprise search and I’m running into one major error while it’s running the zES_Parttran baq.

ErrorExecution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

The wait operation timed out

. Stack Trace ->   at Epicor.Search.BOAccess.DynamicQuery.AssertErrorTableClear(DataSet dataset)

   at Epicor.Search.SqlIndexer.ReadSourceDataUsingBAQ(IndexJob theJob, IndexJobBAQ indexJobBAQ, List`1 fieldList)

   at Epicor.Search.SqlIndexer.IndexTheJob(IndexJob theJob, SqlConnection cnx)

image
image822×701 16 KB

I’ve already extended the default timeout from 300 to 600 and it’s still erroring out. Is there any way to check this BAQ and see why it could be timing out like this? I know if I open it in designer its only going to return 10000 records so that’s not a good example as to what my actual DB has.

For what it’s worth, this is what I get when run in BAQ designer time wise for 10000 rows.

Query returned 10000 row(s).
Query has no more records to return.
Query execution total time: 17610.4979 ms.