BUG-000125893 for ArcSDE/Enterprise Geodatabase

Bug ID Number	BUG-000125893
Submitted	October 10, 2019
Last Modified	March 1, 2026
Applies to	ArcSDE/Enterprise Geodatabase
Version found	10.6.1
Operating System	N/A
Operating System Version	N/A
Status	Will Not Be Addressed

Additional Information

ArcGIS Desktop (including ArcGIS Engine and ArcObjects) is in mature support and will be retired March 1, 2026. Mature support means the end of functionality-based patches and hotfixes. Therefore, this issue will not be addressed. There are no plans for future releases of ArcGIS Desktop, and it is recommendedto migrate to ArcGIS Pro. Refer this documentation: https://www.esri.com/en-us/arcgis/products/arcgis-pro/resources/migrate for more information.

Workaround

An ArcGIS client at the same version as the geodatabase may be used to upgrade the geodatabase internals. For cases in which, the Upgrade Geodatabase tool cannot be run against the geodatabase from the same version ArcGIS client, the following workaround has been successful in updating the geodatabase internals. The following workaround requires back-end modification of the geodatabase system tables. A full database backup should be confirmed prior to implementing.

1. Connect to the Oracle 12c geodatabase in SQL Plus or SQL Developer and modify the SDE.VERSION table columns to match those of a ArcGIS 10.6 geodatabase.

2. In ArcCatalog 10.6.1, connect to the Oracle 12c geodatabase as the SDE user and run Upgrade Geodatabase.

3. In SQL Plus/SQL Developer, connect to the 12c geodatabase as SDE, check for for INVALID objects in the SDE Schema and recompile invalid objects as needed.

select object_name from user_objects where status <> 'VALID';

exec sys.utl_recomp.recomp_serial('SDE');

select object_name from user_objects where status <> 'VALID';

4. If Editor Tracking/Enable Archiving still fails in ArcMap and returns the error message: "Failed to enable archiving. Function called out of sequence". Manually rebuild BRANCH_UTIL package.

SQLPLUS sde/password@DatabaseServer/OracleSID

start 'C:\Program Files (x86)\ArcGIS\Desktop10.6\lib\branch_util.sps' SDE;

start 'C:\Program Files (x86)\ArcGIS\Desktop10.6\lib\branch_util.spb' SDE;

grant EXECUTE on sde.branch_util to public;

grant EXECUTE on sde.spx_util to public;