ERROR 000955: Error encountered migrating the database storage

2430
5
Jump to solution
02-25-2014 06:02 PM
Highlighted
Occasional Contributor III
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.
Reply
0 Kudos
1 Solution

Accepted Solutions
Highlighted
Occasional Contributor III
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.

View solution in original post

Reply
0 Kudos
5 Replies
Highlighted
Regular Contributor II
Try to decrease the number of Feature Class in the 'Migrate Storage' tool.
Reply
0 Kudos
Highlighted
Regular Contributor II
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.
Reply
0 Kudos
Highlighted
Occasional Contributor III
ArcSDE Geodatabase is 10.1 SP1
Reply
0 Kudos
Highlighted
Occasional Contributor III
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.

View solution in original post

Reply
0 Kudos
Highlighted
Occasional Contributor III
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.
Reply
0 Kudos