ArcSDE layers does not draw but can be selected

2772
9
08-24-2015 07:06 AM
Highlighted
Regular Contributor II

Hello

We have some strange layer in ArcSDE (Oracle11g, ArcSDE 10.1) that does not draw on screen without any error message (single symbol).

When you select the features the selected features is drawn in the selected color only.

The attribute table looks fine.

Any ideas?

Thanks

Reply
0 Kudos
9 Replies
Highlighted
Regular Contributor III

Try rebuilding the Spatial Index.

Export that layer to a File gdb and check if that behaves the same there.

Reply
0 Kudos
Highlighted
Esri Esteemed Contributor
  • What geometry storage format is used?
  • What entity types does the table support?
  • How many total features in the layer?
  • What layer metadata exists for the table?
  • Are there any messages is the connection/direct connection logfiles?
Reply
0 Kudos
Highlighted
Regular Contributor II

Hi all

I have tried to rebuild indexes - it did not worked.

We have the problem with a few layers. Most of them are polyline layers in st_geometry with a few hadreds features.

There are some messages in the logs when you try to select but no error about the drawing.

What do you mean by metadata? - there are about 30 attributes from diffrent types.

Thanks

Mody

Reply
0 Kudos
Highlighted
Honored Contributor

Try exporting it into a new feature class, and check if the issue still persists.

Reply
0 Kudos
Highlighted
Esri Esteemed Contributor

Messages about selection are messages about drawing -- Nothing is drawn if it isn't successfully queried first.

Layer metadata includes envelope, coordinate reference, supported entity flags,...

The idea is to give us enough information to help find the problem.  The level of detail which is likely needed to solve this indicates that you should contact Tech Support.

- V

Reply
0 Kudos
Highlighted
Esri Notable Contributor

I've seen similar problems posted before in the forums but haven't been able to find the threads.

Summary of issue: features are not drawn in ArcMap, but if you select them in the attribute table (maybe also by drawing a selection box?), the selection graphics do draw.

Mody, could there be a reference scale set on the layers?

Ah, I was using a ill-formed search. Here's a similar issues:

Features in Shapefile Don't Display in ArcMap But Exist in Attribute Table

Melita

Reply
0 Kudos
Highlighted
Regular Contributor II

After some more testing it looks like Oracle does not always return the same results on this table.

When you query for drawing it return one result, when you query for attribute table it return different results.

They have some complex security setting, they will have to test it some more.

Thanks

Highlighted
Regular Contributor

Does the same thing happen if you load the layer into a blank map with no other layers loaded?

Reply
0 Kudos
Highlighted
New Contributor III

Hi my friends,

I have the same question than Mody did back to 2015...

---

I have a layer in ArcSDE (Oracle11g, ArcSDE 10.1) that does not draw on screen without any error message.

When you select the features from "Attribute Table" and click on "Zoom To Selected" the selected features is drawn in the selected color only, I mean: It is drawn only boarding of polygons as attached picture (have a look below).

The attribute table looks fine.

--

I have exported that layer to a shapefile and for my surprise ALL features have been drawed fine. For shapefile there is no problem.

 

Any ideas?

Thanks

SDE Layer does not drawn in ArcMap or ArcCatalog

Reply
0 Kudos