One Specific user slow

(1) Share

Report

Posted on by JO-30091535-0

238

I have a very strange issue. I have one specific user experiencing slowness when opening records in one specific entity. Im running Dynamics 365 8.2 (on-prem). I tried the following:

Gave the slow user full system admin rights/role. Still slow.
Created a new user and gave the new user the same limited permissions as the slow user would normally have. The new user worked fine.

So the issue comes down to the specific user regardless of permissions. The slowness is both when opening records (requesting data from dynamics...) and saving records. The user doesn't have any slowness when opening records from other entities.

I'm puzzled...

*This post is locked for comments

I have the same question (0)

All responses (23)

Answers (0)

Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report

Hi There,

Did you check if this is a user specific issue or a system/browser specific issue.

ask user to login to other system ( where other user is fine) and go on from there. For a particular user -i doubt you can do much.

Was this reply helpful? Yes No
Suggested answer

Temmy Wahyu Raharjo 2,916 on at

Like (0)

Report

Where you feel if login using this user is more slower than others? When load form? If load form, try to inspect in F12 (IE) > Network. Try to compare with 'normal' user. If the traffic is different, it means there is customization that makes this user more slow than any others.

If there is no difference, have you try to used different device?

Was this reply helpful? Yes No
Suggested answer

Arpit Shrivastava 7,518 User Group Leader on at

Like (0)

Report

Hi,

Here is the checklist is given in below article. Pls check this, whether it fulfils on a particular user machine.

https://www.powerobjects.com/2010/04/16/optimizing-crm-performance/

Apart from this, pls also check whether any Antivirus installed on user machine creating an issue.

If my answer helped to resolve your issue, kindly verify it by clicking 'Yes'. It would be helpful to the other community members seeking to resolve a similar issue.

Cheers
Arpit
https://arpitmscrmhunt.blogspot.in

Was this reply helpful? Yes No
gdas 50,091 Moderator on at

Like (0)

Report

Hello ,

Have you checked the principle object access table in CRM database ? Sometimes when any specific user having multiple sharing or access this table having number of records check every time and slowing down CRM over time. You could try to remove the inactive records from this table.

Secondly could you please check is there any plugins or workflow is running in this particular user context .

Was this reply helpful? Yes No
JO-30091535-0 238 on at

Like (0)

Report

Thank you all for the response. First of all, just to add, the slow user is seeing the same results from all browsers and from all stations (inside or outside the network). The good users are always fine regardless of browser and regardless of station.

That said, Goutam, Is it still possible its the POA table? Is it save to manually delete these records from SQL? Is this script safe to run in Dynamics 365? Why is it only affecting one specific entity?

My current POA table is 1.2Gb and has 2,368,396 rows.

Was this reply helpful? Yes No
gdas 50,091 Moderator on at

Like (0)

Report

I am not sure for dynamics 365 but although it's not Microsoft recommended to change anything in the database level.Here is the scripts for dynamics crm 2011 you can try.

support.microsoft.com/.../how-to-control-principalobjectaccess-table-growth-in-microsoft-dynamic

By the way does the user having huge shared record ?

What about the request in fiddler you are getting when open particular form? Just to make sure which request is taking time you can easily get using fiddler.

So I would request you before doing any changes first check which request is taking time and then decide.

Was this reply helpful? Yes No
Suggested answer

pavanmanideep 1,331 on at

Like (0)

Report

Hi Joe,

In my previous project, we used to delete this POA table out of business hours or during weekend but for one of the on premise CRM 2011 application which got piled up due to more number of shares of the records. Total amount of time depends on the number of records you have in this table. Also better to take backup of the DB if something goes wrong before proceeding.

You can use the script provided by microsoft. Refer below post for inference.

https://community.dynamics.com/crm/f/117/t/215483

Mark this as verified if it helps...

Cheers,

PMDY

Was this reply helpful? Yes No
JO-30091535-0 238 on at

Like (0)

Report

I ran the script, but it zero rows affected. I can manually delete the records from the POA table, but i dont know its ramifications. The strange part is that i have a QA environment that's almost an identical copy to this server (from two months ago) and there its fine . I think ill have to take this the painul PSS route...

Was this reply helpful? Yes No
Suggested answer

JO-30091535-0 238 on at

Like (0)

Report

Hi,

This has been resolved. The issue was the RecentlyViewedXml field (column) in the "UserEntityUISettingsBase" table. It uses this field to store recently viewed record per entity. There's seemingly an issue in 8.2 with the way the field is populated due to cache or long browser sessions. The solution is to null the field of the entity in question, or all for that matter. I deleted all of them. The "UserEntityUISettingsBase" table defines the entity by the ObjectTypeCode number (a column in that table). If its a custom entity, then you would first need to retrieve the ObjectTypeCode, can be retreived in SQL or by using WebAPI. Here are the SQL commands

Retrieve ObjectTypeCode
SELECT * from EntityView ORDER BY Name

Retrieve a user GUID
select FullName, SystemUserId from SystemUser

Delete all RecentlyViewedXml for a specific user
update UserEntityUISettingsBase
set RecentlyViewedXml = null
where OwnerId = 'GUID'

Delete all RecentlyViewedXml for a specific user for the Case entity
update UserEntityUISettingsBase
set RecentlyViewedXml = null
where OwnerId = 'GUID' and ObjectTypeCode = 112

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hi JoeO,

We're experiencing the same issue with our 365 8.2 on-prem. After you ran your t-sql code, did the issue come back? Was this only affecting one user? Was it an out-of-the-box entity or a custom one? Any help is appreciated. Thank you kindly.

Was this reply helpful? Yes No