If at the end of a package sync you see the following error, see the below resolution.
Exception of type 'System.Exception' was thrown.
This may be a problem with how many items are included in a package sync. You may only have one taxonomy in a package, but if it has 100,000 items in it you could see this issue.
To verify if the sync failure is due to the number of items, do the following.
- Enable sync framework logging on both sides of the sync
- Check the sending server's log for the following error.
System.Data.SqlClient.SqlException (0x80131904): The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query.
- If that error is present, limit the number of items you are syncing in the package to resolve the error.