Customer Engagement & Dynamics CRM Forum

Expand all | Collapse all

Disabling Recently Viewed Items

  • 1.  Disabling Recently Viewed Items

    GOLD CONTRIBUTOR
    Posted Jan 07, 2020 12:16 PM
    @Dhivya Sivasankkar
    @Michael Ochs
    @Aiden Kaskela
    Has anyone ever disabled the "Recently Viewed Items" functionality in CRM, either system-wide or for a particular user?
    We have a custom import provided by a vendor and for some reason there's a lot of blocking in the DB b/c it's trying to update the Recently Viewed items for the "SYSTEM" user.  The import is creating Person and Opportunity records, so my best guess is that creating these records is causing an internal plugin to update that Recently Viewed list automatically.
    We're on 8.2 on-prem.

    The update statement is:
    update [UserEntityUISettingsBase] set [RecentlyViewedXml]=@RecentlyViewedXml0 where ([UserEntityUISettingsId] = @UserEntityUISettingsId0)​

    For kicks, I tried clearing out that user's Recently Viewed items in case it was too large, but that didn't make a difference.

    So anyone ever disable that functionality altogether (temporarily), or at least for a specific user like SYSTEM?
    Thanks!
    ​​

    ------------------------------
    Mike Power
    Senior CRM Solutions Developer
    American University
    Washington DC
    ------------------------------
    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 2.  RE: Disabling Recently Viewed Items

    Posted 16 days ago
    Hi Mark, did you find a solution for this?


    ------------------------------
    Ville Rantala
    Microsoft Dynamics CRM Consultant - Web Developer
    Solutions at custom
    Bogot
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 3.  RE: Disabling Recently Viewed Items

    GOLD CONTRIBUTOR
    Posted 16 days ago
    Unfortunately no

    ------------------------------
    Mike Power
    Senior CRM Solutions Developer
    American University
    Washington DC
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 4.  RE: Disabling Recently Viewed Items

    GOLD CONTRIBUTOR
    Posted 15 days ago

    Mike,

    We had a similar issue with CRM 8.2.2.112 on prem. The loading of forms was excruciatingly slow.

    Turns out that this is a known bug in this version. https://community.dynamics.com/crm/f/117/t/277900

    The issue is that the recently Viewed items (xml) did not have a limitation of size and some had up to 300k for some entities.

    There is a cRM solution to clear the list  for a specific user / entity

    https://community.dynamics.com/crm/b/crminthefield/posts/dynamics-365-for-customer-engagement-slow-form-loads-for-one-user

     

    CAVEAT: This did not really work well because the data is cached in IIS and it will repopulate the cache in the browser and vice versa I believe.

    If you try that, I would suggest to

    • Run the solution for the entities you wish
    • Recycle the crmAppPool  <-- this is key

     

    Anyway we wanted to avoid manual work, so our final solution is the following

    • Write a windows service that does the following
      • Query all the recentlyViewedXml for which the size is above 30K. (for all users, all entities)
      • For each of those, delete all the recentlyViews using the sdk. Caution: one has to  call the sdk as the users of the recentlyViews => we need to impersonate.
    • Run the service once a week (Friday evening)
      • The idea is that the appPool resets every 29 hours (default) and the users will typically not use crm during the weekend. This gives a chance to reset the data and make sure that the cache is cleared by the recycle appPool.
      • An alternative is to recycle manually after running the service

     

    I know it is cumbersome, but it took us a lot of time to figure the cause of the issue and then a solution…. But our users were very upset when they had the issues.

    This has been running for 2 years now and we haven't had any complaints anymore.

    Hope this helps



    ------------------------------
    Christian J. Betrisey
    Software Developer
    American College of Emergency Physicians
    Irving TX
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 5.  RE: Disabling Recently Viewed Items

    GOLD CONTRIBUTOR
    Posted 15 days ago
    Thanks Christian!  Hopefully we won't get plagued by this again... we upgraded this past summer to v9 so hopefully that resolved it if it was specific to 8.2.  Our heavy period for imports (which was oddly when we encountered this the most) will come this winter in late Dec and mid January, so we'll see if it comes back with a vengeance or not :)

    Thanks again for your time

    ------------------------------
    Mike Power
    Senior CRM Solutions Developer
    American University
    Washington DC
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


If you've found this thread useful, dive deeper into User Group community content by role