You’re offline. This is a read only version of the page.
5
Hi guys,
with our customer in Dyn 2016 8.1 we have a generic SQL error when updating specific field of a custom entity.
Basically from the web interface I can update almost any field of my record but when I try to change either "subject" or "ownerid" I get the Generic SQL error.
I've enables the trace and I see that :
[2020-02-18 10:05:41.658] Process: w3wp |Organization:29aa4890-f7e3-42e2-aa33-82c7ffda86db |Thread: 41 |Category: Platform |User: 8dea3e93-0829-4ee2-bd44-e855ca801c17 |Level: Error |ReqId: 6ed9b98b-30fa-413c-807f-ea48aa2307fa | MessageProcessor.Execute ilOffset = 0x1EB
>MessageProcessor fail to process message 'Update' for 'gfi_demande_inscription'.
[2020-02-18 10:05:41.677] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread: 41 |Category: Platform |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId: 6ed9b98b-30fa-413c-807f-ea48aa2307fa | ExceptionConverter.ConvertMessageAndErrorCode ilOffset = 0x208
>System.Data.SqlClient.SqlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #C99B487D: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'r'.
>Invalid column name 's'.
>Invalid column name 'r'.
>Invalid column name 's'.
I really don't understand why I have invalid column name 'r' and 's' ? I don't have any property with this name and I don't see them in the database either
Does anyone have any idead how can I identify what is happening ?
I also get the same error when updating account entity from the API.
Thanks
Generic SQL Error is very tricky to resolved. But you can try to deactivated your customization 1 by 1 to check which customization that cause the error. Can be from plugin, can be from workflow. Good luck.
Share
Report
All responses (
Answers (
