topic Post Data to sql server in ArcGIS Enterprise Questions

Post Data to sql server

kawishabbas — Tue, 07 May 2019 09:16:40 GMT

I am using sql server 2012 and Arcmap version 10.4.1.

My problem is that when i post data from Arcmap it will post to parent version easily but not show in the table of sql server.

in above image i reconciled from child to parent version and post, it works successfully. i edit name filed which has mentioned in image.

This is my Application in which i show all data in table format, you all can see there is no update of name filed.

George_Thompson — Tue, 07 May 2019 11:48:39 GMT

It sounds like the versioning is working as designed. The edit may not show up in the base table till you run a compress; https://desktop.arcgis.com/en/arcmap/latest/manage-data/geodatabases/the-compress-operation-and-geodatabases.htm

Run the compress and see if the edit is moved to the base table and report back.

Asrujit_SenGupta — Tue, 07 May 2019 11:53:15 GMT

Or refer to the versioned view created from that Feature Class in your Application...

kawishabbas — Wed, 08 May 2019 05:29:50 GMT

There is same issue compress did not move edit data to base table.

George_Thompson — Wed, 08 May 2019 11:52:38 GMT

If possible, could you delete all the versions (EXCEPT for DEFAULT) after a reconcile/post and then re-compress?

There may be a blocking version state.