I have created some custom BAQs to feed production BAQ reports that I run for many filtered customers. These smaller reports all take a while to run, but they eventually spit out a report after half an hour or so. The largest of these reports comprises over a thousand parts. In Pilot, I can run the…

Nate, 2-3 minutes of run time on a BAQ is a long time. If you haven’t already done so, I’d suggest looking at the query for possible optimizations. What I see a lot are joins in the top query where the subsidiary tables generate a lot of overhead. Strategic table criteria and subqueries can make a…

Long Running Report Fails after 8+ hours

Epicor ERP 10

bordway (Bruce Ordway) April 10, 2020, 2:25pm 2

Error in system monitor? Any useful clues in the details?

Wonder if it is a problem in SSRS?
Maybe check into logging… if you haven’t already?