Business Process Choreographer Archive database upgrade troubleshooting

If you are using DB2, when you run the upgradeSchemaAll_de_name command or run the SQL scripts to upgrade the databases manually, you might see an error when a new column is added to a Business Process Choreographer Archive database table.

The error is similar to the following error:
ALTER TABLE bpcarchive.PROCESS_TEMPLATE_B_T ADD CUSTOM_TEXT8  VARCHAR(64)     
DB21034E  The command was processed as an SQL statement because it was not a valid Command Line Processor command.  During SQL processing it returned:SQL0670N  The row length of the table exceeded a limit of "4005" bytes. (Table space "CEI_TS_BASE4K_PATH".)  SQLSTATE=54010
This error occurs when the table space size of the table was set to 4K. You can solve the problem by completing the following steps for each table that has the problem.
  1. Export the data from the table.
  2. Create a new table space at least 8K in size.
  3. Drop all indexes created on the table.
  4. Drop the table.
  5. Re-create the table and its indexes.
  6. Import the data into the table.