Note: The installer ISO image on the website will be updated with a new update script that should prevent this issue once available.
Problem
Some customers while updating to MET/TEAM version 3.3.0 receive an error in the installation log file indicating that the SQL update script failed to run.
When running the script manually in SQL Server Management Studio, an error message like this one occurs:
Adding Context Element for ProcedureFile Msg 547, Level 16, State 0, Line 53239 The INSERT statement conflicted with the FOREIGN KEY constraint "fk_ContextElements_UCIData_nUCIDataUID". The conflict occurred in database "metteam", table "dbo.UCIData", column 'nUCIDataUID'.
Solution
Run the new version of the update script attached to this article from within SQL Server Management Studio. If you have not already run the update installer, you should unselect the update option to run the SQL update scripts automatically (after selecting Use Custom Settings). Then run the SQL script from this article.