Migration to st_geometry

2560
5
Jump to solution
04-27-2015 06:42 AM
Highlighted
New Contributor III

I'm trying to migrate from sde_binary to st_geometry (I'm using Oracle and ArcGis 10.1). But some elements are having this issue:

   Error: 000955: Error encountered migrating the database storage of Database Connections\sigelec@DESARROLLO.sde\SIGELEC.Electrico...

   Underlying DBMS Error, Invalid Grid Size: 2nd and 3rd sizes must be at least 3 times larger than previous grid size]

   [SIGELEC.TransformadorDistribucion]

   Failed to execute (MigrateStorage)

Does anyone knows how to help me with this problem? I will appreciate a lot any help...

Thanks,

Teresa

Reply
0 Kudos
1 Solution

Accepted Solutions
Highlighted
New Contributor III

Hi Samuel, the problem with the grid index was resolve, by changing the variable NLS_LANG

Alternate Solution

Temporarily set Oracle Client NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252, then reopen ArcCatalog to copy the feature classes.

http://support.esri.com/en/bugs/nimbus/TklNMDgzODUx

After,this change all is working good

Regards, and thanks a lot for your help

View solution in original post

5 Replies
Highlighted
Occasional Contributor II

Hello Teresa,

That error is most likely being thrown because the grid sizes for the spatial index are invalid. You will have to modify the grid sizes to be within a valid range.

ArcGIS Help 10.1

You can either modify/rebuild the existing spatial index, or you can drop the existing index and create a new spatial index.

In either case, make sure to take a backup before making changes to the indexes.

Hopefully that helps.

Reply
0 Kudos
Highlighted
New Contributor III

Thanks Samuel, I had already make this, but the error continue...I've read that exists a service pack that fix this problema for ArcGis 10.2.2, http://support.esri.com/en/downloads/patches-servicepacks/view/productid/67/metaid/2136    

Does you know if this service pack is aviable for Arc Gis Desktop 10.1.1 ?

Thanks a lot for your help !!
Teresa

Reply
0 Kudos
Highlighted
New Contributor III

Hi Samuel, I have make a remove spatial index, after an add spatial index and after a migrate storage. The problema continue... ...

I've too remove spatial index, and after migrate storage, its Works but when I want to add spatial index after migrate I can't do it.

Thanks, for your help...

Teresa

Reply
0 Kudos
Highlighted
Occasional Contributor II

Hello Teresa,

I dont believe that patch exists for 10.1 SP1. Have you tried the following:

ERROR 000260: Failed to copy

Highlighted
New Contributor III

Hi Samuel, the problem with the grid index was resolve, by changing the variable NLS_LANG

Alternate Solution

Temporarily set Oracle Client NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252, then reopen ArcCatalog to copy the feature classes.

http://support.esri.com/en/bugs/nimbus/TklNMDgzODUx

After,this change all is working good

Regards, and thanks a lot for your help

View solution in original post