AnsweredAssumed Answered

How to Fix a New SDE_State

Question asked by susmar on Aug 23, 2018
Latest reply on Aug 27, 2018 by susmar

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. 

Outcomes