BUG-000085161 for ArcSDE/Enterprise Geodatabase

Bug ID Number	BUG-000085161
Submitted	February 9, 2015
Last Modified	June 5, 2024
Applies to	ArcSDE/Enterprise Geodatabase
Version found	10.2.1
Version Fixed	10.3.1
Status	Fixed

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.