Duplicate Records In Btobjectchecksums
I'm showing millions of duplicate records in the table BtObjectChecksums. I have nearly 39 million duplicate rows when comparing all columns except the primary key (ChecksumID) as of this writing. Is this in any way normal?
Again, when I ran the following query--comparing Format, Type, Name, and Value--there is a wild range of duplicate records; some as few as 2 and some as frequent as 1,256,785 duplicate records with the same data.
SELECT MIN(ChecksumID) , FormatID , ObjectTypeStringID , ObjectNameID , Value , COUNT(*) FROM dbo.BtObjectChecksums GROUP BY FormatID , ObjectTypeStringID , ObjectNameID , Value HAVING COUNT(*) > 1;
Is this normal and/or is it safe to delete the duplicate records?
-
That's the identifiers for the information stored in your BarTender System Database. If you remove or modify it, you may corrupt the data that's being used for history and reprinting capabilities. If you'd like to perform maintenance on your BarTender System Database, you can use the wizard provided in the BarTender System Database Setup application, use the command line or SQL commands listed in the BarTender Help file, or use the System Database SDK. We don't recommend modifying the system database manually, as you may remove or change data that's needed for interaction with other applications. 0 -
But what is the logic behind having 1,256,785 records of the exact same data?
0 -
If you'd like to perform maintenance on your BarTender System Database, you can use the wizard provided in the BarTender System Database Setup application, use the command line or SQL commands listed in the BarTender Help file, or use the System Database SDK.
It's not that the data is old--there are no print job records created earlier than 2 days ago. It just seems like this table is growing exponentially from the data it already contains.
0
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
Kommentare
3 Kommentare