Assume that you have Microsoft Configuration Manager version 1606 installed on your computer. When you install a new version of Configuration Manager or upgrade the Configuration Manager from version 1606, the Upgrade Assessment Tool (UAT) fails to synchronize compatibility data from the Compatibility Online Service and the local Application Compatibility Toolkit (ACT) database.
In this situation, the following error message is logged in the SyncS.log file:
UAT sync service encountered exception: Failed to merge with error: ExecuteNonQuery: Exception:Could not find stored procedure ‘sp_UATMergeTable’, when executing sql command: Exec sp_UATMergeTable ‘UAT_Deployment_OS’, ‘##UAT_Deployment_OS_TMP’,’1000’,…
This issue occurs because a required stored procedure sp_UATMergeTable is missing from the database schema in Configuration Manager version 1606.
Note You won’t experience this issue when you upgrade from versions that are earlier than 1606 because you continue to have that stored procedure.
To resolve this issue, follow these steps to restore the missing stored procedure:
- Download an SQL script here.
- Run the self-extracting executable ConfigMgr-CB-KB4011296.exe to extract the SQL script.
- Use SQL Server Management Studio or a similar tool to execute the script on the Configuration Manager database.
Note The Upgrade Assessment Tool is listed as deprecated and won't be supported after July 11, 2017. For more information, see Removed and Deprecated Features for Configuration Manager (2012) and Removed and deprecated features for System Center Configuration Manager (current branch).
Article ID: 4011296 - Last Review: 2017, ഫെബ്രു 14 - Revision: 11
Microsoft System Center Configuration Manager 2007