We have BAQs that work for a while, and then they start giving bad data. When can open a new baq and write it exactly as the original and get different data, but correct data. Anyone experience this before?

No, I haven’t seen this. What BAQs are you seeing these results in? Are they all custom BAQs? What kinds of data are coming back? What results do you expect and what are you getting?

These are custom BAQ. Some I wrote, most are form others. It really weird and intermittent. The data is right one moment, then a week or month later, its showing something way off. Rewrite it in a new BAQ, exactly the same, and get the correct data. Just weird. @Olga “bad data” to me is data tha…

I didn’t think to check that. Next time it happens, I will check and see. I am wanting to say yes, as it is built the exact same, graphically. But, you do have an excellent point.

Would a stale execution plan do this? Maybe on the next bad data issue add the option recompile to see if it saves rewriting.

Just yesterday saw an example related to @timshuwy 's comment. Wrote a very simple BAQ looking for where data was stored among a few tables, deleted one of the tables from the graphical view, and when looking at the SQL version still showed a join to the deleted table.

BAQ issue

Epicor ERP 10

timshuwy (Tim Shoemaker) October 7, 2022, 2:57pm 6

when you rewrite it, does the SQL version that shows on the front page look exactly the same?

Topic		Replies	Views
BAQ Timeout Epicor ERP 10	2	800	December 1, 2017
Strange, Poor BAQ Performance? Epicor ERP 10 baq	26	3627	August 4, 2021
BAQs stopped working Epicor ERP 9	3	912	August 3, 2018
Baq timeout for some users Epicor ERP 10 e10 , epicor , baq , dashboard	8	1407	August 14, 2023
Some of our Epicor users experience extreme slow downs on loading a BAQ through a customization but when using a different user ID on the same computer, its fast! Epicor ERP 10 e10	8	1020	July 10, 2023

BAQ issue

Related topics