Create a Benchmark Factory (BMF)connection to a SQL Server instance usingan ODBC-connectionto test performance. Attach and test ODBC-connection to the BMF profile.
Run a standard TPC-C test with this profile.Objects for the TPC-C testarecreated, buta message is recieved saying Test completed with errors..
The following output shows the error log which continues until the test ends:
** File Opened at: (04.05.2009 06:54:13)
Benchmark Factory Agent
Version: 5.7.1
Build: 504
Copyright  Quest Software 2008
New Order: Statement 1 Exec
New Order: Statement 1 Exec
ODBC Error (22008,F2) - [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
ODBC Warning (01000,E25) - [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
New Order: Statement 1 Exec
ODBC Error (22008,F2) - [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
New Order: Statement 1 Exec
ODBC Error (22008,F2) - [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
New Order: Statement 1 Exec
New Order: Statement 1 Exec
ODBC Error (22008,F2) - [Microsoft][ODBC SQL Server Driver][?SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
ODBC Warning (01000,E25) - [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
Agent(as03676) Error: New Order: Statement 1 Exec
The Transactions per second are still about 1 which simply cant be true.
The final message is Completed with errors
Checklanguage/regional onclient OS.Changestandards and formats in Regional/language to English(U.S.) from Control Panel |Regional and Language Options if not set to English(U.S), reboot your machine and then test.
If test still errors, raise a support case with the results of the command exec sp_helptext C_SP_New_Order for a hot fix.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center