Getting duplicate keys error when adding new user to database?

Getting duplicate keys error when adding new user to database?

Duplicate keys could mean there is a duplicate table in the database. An example is a remnant in the data source view from a table being renamed then added back again into the system model. You can run the below queries together in the database to find the duplicate table. 

SELECT e.n.value('(@ID)[1]', 'varchar(max)') as ID,
          e.n.value('declare namespace dm="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling"; (dm:Name/text())[1]', 'varchar(max)') as Entity,
          e.n.value('declare namespace dm="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling"; (dm:Table/@Name)[1]', 'varchar(max)') as Source
FROM ( SELECT cast (content as xml) as Content  FROM SECUREDITEM WHERE path = '/DataModels/SystemModel' ) m
CROSS APPLY  m.[Content].nodes('declare namespace dm="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling";
                     /dm:SemanticModel/dm:Entities/dm:EntityFolder/dm:Entities/dm:Entity') AS e(n)
ORDER BY SOURCE

SELECT e.n.value('(@name)[1]', 'varchar(max)') as Name,
          e.n.value('declare namespace msprop="urn:schemas-microsoft-com:xml-msprop"; (@msprop:DbTableName)[1]', 'varchar(max)') as DbTable
FROM ( SELECT cast (content as xml) as Content  FROM SECUREDITEM WHERE path = '/DataModels/SystemModel' ) m
                     /dm:SemanticModel/dsv:DataSourceView/dsv:Schema/xs:schema/xs:element/xs:complexType/xs:choice/xs:element') AS e(n)
order by DbTable