AnsweredAssumed Answered

Updating multiversioned view fails

Question asked by krosemanp on Jun 25, 2015
Latest reply on Jun 26, 2015 by krosemanp

I am attempting to edit a multiversioned view using SQL. I set the feature class to versioned, created the view from command line using "sdetable -o create_mv_view", and try to run an update with SQL on a single attribute field but receive the error:

Msg 50000, Level 16, State 1, Procedure v446_update, Line 27

User must call edit_version before editing the view.

 

If I try to call edit_version I get:

Msg 50000, Level 16, State 1, Procedure edit_version, Line 78

Cannot edit the DEFAULT version in STANDARD transaction mode.

 

I am running ArcGIS and ArcSDE 10.0 SP3 on SQL Server 2008. The ability to edit the Default version through multiversioned views is available at version 10 SP2 according to http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/A_quick_tour_of_editing_versioned_data_using_SQL/006z000000vp000000/.

 

http://support.esri.com/en/knowledgebase/techarticles/detail/39112 describes this behavior also. Not specifying an edit version still gives me the first error above.

 

Just to be sure, I removed all other versions, compressed to state 0, unversioned the feature class, reverionsed, and recreated the view, but still have the same problem.

 

Does anyone successfully use views in this way and what version is the server running? Is the documentation wrong?

Outcomes