English

Problem: Versioned views are not created when registering data as traditional versioning

Description

When an ArcGIS 10.8 / ArcGIS Pro 2.5 (or newer) client connects to a 10.7.1, or earlier, release of an Enterprise geodatabase in Oracle, and registers the data as versioned, the versioned view is not created for the associated table or feature class.

Note: 
The data is still versioned and can be successfully edited using a desktop client, for example, ArcMap or ArcGIS Pro, because this editing method does not use versioned views, but instead uses the data’s associated delta (Adds and Deletes) tables.  Versioned views are only used for making edits directly through SQL.

Cause

This problem is due to a fix for BUG-00012040 in ArcGIS 10.8, that required the versioned view definition to be updated:

BUG-000124040 : Performing multiple updates on the same record in SQL only changes the existing record in the Archive Class instead of creating new records.

Solution or Workaround

  1. If you require versioned views:
  1. If any versioned views are missing, download KB000023226.zip, and extract it to a local folder
  2. Run the attached sql script, find_missing_vvs.sql, from sqlplus to generate an output text file, List_Missing_VersionedViews.txt, containing a list of missing versioned views in the desired schema.
sqlplus sde/sdepassword@SERVER/ORAGDB @C:\temp\find_missing_vvs.sql
  1. Create a connection file to the schema with the missing versioned views in ArcGIS Desktop.
  2. Add the same connection file string to the attached Python script, create_missing_vvs.py.
  3. Run the script inside the Python window of an ArcGIS Desktop client that matches the same version of the geodatabase, as follows. This creates the missing versioned views.

For ArcMap, use:

execfile(r'C:\temp\VerViews\create_missing_vvs.py')

For ArcGIS Pro, use:

exec(open(r'C:\temp\VerViews\create_missing_vvs.py').read())
Note:
The ArcGIS Desktop client version must match the version of the geodatabase to successfully create the versioned views.
  1. If you require versioned views with archiving enabled:
  1. Upgrade the geodatabase using ArcGIS Desktop 10.8 / ArcGIS Pro 2.5 (or above).  Customers whose enterprise geodatabase are at 10.6.1 and cannot upgrade to 10.8, can request to apply 10.6.1 Hot Fix  -  DT-1061-HF-000004988.
  2. If any versioned views are missing after the upgrade, follow Step 1 above, to create the versioned views.

Related Information

Last Published: 8/15/2021

Article ID: 000023226

Software: ArcGIS Pro 2.4.3, 2.4.2, 2.4.1, 2.4, 2.3.3, 2.3.2, 2.3.1, 2.3, 2.2.4, 2.2.3, 2.2.2, 2.2.1, 2.2, 2.1.3, 2.1.2, 2.1.1, 2.1, 2.0.1, 2.0