topic Re: ERROR 000955: Error encountered migrating the database storage in Data Management Questions

ERROR 000955: Error encountered migrating the database storage

EmadAl-Mousa — Wed, 26 Feb 2014 02:02:47 GMT

Hi,

while performing a "storage migration " of a group of "feature classes" under a feature dataset using the Geoprocessing Tool (Migrate Storage), i receive the following error:

i am facing the following errors:

ERROR 000955: Error encountered migrating the database storage
Insufficient permissions[Feature Class Name]
Failed to execute(MigrateStorage)

My Geodatabase is in Oracle Envrionment (ArcCatalog 10.2), and i am migrating the storage from "SDEBINARY" to "SDELOB".

my connection is through the "schema user" and DBTUNE file have been verified to be OK.

I have attached the snapshot image.

Re: ERROR 000955: Error encountered migrating the database storage

NidhinKarthikeyan — Wed, 26 Feb 2014 04:34:38 GMT

Try to decrease the number of Feature Class in the 'Migrate Storage' tool.

Re: ERROR 000955: Error encountered migrating the database storage

NidhinKarthikeyan — Wed, 26 Feb 2014 04:42:13 GMT

Please let us know the exact version of ArcSDE. There is a bug which was found in ArcSDE 10.0 SP3 and was fixed in ArcSDE 10.1SP1. It was for migrating storage from SDEBINARY to ST_GEOMETRY.

Re: ERROR 000955: Error encountered migrating the database storage

EmadAl-Mousa — Wed, 26 Feb 2014 05:22:53 GMT

ArcSDE Geodatabase is 10.1 SP1

Re: ERROR 000955: Error encountered migrating the database storage

EmadAl-Mousa — Wed, 26 Feb 2014 10:58:43 GMT

The migration process will work with schema user if the user has the follwoing privileges:

GRANT ALTER ANY INDEX TO USER;
GRANT CREATE ANY INDEX TO USER;
GRANT CREATE TABLE TO USER;
GRANT DROP ANY INDEX TO USER;

@nidhinkn Thanks for your support.

Re: ERROR 000955: Error encountered migrating the database storage

EmadAl-Mousa — Wed, 26 Feb 2014 14:06:31 GMT

just last comment....the ESRI documentation doesn't specify the privileges required while performing the storage migration !!!

i have read the following reference documentation:

http://resources.arcgis.com/en/help/main/10.1/index.html#//002n00000076000000
http://resources.arcgis.com/en/help/main/10.1/index.html#//00170000000q000000
http://resources.arcgis.com/en/help/main/10.2/index.html#//002n00000076000000

DBA's usually never grant a schema user "alter any index,drop any index, create any index...etc"

since this a very serious security issue to grant an oracle user "any" permission.

i have reached the conclusion of these required permissions after narrowing it down from "DBA" privilege granting which lead to the successful migration, and gradually revoked privileges unnecessary ones...

it will be great if ESRI can update their documentation.