Here’s what we have:
We have a multi-tab/multi-query dashboard. The user can see the tab but no data will populate while others with the same security groups can. At first, I thought it was tied to the application so I logged in as me on the user’s computer and it was not an issue. I also log in as the user on another machine and it has the same issue. Additionally, I deleted the user AppData but still does not work. So I think it’s something tied to his user account. The dashboard does not have any security that I can tell. Anything else I need to check?
Any chance you set that user, specifically, to Disallow on any of the applicable menu items?
What about field security?
Any logs show up on the server either in Event Viewer or the app server log?
Forgot to mention that this was working sometime early last week.
I checked the event viewer but did not see anything there which I don’t think there will be an entry since it’s not throwing an error. Server logs didn’t show anything either.
You deleted the AppData, but what about clearing the user’s cache (ProgramData), purging personalizations, VPN reset (if remote), or the ole catch-all reboot the computer?
Is the customer table in the query? Do you have any territory security setting that can mess things up? Once a user is added as an authorized user to any employee record, then territory security kicks in.
The Dashboard/Query in question here is related to RMAs so I don’t know if territory security setting would matter. We also do not have any territory setting set up. This is really bizarre and I am almost sure that is user account related. Is there some user data I can refresh or delete in the server side to clear things up?
@JuyTWG
Agree with you that this could be user account security. Check if any access change has happened on his account since the problem hit. Secondly, check the Query and find out the fields not only in BAQ but also the neighbourhood. For example, RMAHead has CustNum, and Customer Table has TerritoryID. Additionally, compare RoleCode field in the User Acct Maint. for the troubled user with the untroubled ones and try to make it same for the check.
this was it. one of my colleagues recently added the user to workforce but didn’t have a role code. it was a combination of role code and the view all territories setting. we made the user’s setting the same as the other ones and everything is working now. thanks for all your suggestions.