CRM Dynamics 2015 (on-premise) - Inserting Contact via SQL, error when trying to delete via CRM

(0) Share

Report

Posted on by Community Member

Hi all

I wondered if you could assist.

I am trying to automate the addition of contacts into Dynamics CRM via a web form and have written a SP in SQL in order to do this. It works, but when I come to delete the contact via Dynamics CRM, it gives an error that "Integer Value Out Of Range". I have the option to download the log file which provides the following information:

"A validation error occurred. The value of 'membercount' on record of type 'list' is outside the valid range."

Please could someone shed some light on what I am perhaps doing wrong?

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Community Member on at

Like (0)

Report

RE: CRM Dynamics 2015 (on-premise) - Inserting Contact via SQL, error when trying to delete via CRM

Thank you for the suggestions.

I have answered my own question in the end.

In case anyone is wondering, as I was not only importing a Contact, but also adding this new Contact straight to a Marketing List, the error was occurring when trying to delete Contact via Dynamics because the "MemberCount" of the relevant Marketing List was out of sync (had managed to creep down to 0) so using my SQL stored procedure I am now updating the "MemberCount" field by 1, as and when a new Contact is added and then added to the Marketing List.

Was this reply helpful? Yes No
Rajkumar Rajaraman on at

Like (0)

Report

RE: CRM Dynamics 2015 (on-premise) - Inserting Contact via SQL, error when trying to delete via CRM

Best way as using CRM API

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: CRM Dynamics 2015 (on-premise) - Inserting Contact via SQL, error when trying to delete via CRM

Appreciate that this isn't supported.

Just hoping somebody could assist with a possible workaround for this.

Was this reply helpful? Yes No
Royal King 27,686 on at

Like (0)

Report

RE: CRM Dynamics 2015 (on-premise) - Inserting Contact via SQL, error when trying to delete via CRM

Inserting any record to crm via sql is not supported and if you do system may not work as expected. Stop inserting records using sql sp and use CRM API to insert contact to crm.

Was this reply helpful? Yes No