Error 1047 System.Data.ConstraintException

Error 1047 System.Data.ConstraintException is a database error. SureSync uses an Access or SQL database to store items such as job log records and file history for multi-directional rules. In addition, the database stores configuration information for your Relations, Schedules, Real-Time Monitors and other important SureSync related information.

System.Data.ConstraintException error is most often caused by a problem processing some action related to file history in the database. These errors should not happen and could require assistance from Technical Support to fix. To resolve this issue, you should do the following:

  • Check the version of SureSync you are running. For v7 and newer this can be done by launching the SureSync Desktop. Click on Home and About.
  • Consult our Version History page for your version and search for "System.Data.ConstraintException." Version 9 history can be found here. Version 8 history can be found here. Version 7 history can be found here. Version 6 history can be found here. Version 5 history can be found here.
  • If there is a known fix for violation of primary key constraint in a version newer than what you are running, you should upgrade your environment to the current release.
  • Once upgraded, monitor for the error. If the error continues, please contact our support team for assistance.