Troubleshooting: Update Workspace failing to update the workspace because of missing column for primary key

When running the update workspace table ANT task when the primary key changed on the table to account for a new column, the tool will fail. The tool will attempt to create the primary key on the workspace tables before creating the new column.

Solution

The solution is to run the ANT task and generate the file to contain the SQL statements to run. Then remove the statements that creates the new primary key and execute the SQL in the database command prompt. Then rerun the ANT task for the table to create the primary keys.

Related concepts
Authoring environment schema update tool

Related tasks
Enable Workspaces
Creating an authoring environment
Synchronizing an authoring environment with a production environment
Running the authoring environment update scripts on the WebSphere Commerce Server
Updating the quick publish target
Updating the JDBC provider setting for the quick publish target
Enable retry for quick publish
Enable e-mail notification for workspaces
Enable shopping flow preview for workspaces
Changing workspaces locking policy

Related reference
Ant target: CM_updateWorkspacesTable
Ant target: CM_updateWorkspacesSchema