Select to view content in your preferred language

After adding a field SDE won't update views (_EVW)

12-16-2015 01:33 PM
New Contributor II


I'm using SQL 2012 with ArcSDE 10.2.

Recently I noticed that the last field that I added on existing table (feature layer) in ArcCatalog won't update SQL's view file.

Therefore when I use the view with the last field that I added it, cause error because the new field is not exist in the view.

Only way to fix the problem is unregistered from versioned then re-register it.

Where should I take a look to solve the problem?

sp_refreshview didn't help

Tags (3)
0 Kudos
3 Replies
Esri Regular Contributor

Hi Gyeyoung,

I can reproduce this in SQL Server but not Oracle. Any chance you can open a support ticket with Esri, so we can look into this issue further? I can help you out with this part if you send me a direct message.



0 Kudos
MVP Esteemed Contributor

I have a test machine with ArcGIS 10.3.1 (Desktop and SDE) and SQL Server 2014, and I don't have a problem with the versioned view getting updated after changes to the original table.  I wonder if there was a bug that has been addressed in 10.3 or 10.3.1.

0 Kudos
New Contributor II

Sounds good I'll do that

Thank you    

0 Kudos