Posts Tagged ‘DBT2’

DBT2: ImportError: libR.so: cannot open shared object file

Yet another error I encounter whilst running DBT2 tests. This time it was a problem with generating the final reports. They are generated using a Python library which uses R under the hood. This is the error. Traceback (most recent call last): File “/usr/local/bin/dbt2-post-process”, line 14, in import rpy2.robjects as robjects File “/usr/local/lib64/python2.7/site-packages/rpy2/robjects/__init__.py”, line 15, […]

DBT2: stmt ERROR: 1406 Data too long for column ‘out_w_city’ at row 1

Another issue with the DBT2 benchmarking suite. mysql reports SQL STMT: stmt ERROR: 1406 Data too long for column ‘out_w_city’ at row 1 Just edit the payment stored procedure and change; ?View Code MYSQLDECLARE out_w_city VARCHAR(10); To; ?View Code MYSQLDECLARE out_w_city VARCHAR(20);