cancel
Showing results for 
Search instead for 
Did you mean: 

CRM 2011: Generic SQL Error (Data-Import)

Author Name: Daniel René Thul

We have created a post-create (synchron) plugin for the entity create. The plugin updates several attributes of the just created account, based on some rules. Everything works fine but when we import data via import-wizard a generic SQL ist thrown:

Plugin Trace:

[SomeNamespace.Plugins: SomeNamespace.Plugins.PostAccountCreateUpdate]
[364f13f8-79e3-e011-9c12-08002760bed5: PostAccountCreateUpdate]

Entered SomeNamespace.Plugins.PostAccountCreateUpdate.Execute(), Correlation Id: d4a1fb42-b3ca-4ce0-b2c2-e40df4dc6d20, Initiating User: a8d0ee97-97ee-e011-8d06-1cc1de6d5b2d

SomeNamespace.Plugins.PostAccountCreateUpdate is firing for Entity: account, Message: Create, Correlation Id: d4a1fb42-b3ca-4ce0-b2c2-e40df4dc6d20, Initiating User: a8d0ee97-97ee-e011-8d06-1cc1de6d5b2d

Generic SQL error., Correlation Id: d4a1fb42-b3ca-4ce0-b2c2-e40df4dc6d20, Initiating User: a8d0ee97-97ee-e011-8d06-1cc1de6d5b2d

Error Message:

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Generic SQL error.Detail:

-2147220891


OperationStatus
0


Generic SQL error.
2011-10-05T16:15:14.1062371Z


[SomeNamespace.Plugins: SomeNamespace.Plugins.PostAccountCreateUpdate]
[364f13f8-79e3-e011-9c12-08002760bed5: PostAccountCreateUpdate]

Entered SomeNamespace.Plugins.PostAccountCreateUpdate.Execute(), Correlation Id: d4a1fb42-b3ca-4ce0-b2c2-e40df4dc6d20, Initiating User: a8d0ee97-97ee-e011-8d06-1cc1de6d5b2d
SomeNamespace.Plugins.PostAccountCreateUpdate is firing for Entity: account, Message: Create, Correlation Id: d4a1fb42-b3ca-4ce0-b2c2-e40df4dc6d20, Initiating User: a8d0ee97-97ee-e011-8d06-1cc1de6d5b2d
Generic SQL error., Correlation Id: d4a1fb42-b3ca-4ce0-b2c2-e40df4dc6d20, Initiating User: a8d0ee97-97ee-e011-8d06-1cc1de6d5b2d



This is not a bug in the plugin-code. All unit tets work fine, only when importing account this error occures.

Regards,

Daniel Thul

Status: Under Review
Comments
Level: Powered On
Status changed to: Under Review
 
Level: Powered On
Hi Daniel, If you have not done so already I would suggest opening a support case to look into this issue further. This site is more for suggestions for future releases. Thanks Dynamics CRM Team