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) / 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

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