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

Right click the table adapter and there is an option to delete the primary key(s). Then it worked.