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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy