I am seeing duplicate entries in collections, reports, etc., but if one of the duplicates is deleted, both are removed. If the computer is then brought back in, the duplicate entry shows up again.
It turns out that the StringCache table is no longer a table at all, but is a view. The table that caused the view to have duplicates was the KnownCulture table. The table only has one column
Culture which had the following four records:
en-US. This extra
en-US caused duplicates in the StringCache view which cascaded to cause duplicates within almost every resource list within the product.
The theory is that if there is some type of database problem when the query to find the KnownCulture fails, it inserts a new record for the culture that the user was set to which was still
en-US, thus causing the duplicate entry.
One of the entries for
en-US needs to be removed. It can't be easily done directly, so the following SQL code takes care of the issue by removing any extra entry.
/* Select each item distinctly into a temporary location */
select distinct Culture into #tmp_knownculture
truncate table KnownCulture
/* Rebuild the KnownCulture table from the temporary location */
insert into KnownCulture
select * from #tmp_KnownCulture
drop table #tmp_KnownCulture
/* Finally display the newly built table to verify the data */
select * from KnownCulture
Imported Document Id
This is machine translated content
Login to Subscribe
Please login to set up your
For security reasons, your link to this document has expired. Please click on the attachment link to access this file.
The attachment that you are looking for no longer exists.
There has been an issue retrieving your attachment. Please try again.
Currently server is down.
Didn't find the article you were looking for? Try these resources.