-
Title
"Error: blk_roxfer filed" when creating objects for tpc-c test with Sybase -
Description
Created a small TPC-C test against a Sybase 12.5.4 server on Solaris. The test fails during the object building stage.
Note that setting a job to re-create objects every time does not fix the issue.
Sample:
** Job 'TPC-C Job' started.
No Agent connected. Setting test 'TPC-C Transaction Mix' to run locally.
Started test 'Create objects for TPC-C (with Delete)':
Delete SP
Tables
Started loading table C_Warehouse.
Started loading table C_History.
blk_roxfer failed!
Completed loading table C_WareHouse.
Started loading table C_New_Order.
Started loading table C_Order.
blk_roxfer failed!
Started loading table C_Order_Line.
blk_roxfer failed!
Started loading table C_District.
Started loading table C_Customer.
Completed loading table C_District.
blk_roxfer failed!
Started loading table C_Item.
Started loading table C_Stock.
Completed loading table C_New_Order.
Loading table C_Item ( 10000 (10.00%) rows completed )
Loading table C_Stock ( 10000 (10.00%) rows completed )
Loading table C_Item ( 20000 (20.00%) rows completed )
Loading table C_Stock ( 20000 (20.00%) rows completed )
Loading table C_Item ( 30000 (30.00%) rows completed )
Loading table C_Stock ( 30000 (30.00%) rows completed )
Loading table C_Item ( 40000 (40.00%) rows completed )
Loading table C_Stock ( 40000 (40.00%) rows completed )
Loading table C_Item ( 50000 (50.00%) rows completed )
Loading table C_Stock ( 50000 (50.00%) rows completed )
Loading table C_Item ( 60000 (60.00%) rows completed )
Loading table C_Stock ( 60000 (60.00%) rows completed )
Loading table C_Item ( 70000 (70.00%) rows completed )
Loading table C_Item ( 80000 (80.00%) rows completed )
Loading table C_Stock ( 70000 (70.00%) rows completed )
Loading table C_Item ( 90000 (90.00%) rows completed ) -
Cause
The Date format for the client computer is different from the server computer where Sybase on Solaris exists.
-
Resolution
Please make sure the formats are the same on both client and server computers. Please first check what format you have on your server. Then you can change the format on your client computer to the same one as server computer.