Overview
Problem / Symptoms:
This error is caused by Databases that use to be part of a multivenue and old store records have not been removed correctly
Diagnosis:
Solution / resolution:
Run SSMS and query the current database with the following:
select * from Venue
select * from Store
This should highlight all the venues and store present within the current database.
Once you have identified which Store(s) is required you will have to repair the database using the following below guides and ensure that the Stores are in numerical order starting from StoreID 1
Guide:
Rebuilding a corrupted Store Table.
Converting a Multivenue Site to a Single Venue site with the correct reseed StoreID's