topic Re: Unable to import these polygons to SDE on Oracle in ArcGIS Enterprise Questions

Unable to import these polygons to SDE on Oracle

FilipKrál — Mon, 21 Jul 2014 16:16:35 GMT

Hello,

I am having hard time importing the three attached polygons to Oracle SDE with SDO_GEOMETRY data type (configuration keyword).

No matter what I try, ArcMap crashes with a Windows massage "ArcMap has stopped working" and I have to "close the program".

Import as SDEBINARY works. We have been using SDO_GEOMETRY for everything else and I imported similar polygons as SDO_GEOMETRY successfully before using the Feature Class to Feature Class tool and Copy Features Tool too.

It seems the crash occurs because of the large parts in the polygons, but the largest part has some 11000 vertices, which should be way below the limit.

I would very much appreciate if someone with SDE (ideally on Oracle) tried to import them and let me know if it works. Any ideas what might be wrong with the polygons?

Using Check Geometry and Repair Geometry made no difference.

I am using ArcGIS for Desktop 10.1 and Oracle 11g with SDE 10.0.

Regards,

Filip

Re: Unable to import these polygons to SDE on Oracle

AsrujitSengupta — Mon, 21 Jul 2014 17:16:30 GMT

I can import the attached shapefile w/o any issues with the below configuration:

Desktop 10.1 SP1 QIP

SDE 10.1 gdb

Oracle 11.2.0.1

Re: Unable to import these polygons to SDE on Oracle

JakeSkinner — Mon, 21 Jul 2014 19:42:00 GMT

Hi Filip,

I was able to successfully import the feature classes as well using:

ArcGIS 10.2.2

ArcSDE 10.2.2

Oracle 11.2.0.3 - 64 bit

I exported out the feature class as an SDE export (version 10.0) if you want to try to import the features using command line. Ex:

sdeimport -o create -l testing_polygons,shape -f c:\temp\polygon_exp -i sde:oracle11g:orcl -u gis -p gis -k SDO_GEOMETRY

Re: Unable to import these polygons to SDE on Oracle

FilipKrál — Wed, 23 Jul 2014 15:04:53 GMT

Thank you both for checking.

I still have the same problem but at least thanks to you I know the problems is not in the feature class.

I'll post a solution back here if I ever figure out what the problem was.

Filip.

Re: Unable to import these polygons to SDE on Oracle

FilipKrál — Wed, 23 Jul 2014 16:05:59 GMT

Aha!

It seems the problems occurred due to incompatibility between ArcGIS for Desktop 10.1 SP1 and ArcSDE 10.0.

I successfully imported the polygons with ArcMap 10.0 and ArcSDE 10.0

Again, many thanks for looking into this, it is much appreciated.

Filip.