When the customer follows the below steps, customers might get this type of error
Transaction, Foundation 10x
Users might have multiple login (different users) to the desktop products from one computer/laptop. Due to this, the duplicate entries are being created in SQL server database, so the only option is to manually run the script to delete the duplicate entries from SQL.
With SQL Server Management Studio, navigate to the SQL instance containing the eshuttleDB. If you do not know where this is located, do the following:
In a browser, navigate to the Winshuttle Central Site.
- Click on Winshuttle Central Administration.
- Click on Database Connection.
- The connection string will display the instance and database name.
- Connect to the SQL Server box
Navigate to the dbo.shuttleusers table.
Right-click on the dbo.shuttleusers and Select Top 1000 Rows
There will be a user name more than one entry
Right click on the dbo.shuttleusers table and Edit Top 200 Rows
UPDATE one of the duplicates by appending _duplicate to the end of the username value
Alternatively, if adding duplicate doesn't work, delete the entry by executing the query "DELETE FROM dbo.ShuttleUsers WHERE uid = 999999", where 999999 is the UID that should be deleted.
User can now test the same scenario, this will work fine without any issues