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

3413
3
12-16-2015 01:33 PM
Highlighted
New Contributor II

Howdy,

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)
Reply
0 Kudos
3 Replies
Highlighted
Esri 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.

Thanks,

Christian

Reply
0 Kudos
Highlighted
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.

Reply
0 Kudos
Highlighted
New Contributor II

Sounds good I'll do that

Thank you    

Reply
0 Kudos