Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign

[googler]

Hi,
I get the message "Failed to enable constraints. One or more rows
contain values violating non-null, unique, or foreign-key constraints."

All the keys are intact and this problem pops up when there is a
dataset.merge(dataset).

The has errors gives false and the geterrors returns nothing.

can some one throw some light?
Thanks
Sri

 

[googler]

Solved it. How ever, it is not easy to zero down on the problem.

1. Check the tables in all the datasets
2. check the stored procs
3. run the stored procs.. In most cases, the triggers behind the tables
or the stored procs inside the stored procs are the culprits.