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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Error when qualifying ...
Customer experience | Sales, Customer Insights,...
Suggested Answer

Error when qualifying lead

(0) ShareShare
ReportReport
Posted on by TWS - PVB 95

Hello,

Since a few days it seems that qualifying some leads results in an SQL error. Some leads don't have a problem and can be qualified, others still give very generic SQL error :

{"ActivityId":"7174342d-f360-443e-9196-8990fabff7f1","errorCode":2147762512,"message":" Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 547","stacktrace":null,"Timestamp":1609325972543}

Any ideas ?

Thanks !

Peter

I have the same question (0)
  • Suggested answer
    Ricardo Gimenez Profile Picture
    Ricardo Gimenez Microsoft Employee on at

    Hi Peter, 

    The error does not say too much and since qualifying process is a little complex, I suggest to you find compare the record that can be qualified and one that cannot. Check the following points:

    * A contact or account is being created during the qualification?

    * There are values mapped between Lead and Opportunity entities that could invoke a business rule from Opportunity side?

    * There are plugins enabled for Lead or Opportunity entities?

    Since this is a SQL generic error, there are a lot of possibly causes. Also, if you are using a OnPremise environment, collect a verbose trace. If you don't identify something relevant, I suggest to open a support case.

    Thanks,

  • TWS - PVB Profile Picture
    TWS - PVB 95 on at

    Hi Ricardo,

    Thanks for your response !

    We finally found out that there was a rule on contacts that initiates 2 fields. Once we disabled the rule, qualification worked again. This now leads us to the quesiton : why does the rules crashes when qualification creates a contact ?

    Kind regards,

    Peter

  • Suggested answer
    Ricardo Gimenez Profile Picture
    Ricardo Gimenez Microsoft Employee on at

    Hi Peter,

    Good to know that your problem is solved. Regarding your last question, since error message does not has too much details, is hard to say what is the cause. My recommendation is try to rebuild the rules and check all conditions.

    Thanks,

  • TWS - PVB Profile Picture
    TWS - PVB 95 on at

    Hi Ricardo,

    Thanks for your answer. Microsoft is wroking on this issue now.

    Kind regards,

    Peter

  • TWS - PVB Profile Picture
    TWS - PVB 95 on at

    Hi Ricardo,

    Thanks for your answer. Microsoft is working on this issue now.

    Kind regards,

    Peter

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 213 Super User 2026 Season 1

#2
CU11031447-0 Profile Picture

CU11031447-0 100

#3
NeerajPawar Profile Picture

NeerajPawar 71

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans