SDE edits

Question

I'm working on a 10.1 SDE geodatabase that is versioned, some of my edits will stay when I reconcile and post, but then some of my edits will go back to their original place before the edit. It is random and doesn't make much sense. The edits are showing up in the tables and log files on the server side but not showing up in the GIS. Anybody else had this problem?

-Nick

MihailCretu · Answer

@ Nick

After a lot of "googleing" on esri sites/forums I found this patch:
http://support.esri.com/en/downloads/patches-servicepacks/view/productid/66/metaid/1989#bugs

It says that it it for postgresql but it also modifies SDE.DLL witch is responsible for sde direct connects.
With the ideea that it cannot possibly do more harm, I am going to deploy it on my workstations. All 60 of them. A lot of fun...

I'll post if this has any effect, but you should try to install the patch yourself. Good luck.

NicholasKnabe · Answer

That is the main thing that is confusing to me, is the fact that it is random. I was moving 4 pipes the other day to a point and 3 of the pipes stuck to the point while the 4th would not stay after moving it and saving my edits. The randomness has really thrown off myself and our IT people.

-Nick

MihailCretu · Answer

I have some geometry with arcs unfortunately. We cannot use arc geometries, so I'm working on a tool to convert them to straight lines.
When I'm done, I'll post the py script if that helps you.

But I am not convinced that only the geoms with arcs are the problem. But I'll investigate this asap anyway.

I am working on a tool to export  all data to shp before arcmap closes, and test for differences when i start it again. So far, nothing concrete, it seem completely random to me.

I've also contacted our ESRI Support. Waiting for a reply.

btw: I am using esri_binary geom type because geometry/geography loads our sql to about 75% CPU per user !