When running TCP-E workloads, this error shows.
The error log shows this error:
Execute TradeResult Frame2 Insert E_HOLDING_SUMMARY failure.
ODBC Error (23000,A43) - [Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'PK__E_HOLDIN__FFD2F4DD73BA3083'. Cannot insert duplicate key in object 'dbo.E_HOLDING_SUMMARY'. The duplicate key value is (2721, QIA ).
ODBC Warning (01000,E25) - [Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
Looks like the TPC-E objects were not recreated when the TPC-E was re-ran.
If TPC-E objects are not re-created when re-running the TPC-E job/workload for testing multiple times, the primary key violation might be raised. To address this error, re-create the TPC-E objects for each run because of TPC-E is a read&write test.
When doing Benchmark testing, the Benchmark object should be recreated; so please select the "Always delete objects before create" checkbox in the Benchmark Objects Wizard, then run the testing again.
