We have a PostgreSQL/PostGIS SDE enabled database, but lately there is a strange issue when adding layers from this database to ArcMap or ArcGIS Pro. We can connect to the database without any issues and see all layers present in it. We can drag any layer in ArcGIS, but the layer is not visible in the data/layout view. It is however visible in the Table of Contents without an exclamation mark. We can even look in the attribute table, no problems there. If I select rows, the contours of the selection are visible, but not the polygon itself. Non registered SDE tables from the same database do work, so I have a feeling there is something wrong with ArcSDE. All tables also work in QGIS.

Is there anything I can do? I could not find similar issues online. Maybe there is something corrupt in the SDE registration?

only the selection contour is visible, not the polygon itselfenter image description here

On the pictures above: left how it is now, right picture is how it should be.

EDIT: I am using ArcGIS Desktop 10.5 and ArcGIS Pro 2.1. Postgres is on version 9.4. It was working just fine before, but suddenly it has this strange bug.

  • have you tried using a query layer?
    – ziggy
    May 14, 2018 at 13:58
  • 1
    This is probably a question for Esri Tech Support, since that's not the experience most have with PostgreSQL tables. You might try dropping and rebuilding the spatial index. Please Edit the question to specify the exact versions of software in use.
    – Vince
    May 14, 2018 at 14:14
  • Thanks for the comment. Can I rebuild the spatial index in Postgres without messing up the SDE tables more?
    – user30058
    May 14, 2018 at 14:46
  • Certainly. You can also use ArcGIS tools to drop and rebiuld indexes.
    – Vince
    May 14, 2018 at 14:52
  • If I make a query layer from the same table, the layer is showing properly in ArcGIS. Does this point in some direction of what causes the error?
    – user30058
    May 14, 2018 at 14:57


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.