Yesterday, I got this error coming up to my face: “ Column ‘UserId’ in Table ‘UserActivity’ contains a duplicate value '159FF9DCDA02493C50737375F7C2CA22 '. It says that I am not allowed to create many-to-one relationship on columns to one side. What is exactly the problem?
Hi there,
You may want to take a look at “Manage Relationships” on the Home tab, it may have created relationships that shouldn’t be there. Delete the relationship that is not needed, publish the changes, and see if that fixes the problem.
error indicates you have duplicate values in the column that is used as a primary key for the relationship. You should also check that there are no duplicates.
