Select to view content in your preferred language

database view not updating

1622
3
01-07-2020 12:49 PM
LeoLadefian3
Occasional Contributor

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.

Tags (1)
0 Kudos
3 Replies
GaryBarden
Regular Contributor

Did you ever figure this out?

0 Kudos
LeoLadefian3
Occasional Contributor

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

0 Kudos
Asrujit_SenGupta
MVP Regular Contributor

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.