laptop and a wrench

Bug

SQL queries of a multiversion view do not return edits posted to the default version, unless the dbo.set_current_version stored procedure is executed first. By default, queries of multiversion views execute on the default version, so running the stored procedure to set the current version to Default should be unnecessary. This applies to SQL Server 2005 and 2008 using ArcSDE 9.3.1. It is not reproducible in ArcSDE 10.

Last Published: August 25, 2014 ArcSDE/Enterprise Geodatabase
Bug ID Number NIM063284
SubmittedDecember 2, 2010
Last ModifiedApril 2, 2025
Applies toArcSDE/Enterprise Geodatabase
Version found9.3.1
StatusDuplicate

Additional Information

Duplicate of NIM060955

Workaround

Run stored procedure prior to executing SQL queries. This is not optimal for the customer, who wants non-GIS users to be able to query the spatial table without running any other procedures.

Steps to Reproduce

Bug ID: NIM063284

Software:

  • ArcSDE/Enterprise Geodatabase

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options