IBM BPM, V8.0.1, All platforms > Troubleshooting and support > Troubleshooting installation and configuration

Troubleshooting problems creating database tables

While trying to create database tables for the BPM database and the Performance Data Warehouse database, you might get errors or exceptions that prevent you from creating the tables. Your bootstrap operation also fails.

The errors might have occurred because the "NOT LOGGED" tag was removed from some of the tables. The message indicates that you have the wrong version of DB2:

DB21034E  The command was processed as an SQL statement because it was not a valid Command Line Processor command.  During SQL processing it returned:
SQL0355N  The column "RECORD", as defined, is too large to be logged.
SQLSTATE=42993


Procedure

  1. Upgrade the database to the supported version (DB2 V9.7 fix pack 4 or above )
  2. Drop the existing Process Server and Performance Data Warehouse databases. This step is required because the databases are not complete. The error indicates that some of the tables are missing.

  3. Create the Process Server and Performance Data Warehouse databases again.


Results

The tables for the databases are created successfully without any errors.

: Troubleshooting installation and configuration