topic After adding a field SDE won't update views (_EVW) in Geodatabase Questions

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

GyeyoungChoi — Wed, 16 Dec 2015 21:33:46 GMT

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

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

ChristianWells — Wed, 16 Dec 2015 21:49:01 GMT

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

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

JoshuaBixby — Thu, 17 Dec 2015 04:10:47 GMT

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.

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

GyeyoungChoi — Thu, 17 Dec 2015 16:23:45 GMT

Sounds good I'll do that

Thank you