topic Re: edits not being moved to base tables after compression in ArcGIS Enterprise Questions

edits not being moved to base tables after compression

ErikBlake — Fri, 23 Jun 2017 12:53:50 GMT

we have 10.3.1 our field guys are using collector for hydrant flushing program. they are editing directly to our sde default versioned database. for some reason when i do our nightly compression of the database their edits are not showing up in the base tables. they are staying in the delta tables. this problem seems to have just started. it was working last week. any ideas what might be causing this?

Re: edits not being moved to base tables after compression

George_Thompson — Fri, 23 Jun 2017 13:01:53 GMT

It sounds like there is a blocking version in the GDB that has not been Reconciled/Posted yet.

https://community.esri.com/groups/geodatabase?sr=search&searchId=8cebf85a-f755-4229-8734-4113903f4128&searchIndex=0‌

Re: edits not being moved to base tables after compression

ErikBlake — Fri, 23 Jun 2017 13:05:36 GMT

George

Thanks for the reply. We don't have any versions created from our default. So not sure what would need to be reconciled and posted. We do have multiple one way replications that are childs of our default. would that cause it to behave like this?

Re: edits not being moved to base tables after compression

George_Thompson — Fri, 23 Jun 2017 13:08:36 GMT

That may be possible. Here is a white paper talking about replicas and the compress. I know it is old, but still applies.

http://downloads.esri.com/support/whitepapers/ao_/J9842_GDB_Compress_With_Replicas.pdf

Update: What changed between last week (when the compress move the edits to the base table) and now?

Re: edits not being moved to base tables after compression

ErikBlake — Fri, 23 Jun 2017 16:51:58 GMT

George

So i figured out that i had to stop the map services that are hitting our default database. Just disconnecting them using the admin window in catalog was not enough.