topic Re: Unbale to Save Edits - ArcSDE in Data Management Questions

Unbale to Save Edits - ArcSDE

deleted-user-XYH0uc33lKDp — Mon, 08 Nov 2010 18:05:46 GMT

I am setting up a test environment to edit some data using ArcMap and ArcSDE that is connected to SQL Server. I can connect to the database, view the data and do everything else you can do with ArcServer (load data, delete data, create data, etc...) but I cannot save edits. When ever I try to save edits on a versioned dataset I get the following error:

Unable to save edits.
Function requires a state to be set for stream[DatabaseName.dbo.datasetname][State_ID=0].

Both geometry and attribute edits will not save. I am connecting through a direct connection to my sql database and I am an admin on the server and I believe I have the correct privileges.

I am running ArcMap 10 and SQL Server 2008.

Thanks for any ideas!

Ben

Re: Unbale to Save Edits - ArcSDE

MarkAnstaett — Tue, 23 Nov 2010 11:53:47 GMT

Benjamin,

Have you found a solution to this? I am trying a programmatic (vb.net) versioned editing session and get the same exact error, however ours is SQL Server 2000, ArcSDE 9.2, ArcMap 9.3.1, not using direct connection. Any findings you have may help in my case.
thanks,
Mark

Re: Unbale to Save Edits - ArcSDE

deleted-user-XYH0uc33lKDp — Tue, 23 Nov 2010 13:37:02 GMT

No, unfortunately, not yet. I have an open ticket with Esri and I am eagerly awaiting an answer!

If and when I do come to an solution I'll make sure to post it here.

Ben

Re: Unbale to Save Edits - ArcSDE

deleted-user-XYH0uc33lKDp — Fri, 28 Jan 2011 16:27:36 GMT

I was able to come to a solution to this problem after many hours on the phone with Esri's tech help. What was the solution, you ask? We determined I had a bad install of SQL Server. After I rebuilt my machine everything worked perfectly.

It wasn't the quick fix I was looking for but now everything is running smoothly.