We are running ArcGIS Server 10.5 and two days ago found we were unable to make map edits using ArcGIS Collector and kept receiving "Update Failed". On checking the SDE_States table there is a new state that has been generated which relates back to the error we are receiving:
Target state not found in the STATES table [dbo.DEFAULT][STATE_ID = 409403].
How do I delete this STATE without causing reference issues. I can see everything in SQL Server but would like to know if there is a tool that I can run to remove it? I have run the other lineage tools to check for corruption/issues and they are coming back as error free.