Error message during the execution of the TPC-E test in Benchmark Factory. (4374863)

Error message during the execution of the TPC-E test in Benchmark Factory.

Running a TPC-E test against SQL Server, and throws an error message while executing TPC-E job.

Error message:
“Agent (BMF-AGENT5) Error: Execute statement1 failure. Transaction "XXXX Transaction" run failed by virtual user 270 in agent 5 of BMF-AGENT.”

Deadlock issues are caused because the database is not able to handle a large number of concurrent insert requests.
 

Reduce the number of Virtual users and try again.
 

Error logs: Error log Location: - C:\..\ Documents\My Benchmark Factory\8.4.2\x64\Error Logs. This deadlock message will appear. “Connected to 'Database_Name' on Port: '4568' Execute XXXX statement1 failure. Transaction "XXXX Transaction" run failed by virtual user 424 in agent 4 of XXXX ODBC Error (40001,4B5, 1) - [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Transaction (Process ID 487) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Transaction "XXXX Transaction" run failed by virtual user 424 in agent 4 of Database_Name”