arcpy.da.Editor not saving edits to base Oracle Spatial tables

Question

Can't post code because of Fed policy, so I will ask the question here.

We are working on a series of polygon feature classes that are used to define large activity areas. These polygons are modified using arcpy such that activity exclusion areas are cut out of the larger polygon. To accomplish this end we are using arcpy.da.Editor(). The code works beautifully in a file geodatabase, but when executed in Oracle Spatial, it refuses to push edits from the delta tables into the 'A' table in Oracle Spatial. My first thought to a solution here would be to access the 'SHAPE@' object in the fGDB then convert it to a string and use an "UPDATE" command in Oracle SQL via ArcSDESQLExecute to push the edits to the 'A' tables.

Can anyone else come up with a better solution? Our DBA insists that this issue is on the code side and not a quirk of Oracle.

• Vince: You're describing software operating as designed. One sure way to cause database integrity failure would be to hack the the business table with SQL outside the versioning context, so you won't find many who will encourage that procedure (and shouldn't trust any that do).
• Dowlers: I'm confused by the terminology. The A table is one of the delta tables. If you edit in a versioned environment adds and updates are recorded in the A table. It sounds like you want to see that data in the base table. Is this correct?

Answer 1

I have only ever used sqlserver or postgresql, but I usually would register the feature class as versioned, write to a child version of the database, save edits, stop editing, then I would have to use the arcpy tool to Reconcile Versions. You usually want to avoid writing directly to the default version.

Edit - reconcile versions, not synchronize changes. synchronize changes is for two databases.

• Ken Gaines: Thanks for this. What arcpy tool are you talking about that does Synchronize Changes?
• isamson: Edit - you probably want ReconcileVersions_management. desktop.arcgis.com/en/arcmap/10.3/manage-data/geodatabases/… For two gdbs you could use this, along with reconcile versions. desktop.arcgis.com/en/arcmap/10.3/tools/data-management-toolbox/…
• Ken Gaines: Reconcile Versions looks like it will do what we need. It might be a good idea to run this by our DBA to make sure it isn't going to break something she has set up in the GDB. Thanks for your help!