topic Re: database view not updating in Data Management Questions

database view not updating

LeoLadefian3 — Tue, 07 Jan 2020 20:49:48 GMT

I created a Database View using Catalog 10.7 and registered it with the database, running SQL Server. VW was created from the default version using the geodatabase admin connection. However, I'm not able to see data updates when connecting to other users / versions.

Re: database view not updating

GaryBarden — Tue, 06 Oct 2020 16:50:25 GMT

Did you ever figure this out?

Re: database view not updating

LeoLadefian3 — Tue, 27 Oct 2020 14:24:13 GMT

If I remember correctly, I had to create the view from SQL server instead of ArcMap.

Re: database view not updating

Asrujit_SenGupta — Wed, 28 Oct 2020 04:01:27 GMT

However, I'm not able to see data updates when connecting to other users / versions.

Does this mean that you can see the updates in the View connected as the data owner?
How are you connecting to other Versions in the View? What steps are you following?

On a general note:

Is the data Registered as Versioned?
Are you performing the reconcile/post and compress, before checking the View for updates?

A database view refers to the base table of the underlying data. If your data is Registered as Versioned, then edits may still be in the A- & D- delta tables. So you need to Reconcile and Post (if editing is done on other versions than DEFAULT) and then perform the compress.