SBX - Search With Button

SBX - Forum Post Title

CRM 2011 Webservice: Generic SQL Error

Microsoft Dynamics CRM Forum

user123 asked a question on 11 Dec 2016 1:51 AM
My Badges

Question Status

Verified

Hello

I have a code which will create a contact record in CRM 2011. For some reason it throws a Generic SQL error. 

I have checked for the below:

- Length of all the fields that are being updated in Contact record

- Attributes schema name 

- Lookup records

I am in need of some help please?

Thanks

Arj

Reply
Abed Haniyah responded on 11 Dec 2016 11:09 AM
My Badges
Suggested Answer
Nithya Gopinath responded on 11 Dec 2016 11:29 PM
My Badges
Suggested Answer
user123 responded on 12 Dec 2016 6:08 AM
My Badges
Verified Answer

Thanks Nithya and Abed for the information shared.

I have figured out the reason that was causing the issue.

There was another plugin which was registered on the create of Contact record that updates the email address.

So this web service and Plugin both were trying to update the email address field in database hence it causes double insert and resulted in this error.

I tried to unregister the plugin (luckily that was a test plugin) and this issue was sorted.

Regards

Arjun

Reply
Pawel Gradecki responded on 12 Dec 2016 6:16 AM
My Badges
Suggested Answer

You should enable Tracing in CRM and check the logs for more meaningful error.

Reply
Nithya Gopinath responded on 12 Dec 2016 10:39 PM
My Badges

If your case is resolved, please mark the thread as verified.

Reply
user123 responded on 12 Dec 2016 6:08 AM
My Badges
Verified Answer

Thanks Nithya and Abed for the information shared.

I have figured out the reason that was causing the issue.

There was another plugin which was registered on the create of Contact record that updates the email address.

So this web service and Plugin both were trying to update the email address field in database hence it causes double insert and resulted in this error.

I tried to unregister the plugin (luckily that was a test plugin) and this issue was sorted.

Regards

Arjun

Reply
Abed Haniyah responded on 11 Dec 2016 11:09 AM
My Badges
Suggested Answer
Nithya Gopinath responded on 11 Dec 2016 11:29 PM
My Badges
Suggested Answer
Pawel Gradecki responded on 12 Dec 2016 6:16 AM
My Badges
Suggested Answer

You should enable Tracing in CRM and check the logs for more meaningful error.

Reply

SBX - Two Col Forum

SBX - Migrated JS