BAQ execution timeout expired

[cfinley (Chance Finley)]

RDD BAQ Report timeout

This suggestion ultimately solved the problem of the long Query runtime. BAQ with date range of 06/01/2020 - 06/30/2020. 25 records that represent all the days we shipped something. With 8 inline subquery calculated fields. Run without any company criteria. Non Cross Company BAQ 13.683 minutes Run with company hardcoded company = ‘abcdef’ on all tables marked with 1 including inline subqueries 3.45 minutes Run with BAQ Special Constant of CurComp on all tables marked with a 1 including inl…

If you check out the thread within the thread, there is a discussion about problems with the BAQ Engine in all versions prior to version 10.2.700. Weird performance results throughout users experiences