Error with merge accounts

Dear,

When i try to merge two account, i've got the following error in the process log:

System.Data.SqlClient.SqlException (0x80131904): The DELETE statement conflicted with the REFERENCE constraint "FKYKBlN1O6UJiw8gMHsBSVNzLbjXA". The conflict occurred in database "legaldoc", table "dbo.Order", column 'UsrAdresseDeFacturationId'.

How can i correct it ?



Thank you,

Regards,

Nicolas

Like 0

Like

5 comments

Hello,

 

During the merge, one of the records is deleted. Seems like the one you try to remove has some value in UsrAdresseDeFacturationId that has some connection in other entities.

It is necessary to make sure your deleted record during the merge doesn't have any associated records that has reference to the value in UsrAdresseDeFacturationId.

 

Regards,

Dean

Hello Dean,

Thank you for the answer.

It looks like that i cann't merge my two accounts because there are orders using the Invoicing address.

So will it be impossible to merge the accounts ?

 

Hi Nicolas,

 

It is better to have a look into the issue directly on the website to prevent merging incorrect data and loosing it.

Please email the support team at support@creatio.com so that our team could have the access to the website and give you the exact solution.

 

Regards,

Dean

Hi LÉZORAY Nicolas Can you please tell me how you resolve the issue? Thanks, 

 

Hi Federico, the support solve the issue.

Since, no merge error

 

Show all comments