SQL Updates to Versioned View not showing in Desktop

2961
4
03-30-2016 04:09 PM
ThomasBaxter
New Contributor II


I have a bit of a strange one - we are doing updates to a default version in versioned views (to update a linking number to another system), the update works fine, however in Desktop (10.2) the updates don't necessarily display correctly.

If you have the Feature Class open at the time the update is fired, it may or may not show the updated values in the identify or table tools until you relaunch the application, is there some sort of caching at the application level that may be causing this?  Hitting Reload Cache in the Table tool doesnt appear to update the values though

Relaunching Desktop and opening the FC again shows the updates as expected - its not a showstopper, its just annoying!


Any ideas?

My Environment - 10.2 for Desktop and Server, SQL Server 2008

0 Kudos
4 Replies
by Anonymous User
Not applicable

Are you executing "commits" after the update sentencies?

Jesús de Diego

0 Kudos
ThomasBaxter
New Contributor II

Yes, if we open the feature class after the edit has been made the edits are reflected - its only if the FC is open at the time of the edits it isnt reflected

0 Kudos
JoshuaBixby
MVP Esteemed Contributor

Instead of closing all the way out of ArcMap and relaunching, what if you remove the feature class in question and add it back in?  Does it show the updated data?

0 Kudos
UmakantJoglekar2
New Contributor III

Hi Thomas,

Even I have seen similar behavior however in our case, refreshing ArcMap using the refresh button at the bottom was enough or even panning around used to help see the new edits in ArcMap.

Have you tried the refresh button?

0 Kudos