Recently, I’ve been working on Sitecore commerce project. In the post below, I’m going to share the experience about how I troubleshoot the issue and get it solved eventually.
The issue I encountered in creating a commerce user. customerServiceProvider “createUser” throws an exception
“An element with the specified key already exists.”, however the commerce user and sitecore user were successfully created. So WHY?
The initial suspicion was there are some duplications in the database. so I double checked UserObject table, the Addresses table (because I also add billing address and shipping address for the user), as well as the aspnet_Users table in Core database. Unfortunately they all looks clean and right, no duplications.
Then I thought that maybe there are some other tables gets updated while creating a new user, so I opened the “SQL Server Profiler” tool trying to track all the database queries. NO luck.
Ultimately, I found the issue. it was because when delete a user in Sitecore, it does delete both commerce user and Sitecore user, BUT not contacts in xDB. Just for the proof of concept, I removed the contact and identifier from xDB. Bingo! It fixed the issue.