Migration to st_geometry

[TeresaVillena]

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

[SamuelTompsett]

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.

[TeresaVillena]

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

[TeresaVillena]

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

[SamuelTompsett]

Hello Teresa,

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

ERROR 000260: Failed to copy

[TeresaVillena · Accepted solution]

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