Skip to main content
kavyashren650312
kavyashren650312
May 24, 2026
Solved

Unable to write to or delete from the source due to a data integrity violation.Error Details: (conn=141783) Duplicate entry '3' for key 'SURVEY_PROPERTY_ID'

  • May 24, 2026
  • 3 replies
  • 1 view

Hi,

I see below error while creating a record,

Unable to write to or delete from the source due to a data integrity violation.
Error Details: (conn=141783) Duplicate entry '3' for key 'SURVEY_PROPERTY_ID'

There is no key ""SURVEY_PROPERTY_ID" available in either DB or Record

The counter seems to increase every time I try to write to record. But always shows the same error.

Thanks in advance

Best answer by shubhama926776

There might be a unique index named SURVEY_PROPERTY_ID on your table (likely leftover from a dropped column or relationship).

Run SHOW INDEX FROM <table>;  You might see it. Drop that index, sync the record.

3 replies

harshas2775
harshas2775
May 25, 2026

Check if you have any triggers configured in the table that might be affecting this column in another table and causing this error

stefanhelzle0001
stefanhelzle0001
May 25, 2026

Depending on the data model and relations, you might have to also check other tables.

If you implemented additional DB-logic like triggers, constraints or foreign keys, you will have to investigate these as well.

shubhama926776
shubhama926776Answer
May 25, 2026

There might be a unique index named SURVEY_PROPERTY_ID on your table (likely leftover from a dropped column or relationship).

Run SHOW INDEX FROM <table>;  You might see it. Drop that index, sync the record.

    Terms & ConditionsAccessibility statement