laptop and a wrench

Bug

The 'sdeexport' file from ArcSDE on Informix fails to 'sdeimport' in ArcSDE on Oracle with 'init' and 'append' options throwing an INCOMPATIBLE_SCALE_XY error.

Last Published: December 16, 2014 ArcSDE/Enterprise Geodatabase
Bug ID Number NIM047727
SubmittedAugust 24, 2009
Last ModifiedApril 2, 2025
Applies toArcSDE/Enterprise Geodatabase
Version found9.3.1
Operating SystemWindows OS
Operating System Version2003
StatusWill Not Be Addressed

Additional Information

The 10.2.x releases are the last releases that include the command tools, Please use the new Geodatabase Administration GP tools introduced at 10.1.

Workaround

1. Create STATE10 layer using the following command: sdeimport -o create -t STATE10 -i 5251 -u sde -p sde -f co_state.sdx 2. Create another layer called STATEWY using the same command: sdeimport -o create -t STATEWY -i 5251 -u sde -p sde -f wy_state.sdx 3. Convert STATEWY to a shape file. From ArcCatalog, right click on STATEWY > Export > To Shapefile (Single or Multiple) or you can also use sde2shp command. 4. Once STATEWY is converted to a shp file, use "shp2sde -o append" command to append to STATE10 layer. shp2sde -o append -l STATE10,shape -f WY.shp -u sde -p sde -i 5251 5. Now you will see both WY and CO in STATE10 layer. The only downside of this workaround is that you might have to repeat steps 2-4 for all the sdx files you have.

Steps to Reproduce

Bug ID: NIM047727

Software:

  • ArcSDE/Enterprise Geodatabase

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options