Enterprise User violates a uniqueness constraint on loginName

[Jimmy T]

I am at the step “Recreate the development database” of “PUB-DEV V9 DRAFT / Learning Center / Business model fundamentals / Derived associations”. When I run the Data Load Tool, I get the attached output; I don’t know how to fix the exceptions at the end (I think the root error is Enterprise User violates a uniqueness constraint on loginName):

 

Thanks.

 

 

0

Attachments:

You must be logged in to view attached files.

[Trevor Ball]

I consulted with Johnny, who suspects that somehow the user was created in the DefaultRelational data source but not the ECR data source, resulting in RemoteUser loginName clashing with an existing record.

We recommend doing recreate * (i.e. Data Load tool->recreate->*) on the environment to resolve this.

0

[Community Manager]

Jimmy, also please make sure when doing the recreate in the data load tool you are select * in the data source drop downs.

You want to recreate all datasources everytime, if you do a recreate.

 

0

[Jimmy T]

Thanks. Yes, you are both right, the issue was doing a recreate with *. The tutorial says to run recreate with DefaultRelationalDatabase instead of *, but that’s what was causing the issue.

0

[Author]

Posts