nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Find more posts tagged with

Accepted answers

TeresaVillena

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

All comments

TeresaVillena

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

SamuelTompsett

Hello Teresa,

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

ERROR 000260: Failed to copy

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

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

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.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.