laptop and a wrench

Bug

When running the Migrate Storage tool and converting from SDELOB to ST_Geometry, the S table and base table is dropped if the tablespace is unable to extend during the creation of the spatial index.

Last Published: February 17, 2015 ArcSDE/Enterprise Geodatabase
Bug ID Number BUG-000085161
SubmittedFebruary 9, 2015
Last ModifiedJune 5, 2024
Applies toArcSDE/Enterprise Geodatabase
Version found10.2.1
Version Fixed10.3.1
StatusFixed

Description

The Migrate Storage geoprocessing tool drops the feature class being migrated if the process encounters an error when creating the spatial index. The issue only impacts feature classes stored in Oracle that are being migrated from compressed binary geometry to ST_Geometry. When the bug is encountered, the tool returns the following error message:
Code:
Executing: MigrateStorage 'Database Connections\Connection to TRUENORTH.sde\BOB.PARCELS' DEFAULTS
Start Time: Sat Feb 07 22:15:14 2015
ERROR 000955: Error encountered migrating the database storage of Database Connections\Connection to TRUENORTH.sde\BOB.PARCELS..
Underlying DBMS error [Error executing PL/SQL Block db_stgeom_create_index_by_schema::-ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-01654: unable to extend index BOB.S2$_IX1 by 128 in tablespace USERS] [BOB.PARCELS]
Failed to execute (MigrateStorage).
Failed at Sat Feb 07 22:19:21 2015 (Elapsed Time: 4 minutes 7 seconds)


When the error message includes the statement "[Error executing PL/SQL Block db_stgeom_...]", this indicates the tool failed when creating the spatial index and the feature class was dropped.

Executing the tool a second time returns a new error message:
Code:
Executing: MigrateStorage 'Database Connections\Connecton to TRUENORTH.sde\BOB.PARCELS' DEFAULTS
Start Time: Sat Feb 07 22:22:56 2015
ERROR 000955: Error encountered migrating the database storage of Database Connections\Connecton to TRUENORTH.sde\BOB.PARCELS..
DBMS table not found [ORA-00942: table or view does not exist] [BOB.PARCELS]
Failed to execute (MigrateStorage).
Failed at Sat Feb 07 22:23:00 2015 (Elapsed Time: 4.89 seconds)

Note:
Before performing a data migration, always create a backup of the database. For more information on migration requirements, see Data migration from one storage type to another.

Cause

The Migrate Storage geoprocessing tool is mistakenly dropping the feature class when an error is encountered creating the spatial index.

Workaround

This bug is fixed in the ArcGIS for (Desktop, Engine, Server) Migrate Storage for Oracle Patch. Download the patch, and follow these steps.

  1. Restore the database backup.
  2. Apply the above patch on the machine from which the Migrate Storage tool is run.
  3. Re-run the Migrate Storage tool.

Steps to Reproduce

Bug ID: BUG-000085161

Software:

  • ArcSDE/Enterprise Geodatabase

Get notified when the status of a bug changes

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options