This one is odd. We did an upgrade from 10.2.400 to 10.2.700 and now this one user can’t run a BAQ that he was able to run before. Other people CAN run it (myself included). We tried looking at security, temporarily giving him security manager access so he could run the BAQ directly (normally it’…

if you have CRM, then the person running the BAQ will have different results depending on their assigned workforce ID. This is because CRM adds additional filters to every query when the Customer (and/or OrderHed?) tables are on the query. This is all done in the name of SalesPerson Security. SO, …

We do have some people with a CRM license and some that don’t have it. The only work force ID they have access to is a shared one with all territories. [image] It turns out the other debt person is also running into this issue though. Friday we were on 10.2.400 and they were able to run it. We…

Ok, we have narrowed it down further. The issue is that it’s cross company. When we uncheck it, it works for the current company. Yet the people running the report DO have access to the companies involved. I’m thinking I may have to open a case with Epicor support. It’s not JUST that I don’t t…

I just looked at your first screen shot. It’s a timeout issue. The security stuff that Epicor adds to the BAQ can be a drag on the BAQ. When you uncheck cross company, it effectively reduces the amount of data coming back. If you add that, but filter something else down, it could probably work. The…

Thanks for the reply :slight_smile: The problem is that when I run it, or other people in IT (besides our boss) run it, it comes back very quickly. 247ms this last time. So why is it timing out only for them? [image]

Could be a cache thing. In the BAQ try going to the execution settings, add a setting, like shown and see if it fixes it. [image] [image]

If you remove the OrderBy’s, does the BAQ run for those who it times out for? You could then apply the ordering in the RDL

@MLamkin If you add it to a dashboard it won’t time out. Won’t go any faster, but should finish. Curious why you have any users that are able to run BAQs especially updatable.

Actually, it IS in a dashboard and times out. I just had them test the BAQ directly to make sure that was the issue. I was able to fix it finally, I had to bump the execution settings QueryTimeoutValue up considerably. We’ve had to do that before, but that was when the timeout was bad overall, …

@MLamkin Glad you got it working. I wonder if @timshuwy nugget on OrderHed and Company from here applies to this baq. [image] Improving BAQ Performance ERP 10 The reason for this is that you are bypassing all the Epicor Logic (that may be ok, but keep that in mind) Custo…

One user can't run an updatable BAQ

Epicor ERP 10

gpayne (Greg Payne) September 1, 2021, 1:53am 14

@MLamkin Glad you got it working. I wonder if @timshuwy nugget on OrderHed and Company from here applies to this baq.

Topic		Replies	Views
BAQ Execution Epicor ERP 10	15	5728	March 10, 2020
10.2.100 Updatable BAQ timeout; Works in 10.1.500.11 Epicor ERP 10	8	876	March 21, 2018
Improving BAQ Performance Epicor ERP 10 e10 , baq	53	16840	November 27, 2024
BAQ Timeout for Simple Query Epicor ERP 10 sql , baq	17	3579	May 17, 2019
Strange, Poor BAQ Performance? Epicor ERP 10 baq	26	3670	August 4, 2021

One user can't run an updatable BAQ

Related topics