How to Fix a New SDE_State

Question

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.

Stephen_Usmar · Answer

Thanks again Jonathan, this is really helpful.

JonathanFarmer_oldaccount · Answer

Hi Stephen,

OK, that works as well as a way around this!

We have lots of documentation on versioning. It can be complex for the first time user but it isn't too bad once you work with it for a bit.

An overview of traditional versioning—ArcGIS Help | ArcGIS Desktop

Start with this link above and then use the navigation on the left side of the page to click through all the other pages on versioning after this one. We also offer an instructor led course on this if you want to go all out:

https://www.esri.com/training/catalog/57630435851d31e02a43ef9c/implementing-versioned-workflows-in-a-multiuser-geodataba…

Hope that helps!

Jonathan

Stephen_Usmar · Answer

Thanks for the guidance Jonathan. The State issues were having such a widespread impact we ended up restoring the AWS server images. If we end up experiencing the same problem again I'll follow your suggestions. Any advise on where I can access some documentation/links around how versioning, States, lineage, etc all fits together and works so that I can get a deeper understanding of this for future reference?

Regards

Stephen

Count_Bird_Survey.PNG

GeoffroyRicherLalonde_2-1714401206117.png