Error at end of package sync

  • Updated

If at the end of a package sync you see the following error, see the below resolution. 

Exception of type 'System.Exception' was thrown.

systemexception.jpg

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. 

  1. Enable sync framework logging on both sides of the sync 
  2. 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.

  3. If that error is present, limit the number of items you are syncing in the package to resolve the error.