topic Re: Migration to st_geometry in Geodatabase Questions

Migration to st_geometry

TeresaVillena — Mon, 27 Apr 2015 13:42:46 GMT

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

Re: Migration to st_geometry

SamuelTompsett — Mon, 27 Apr 2015 15:18:14 GMT

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.

Re: Migration to st_geometry

TeresaVillena — Mon, 27 Apr 2015 15:51:51 GMT

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

Re: Migration to st_geometry

TeresaVillena — Mon, 27 Apr 2015 16:32:11 GMT

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

Re: Migration to st_geometry

SamuelTompsett — Mon, 27 Apr 2015 16:34:11 GMT

Hello Teresa,

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

ERROR 000260: Failed to copy

Re: Migration to st_geometry

TeresaVillena — Thu, 07 May 2015 13:14:55 GMT

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