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.


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.