Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
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:
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.
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.
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?
Here is the checklist is given in below article. Pls check this, whether it fulfils on a particular user machine.
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. CheersArpithttps://arpitmscrmhunt.blogspot.in
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 .
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.
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.
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.
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.
Mark this as verified if it helps...
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...
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 ObjectTypeCodeSELECT * from EntityView ORDER BY Name
Retrieve a user GUIDselect FullName, SystemUserId from SystemUser
Delete all RecentlyViewedXml for a specific userupdate UserEntityUISettingsBaseset RecentlyViewedXml = nullwhere OwnerId = 'GUID'
Delete all RecentlyViewedXml for a specific user for the Case entityupdate UserEntityUISettingsBaseset RecentlyViewedXml = nullwhere OwnerId = 'GUID' and ObjectTypeCode = 112
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.
We also have this issue and trid the cleanup of the RecentlyViewed-Xml. Unfortunately, this did not resolve the issue. AS a matter of fact, the list of recently viewed records is one of the few items on the screen that is allready loaded during the very waiting time we experience to load the rest of the data record.
We identified the initial GET Request to be the culprit, but as for now have not found a way to speed things up :/
Were you able to identify the why the GET is the culprit? We are experiencing the same issues with a small group of users.
Same issue with a customer with one user very slow to load Accounts and Contacts (D365 8.2 prem). Have checked for plugins, business rules and steps on these entities - but none registered on the entities in read-mode. No custom views or large field sets on pages either. I got the user to use a different computer and browser but still slow. Also ruled out CRM permissions being a factor.
Also looked at the usage history XML entity for user, nothing untoward. Don't want to adjust the POA table as I'm reluctant to run SQL against the DB.
Ran the SQL profiler, nothing notable there, same lack of info in the CRM trace logs.
Am a bit baffled by this one. Anyone been in touch with Microsoft re: this issue yet? Might get a ticket opened myself.
My group of users of about 20 are only experiencing slow "save" and "resolve" in the case entity......are your users experiencing the same?
Just to add a note. The key to this is to clear the browser cache "prior" to clearing the table, else it repopulates when opening the browser and the issue is never resolved. I found a useful solution (attached) which allows the user to clear the table. My users have been using it and it works fine. I cant remember where i found it
Business Applications communities