December 29, 2011 at 2:44 am
Hi All,
I am encountering this error: Error initializing ODBC parser: ERROR [01003] [Microsoft][ODBC SQL Server Driver][SQL Server]Warning: Null value is eliminated by an aggregate or other SET operation.
ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]The maximum system-generated unique value for a duplicate group was exceeded for index with partition ID 423084970737664. Dropping and re-creating the index may resolve this; otherwise, use another clustering key.
What does this mean?
Thanks in advance!
December 29, 2011 at 3:37 am
It means that SQL Server automatically adds a 4 byte system generated uniqueifier to all the duplicate entries in a non-unique clustered index.
The maximum value for the uniqueifier is 4,294,967,296, which you seem to have exceeded.
How does your clustering key look like?
How many rows in this table?
-- Gianluca Sartori
December 29, 2011 at 5:53 am
It's worth reading following KB article.
FIX: You receive error 666 when you rebuild an index online on a partition scheme in SQL Server 2008 or SQL Server 2008 R2
July 18, 2016 at 2:28 pm
Page no longer exists. :unsure:
July 18, 2016 at 2:44 pm
This URL worked for me: https://support.microsoft.com/en-us/kb/982441
-- Gianluca Sartori
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply