topic Re: Unable to Edit 9.3.1 SDE with 10.2 in Data Management Questions

Unable to Edit 9.3.1 SDE with 10.2

AlexeiB — Wed, 04 Sep 2013 18:59:09 GMT

I recently upgraded my ESRI to 10.2 from 10.1 and am now unable to edit my data in SDE. My data resides in 9.3.1 SDE and every time I try to edit a feature in 10.2, I get "The requested operation is invalid on a closed state. STATE_ID=358107"

This was not an issue in 10.1 and my other computer running 10.1 can edit the same data that I am unable to.

Has anyone come across this problem?

Thanks,

Re: Unable to Edit 9.3.1 SDE with 10.2

MohammedHassoun — Thu, 05 Sep 2013 00:43:37 GMT

I also upgraded from 10.1 to 10.2 and have the exact same error. My data resides on 9.3.1 SDE and was I was able to edit using 10.1. Other 10.1 machines can still edit the data.

Re: Unable to Edit 9.3.1 SDE with 10.2

VinceAngelo — Thu, 05 Sep 2013 01:21:29 GMT

The geodatabase compatibility matrix shows support for 9.3 enterprise geodatabases
using ArcGIS 10.2 clients. You should contact Tech Support for assistance.

- V

Re: Unable to Edit 9.3.1 SDE with 10.2

EmadAl-Mousa — Mon, 09 Sep 2013 18:31:29 GMT

you can use this command to set the state status to "OPEN":

sdeversion -o open_state -S 358107 -u sde -i 5151 -N

reference article for the command: http://support.esri.com/cn/knowledgebase/techarticles/detail/34215

please try it and let us know.

Re: Unable to Edit 9.3.1 SDE with 10.2

NanaDei — Thu, 12 Sep 2013 21:19:47 GMT

Thanks to mhassoun. The behavior was related to working on ArcSDE 9.3 geodatabase feature classes in SQL Server 2005.
Please review the following link for SQL Server versions supported at ArcGIS 10.2.
======
http://resources.arcgis.com/en/help/system-requirements/10.2/#/Microsoft_SQL_Server_Database_Requirements/015100000070000000/

Thanks

Re: Unable to Edit 9.3.1 SDE with 10.2

deleted-user-eecV1RPyUfl1 — Tue, 31 Dec 2013 17:16:59 GMT

I also upgraded from 10.1 to 10.2 and have the exact same error. My data resides on 9.3.1 SDE and was I was able to edit using 10.1. Other 10.1 machines can still edit the data.

I experienced this issue as well and eventually had to revert back to 10.1 to get things working again. I had a 9.3x SDE geodatabase, SQL Server 2005 Express and ArcGIS 10.2, and it just would not work with that configuration.