Skip to content
English
  • There are no suggestions because the search field is empty.

Fix: “INSERT statement conflicted with the FOREIGN KEY constraint ‘LogcontactMethod’” Error

What does this error mean?

This error occurs when XR attempts to push a contact activity into EOH, but the Contact Method being used does not exist in the EOH CRM Contact Log master list.

Because the system uses a database relationship (foreign key), EOH will reject any contact log that references a Contact Method it does not recognise "API PUSH".

Common error message:

The INSERT statement conflicted with the FOREIGN KEY constraint 'LogcontactMethod'… column 'CML'.


Why does this happen?

This usually occurs when:

  • A new Contact Method was created or used in XR
    but

  • That same Contact Method has not been set up in EOH

XR can send the data, but EOH blocks it because the method does not exist in its master configuration.


How to Fix It

You can resolve this immediately by adding the missing Contact Method in EOH.

Step 1 — Go to CRM Contact Method Master

Navigate to:

Home → Masters → Main Masters → CRM Contact Method


Step 2 — Add the Missing Contact Method

  1. Click Add Contact Method

  2. Enter:

    • Description — "API PUSH"

    • Unit of Work —  1 UNIT

    • Status — Set to ACTIVE

  3. Save the record

 


Step 4 — Retry the Push

Return to XR and retry the action.
The contact log will now successfully insert into EOH..