web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / marketting list creati...
Microsoft Dynamics CRM (Archived)

marketting list creating error

(0) ShareShare
ReportReport
Posted on by KaanAkyalcin 30

Hi,

I work on dynamics crm 8.2 on premisse. The contact entity has over 10M records.

When i try to create a marketting list over 200K based contact , the browser are freezing.

How can i monitor the process?

*This post is locked for comments

I have the same question (0)
  • David Jennaway Profile Picture
    David Jennaway 14,065 on at

    That is a lot of records. You can increase various timeouts, see https://blogs.msdn.microsoft.com/crminthefield/2011/06/13/microsoft-dynamics-crm-timeout-settings/ 

    The article was written for CRM 4 / 2011, but the settings still apply for CRM 8.2

    If you can, it's worth trying to capture the SQL queries that are submitted, to see if you can add indexes that will optimise this. You can get the SQL queries either via verbose CRM tracing, or SQL trace, though in either case a lot of trace data gets generated if you do this during normal operation. If you could, I'd create a copy of the organisation database just to test this, and use SQL trace just on that database

  • KaanAkyalcin Profile Picture
    KaanAkyalcin 30 on at

    Hi David,

    I followed the three steps based on your advice.

    After below steps, i could create a list that has 2M records.

    1. I change the HttpRunTime value in web.config.

    2. I change the db timeout value in HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\MSCRM

    3. Finally, i change one of dynamics crm store procedures : p_AddMarketingListMembers

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans