ArcMap Drawing errors

2009
13
11-05-2020 03:35 AM
SrinivasaRao1
New Contributor III

HI,

Can anyone suggest how to resolve on below issue, snapshot attached.. is this possible to fix in the database.

This was in sde environment in the server. we are using oracle SQL developer for the database.

Thanks,

Srinivas

0 Kudos
13 Replies
DavidPike
MVP Frequent Contributor

without more information this could be caused by many things.  Is it registered to the EGDB and has it got a geometry field and spatial index?

0 Kudos
SrinivasaRao1
New Contributor III

Yes, it is registered and it has got the geometry field and index was there.. any other solution to find out.

0 Kudos
DavidPike
MVP Frequent Contributor

Was the spatial index built in SQL developer? In SQL developer, does the geometry metadata etc line-up with your projection and extent?

Can you read the table in SQL dev and ArcCatalog? and can you preview the geography in Catalog?

What's the history behind this feature, is it a new import, update, have you done something to it recently etc?

If you export the feature to a local FGDB as a FC does it work ok?

SrinivasaRao1
New Contributor III

We are not a built-in SQL developer.

We can read the table in SQL dev and ArcCatalog. We cannot preview the geography in Catalog.

This feature was copied or import from the local file geodatabase and we have checked in FGDB that the feature is opening in ArcMap with geometry in local.

Yes, it does work when we export the feature to a local FGDB as it was seen in local.

0 Kudos
DavidPike
MVP Frequent Contributor

Whats the coordinate systems/projection?  Copying to the sde may be using a configuration keyword or Default which is making funky geometry.

0 Kudos
SrinivasaRao1
New Contributor III

We have 86 layers, out of which 3 are having the same issue (ArcMap Layers, we deleted from sde and again imported, the same issue.

Also, the coordinate system/projection is as below.

0 Kudos
George_Thompson
Esri Frequent Contributor

What is the Geometry type (SDO_Geometry, ST_Geometry, etc.) being used in the feature classes with issues?

Is there multiple geometry types (point / line / poly) in the same table?

How are you importing the data into the Oracle Geodatabase?

--- George T.
SrinivasaRao1
New Contributor III

Geometry type is Point.

No multiple geometries were available for the same table.

Manually importing or copying data to sde schema.

0 Kudos
DavidPike
MVP Frequent Contributor

is the projection in the sde fc the same as that of the local fc.

0 Kudos