I’ve been doing some housekeeping of our patrols data: moving patrols into different folders, renaming some existing folders, and deleting empty folders. Three times now this has caused the database to “break” in some way so that sync to Connect is no longer possible. Sync error message is “error processing work item: java.sql.SQLException: Invalid number of rows updated.” Only way out is to redownload the CA or restore from backup. These seem very mundane sorts of changes to be making.
Running SMART 7.5.6
Jeremy