Dashboard sometimes doesn't work for specific user account

Kinetic ERP
1

I’m stumped. I have a PO dashboard that works when logged in as me flawlessly. But I have one user, that when I log in as him, the dashboard does not work sometimes. After entering the parameters, it spins for ~45 seconds, then shows a blank screen. But only with his account, regardless of which client computer used.

I tried making his account security manager, and his account can run the BAQ without issue. But even when he has security manager permissions (which shouldn’t affect anything), the dashboard still doesn’t work for his account. I’ve tried redeploying the dashboard.

Any ideas??

2

Does the user have a workforce? At my last job i would sometimes create a workforce to diagnose something, and forget to delete it and get frustrated when i couldn’t view a customer.

3

Yes user has a workforce. So does my primary account that I use when working on our system. How does the workforce affect a dashboard though?

4

I think i remembered incorrectly. I think its when your an authorized user for someone, that something to do with territories.

However the fact that the BAQ takes 45 seconds to load, seems characteristically different from this problem.

P.S. new job is letting my Epicor knowledge fade lol

5

with his user can you view a supplier that is supposed to appear in that BAQ? that would disprove my statement if you can see the supplier in supplier maintenance

6

Yes he can right click on the supplier number and see supplier tracker.

7

Well it may have something to do with timing out, though not sure why on his account.

I noticed this dumbed down query is running VERY slow if I’m displaying UD columns in the BAQ results:
image

select 
	[PORel].[PONum] as [PORel_PONum],
	[PORel].[POLine] as [PORel_POLine],
	[PORel].[PORelNum] as [PORel_PORelNum],
	[PODetail].[PartNum] as [PODetail_PartNum],
	[Part].[PartDescription] as [Part_PartDescription],
	[Part].[ShortChar09] as [Part_ShortChar09]  /*This makes it run 20x slower!*/
from Erp.PORel as PORel
inner join Erp.PODetail as PODetail on 
	PODetail.Company = PORel.Company
	and PODetail.PONum = PORel.PONUM
	and PODetail.POLine = PORel.POLine
left outer join Erp.Part as Part on 
	PODetail.Company = Part.Company
	and PODetail.PartNum = Part.PartNum
where (PORel.Company = @CompanyID  and PORel.JobNum = @JobNumber)

If I include a UD field in the filtered results, it takes 30x longer (eg 11 seconds for ~700 rows instead of 0.3). If I don’t filter the results on jobnum, BAQ pulls 10000 rows quickly.
Jobnum is not an indexed column on PORel. But it shouldn’t matter??
When I run the equivalent query in SQL (joining Part_UD on Part), it is very fast…

Anyone see anything here? Thanks!

8

Don’t see anything wrong, but is there any performance increase if you remove the company links?

Wonder what the results would be if you had just the part table and nothing else, and if there was performance diff with adding that field vs a second

9

I found that if I put the Part table in a subquery, and then referenced that from the main query, it resolved the issue. Really weird. Half my day. :upside_down_face:
image

image
image823×347 12.7 KB