Bug: Migrate Storage tool drops the feature class when an error is encountered creating the spatial index
【相关信息】
Article ID: 44053
Bug Id: BUG-000085161
Software:
ArcGIS for Desktop Advanced 10.2.1, 10.2.2, 10.3
ArcGIS for Desktop Standard 10.2.1, 10.2.2, 10.3
ArcGIS for Server 10.2.1, 10.2.2, 10.3
Platforms: N/A
【BUG描述】
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 following error message is returned by the tool:
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.
If the user attempts to execute the tool a second time, a new error message is returned:
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)
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.
【BUG原因】
The Migrate Storage geoprocessing tool is mistakenly dropping the feature class when an error is encountered creating the spatial index.
Esri will provide status updates through this Knowledgebase Article until the general patch becomes available.
Article ID: 44053
Bug Id: BUG-000085161
Software:
ArcGIS for Desktop Advanced 10.2.1, 10.2.2, 10.3
ArcGIS for Desktop Standard 10.2.1, 10.2.2, 10.3
ArcGIS for Server 10.2.1, 10.2.2, 10.3
Platforms: N/A
【BUG描述】
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 following error message is returned by the tool:
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.
If the user attempts to execute the tool a second time, a new error message is returned:
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)
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.
【BUG原因】
The Migrate Storage geoprocessing tool is mistakenly dropping the feature class when an error is encountered creating the spatial index.
Esri will provide status updates through this Knowledgebase Article until the general patch becomes available.
1 个回复
EsriSupport
赞同来自:
If this bug is encountered, follow these steps:
【创建及修改时间】
Created: 2/10/2015
Last Modified: 2/20/2015
【原文链接】
http://support.esri.com/en/kno ... 44053
要回复问题请先登录或注册