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 / Microsoft Dynamics CRM (Archived) / Generic SQL error: Col...
Microsoft Dynamics CRM (Archived)

Generic SQL error: Column name or number of supplied values does not match table definition

(0) ShareShare
ReportReport
Posted on by Community Member

Hi all, 

I am getting Generic SQL error when the workflow is trying to send email (from a workflow) on clicking a button. 

The error from the logs shows the following: 

Crm Exception: Message: Generic SQL error., ErrorCode: -2147204784, InnerException: System.Data.SqlClient.SqlException (0x80131904): Column name or number of supplied values does not match table definition.


The workflow basically expects an integer from a javascript and then sends an email (using the Send Email action in the workflow)

1112.PNG

I have searched online and there are a lot of Generic SQL error posts but could find a similar problem.

Any guidance is highly appreciated. 

*This post is locked for comments

I have the same question (0)
  • Mahendar Pal Profile Picture
    Mahendar Pal 45,095 on at

    Assuming you are using CRM on premise, did you try to run SQL profiler and check may be it will give you some more pointer.

  • Evandro Lopes Profile Picture
    Evandro Lopes 25 on at

    Hello Solago, did you were able to resolve this error?
    I'm with the same problem, but I don't use plugins or workflows. In my case these problema occours just when I try to change the owner from account or contact.

    <ErrorCode>-2147204784</ErrorCode>
    Sql error: 'Column name or number of supplied values does not match table definition.'

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans