Note: The installer ISO image on the website was updated with a new update script that should prevent this issue.


Some customers while updating to MET/TEAM version 3.2.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 692

The INSERT statement conflicted with the FOREIGN KEY constraint "fk_ContextElements_UCIData_nUCIDataUID". The conflict occurred in database "metteam", table "dbo.UCIData", column 'nUCIDataUID'.


First, verify the missing record by running the following query:

SELECT * FROM UCIData WHERE nUCIDataUID = 'f1bd5d98-5b25-47de-a7e6-52bed7df377d'

Once confirming that the record is missing, run this script to add the missing record:

INSERT INTO [dbo].[UCIData] ([nUCIDataUID], [cModel], [cField], [cProperty], [cValue], [lActive], [lDeleted], [lApproved], [lAdded], [nAddFacilityUID], [nAddUserUID], [tAddTime], [nUpdateFacilityUID], [nUpdateUserUID], [tUpdateTime], [tMobileTime], [tSystemUpdateTime], [nImportUID]) VALUES ('f1bd5d98-5b25-47de-a7e6-52bed7df377d', N'Procedures', N'nProcedureFileUID', N'Label', N'Procedure File', -1, 0, 0, -1, 'f7e2e0c9-cef7-4c92-900f-ba1d5f7b1c29', '915f9722-3175-4e4d-a571-4a478e8e5172', '2017-01-20 18:44:06.667', 'f7e2e0c9-cef7-4c92-900f-ba1d5f7b1c29', '915f9722-3175-4e4d-a571-4a478e8e5172', '2017-01-20 18:44:06.690', '2017-01-20 18:44:06.690', NULL, NULL)

Then re-run the update script.