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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Generic SQL error -214...
Power Apps - Microsoft Dataverse
Answered

Generic SQL error -2147204784

(0) ShareShare
ReportReport
Posted on by Kesh 230

Hi, I encouter an error in ly canvas apps:

An error has occured on the server.

Answer of the serveur: Fail of "entity name": Sql error: Generic SQL error.CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 421

Capture.PNG 

 

I don't understand why it appeared today, nothing has changed as I know.

I don't see dataloss but I can't be sure.

 

That entity has been called many times and I use IfError(     ;notify()) function on each stage but no notification is triggered. I can't reproduce that error.

 

Please help me.

Kind regards

Categories:
Entities
Tables
Microsoft Dataverse
I have the same question (0)
  • Kesh Profile Picture
    Kesh 230 on at
    Re: Generic SQL error -2147204784

    Hi everybody, can someone help me?

    I'm very in trouble...

    Kind regards

  • Verified answer
    EricRegnier Profile Picture
    EricRegnier 8,716 Most Valuable Professional on at
    Re: Generic SQL error -2147204784

    Hi @Kesh,

    Not sure if you solved this issue yet. Is this only happening in your canvas app or even if you browse the data in make.powerapps.com -> Data -> Tables?

    The top 2 common reasons for generic SQL Server errors are:

    1. Table is locked by either publishing in progress by developers or Microsoft via platform updates, or transactions not committed yet
    2. Query timed out. You'll need to somehow optimize your query; reduce columns, apply filtering, etc. We can help if you paste it here.

    If you still can't get it fixed, suggest to submit a Microsoft support ticket at: https://admin.powerplatform.microsoft.com/support

    Hope this helps!

  • Verified answer
    Fubar Profile Picture
    Fubar 8,230 Super User 2025 Season 2 on at
    Re: Generic SQL error -2147204784

    Unfortunately the generic bit is so generic that it doesn't help much in solving the problem and you will see it on a large number of types of failures, the 421 may indicate something with your query where you are possibly trying to do a DISTINCT on something that that is not comparable.

  • Kesh Profile Picture
    Kesh 230 on at
    Re: Generic SQL error -2147204784

    thank you for your help, I will try to find a solution

  • jdfeemster Profile Picture
    jdfeemster 10 on at
    Re: Generic SQL error -2147204784

    I am seeing this as a warning when Importing a solution that was Exported from another developer environment. The associated xml log file identifies an entity relationship by name and a "80040203" error code whose text is "AttributeId is null." I am also seeing this same text reported by the import step of an Azure pipeline run failure when pulling source code from a GitHub repository, as in "The reason given was: AttributeId is null." Unfortunately that pipeline error log is even more vague and useless in identifying the problem.

    The Powerapp Export/Import process flags a warning message while the Azure pipeline process fails during the Import step - both report the "AttributeId is null" text while one associates it with an SQL query that may be due to a MultiTargetLookup request that might reference an entity relationship.


    Anyone know how to identify which SQL script is throwing this warning message?

  • EricRegnier Profile Picture
    EricRegnier 8,716 Most Valuable Professional on at
    Re: Generic SQL error -2147204784

    Hey @jdfeemster, not sure if you say my reply in your previous post: https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Multiple-developers-sharing-work-on-multiple-Solutions-using-ALM/m-p/2133382#M29538? Cheers 

  • Suggested answer
    TrevorMorrice Profile Picture
    TrevorMorrice 77 on at
    Generic SQL error -2147204784
    I came across this while having the same issue, 
    I found out that I was setting the variable somewhere else with a different schema.
    So it was failing to load the record into the same variable. 
    I used the search function to find all the times i set the variable and made sure they app matched schema. 
     

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

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

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 686 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 433 Super User 2025 Season 2

#3
wolenberg_ Profile Picture

wolenberg_ 266 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans