-
Titel
Violation of PRIMARY KEY constraint cannot insert duplicate key in object -
Beschreibung
When I use Benchmark Factory to run TPC-E Transaction Mix against SQL Server 2008 R2 (SP1), I got many PRIMARY KEY constraint errors (see below).
Examples: ODBC Error (23000,A43) - [Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'PK__E_TRADE__83BB1FB2155B1B70'. Cannot insert duplicate key in object 'dbo.E_TRADE'. The duplicate key value is (18924787).
ODBC Warning (01000,E25) - [Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
Execute TradeOrder Frame4 failure.
ODBC Error (23000,A43) - [Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'PK__E_TRADE__83BB1FB2155B1B70'. Cannot insert duplicate key in object 'dbo.E_TRADE'. The duplicate key value is (18924817).
ODBC Warning (01000,E25) - [Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
Execute TradeOrder Frame4 failure.
ODBC Error (23000,A43) - [Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'PK__E_TRADE__83BB1FB2155B1B70'. Cannot insert duplicate key in object 'dbo.E_TRADE'. The duplicate key value is (18924847).
ODBC Warning (01000,E25) - [Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
Any advice for what to do?
-
Lösung
Issue [ST92122] has been fixed and will be available in the 6.7 release of BMF. The target date is late Q1/Early Q2 of 2012
-
Fehler-ID
ST92122