topic Re: Replica synchronization works with ArcSDESQLExecute? in ArcGIS API for Python Questions

Replica synchronization works with ArcSDESQLExecute?

INFODIMEE — Fri, 13 Jan 2017 14:02:06 GMT

I use python to apply some changes in a feature class in an Enterprise Geodatabase on SQL server 2014 using ArcSDESQLExecute. Then, I use a replica I created to "Synchronize those changes" from the database on SQL server to another Geodatbase on Oracle 12c. But even though the synchronization completes with no error the changes are not transferred.

However, when I apply the same changes using ArcMAP and field calculator the Synhronization works fine and the changes are transferred normally.

Any ideas?

Re: Replica synchronization works with ArcSDESQLExecute?

JoshuaBixby — Fri, 13 Jan 2017 14:37:22 GMT

Looping in the https://community.esri.com/groups/geodatabase?sr=search&searchId=b4a212b8-db67-480c-a5de-7173640067b1&searchIndex=0‌ folks. I understand what you are trying to do, I just haven't seen this particular workflow before, so I am not sure if what you are seeing is expected or a bug. In the SQL you are executing on the SQL Server side, are you using versioned views or executing against the base tables?

Re: Replica synchronization works with ArcSDESQLExecute?

INFODIMEE — Fri, 13 Jan 2017 14:55:12 GMT

The feature class I am editing is registered as versioned, so my sql expression looks like this:

SQL_expressions = "UPDATE sde.mytable_EVW SET PARCEL_LABEL = 'FINALCHECK19'"

and after the connection .execute I can see the edit has been passed normally into the delta tables.