ArcMap Drawing errors

[SrinivasaRao1]

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

[DavidPike]

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?

[SrinivasaRao1]

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

[DavidPike]

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]

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.

[DavidPike]

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

[SrinivasaRao1]

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.

[George_Thompson]

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?

[SrinivasaRao1]

Geometry type is Point.

No multiple geometries were available for the same table.

Manually importing or copying data to sde schema.

[DavidPike]

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