Community
Select to view content in your preferred language

Points from Enterprise Geodatabase not drawing

213
2
4 weeks ago
PeriklisPanagiotidis
by
Emerging Contributor
4 weeks ago

I working on Arcgis Pro 3.5.1, Enterprise Geodatabase of Postgres and and an Arcgis Enterprise (Server, Portal)

I have a dataset of about 300k points stored in the enterprise db. The table is rather wide (around 35 columns) with several datatypes (Dates, text, ints, geometry). Some of the columns also have relations and constraints.

I have published the table as a feature dataset with no issues but when I try to publish it as a cached tiled service the caching process fails. The error is that the layer does not render in certain extents.

Looking more into it, I noticed that in Arcgis Pro not all points draw on the map.

Some other clues:

I duplicated the table with SQL and import in in Arcgis Pro and all the points render fine, but when I clicked on "register with the geodatabase" a lot of the points disappeared again.

I also tried to duplicate the table with fewer columns and with some combinations of columns, I get more points to draw but I can not pin point a specific column causing issues because the results are not consistent. With very few columns, all the points draw.

When I zoom in and out of the map some times more points appear/disappear

Any ideas on things to try?

 

The dataset when rendered correctlyThe dataset when rendered correctlyZoomed in (A lot of points are missing)Zoomed in (A lot of points are missing)Zoomed out version( more points but still many missing)Zoomed out version( more points but still many missing)

 

 

 

0 Kudos
2 Replies
TimoT
by
Frequent Contributor
3 weeks ago

Hi @PeriklisPanagiotidis 

It sounds like the points that disappear/appear are different each time, which would make me look at instance configurations first.

Some questions below:

  • Is your feature service configured to use shared instances or dedicated instances?
  • Any ArcGIS Server error logs? Perhaps something along the lines of unable to process request, or instance crashing
  • How many ArcSOCs are running on your ArcGIS Server machine? Refer to this article for the workflow - How to identify the number of ArcSOCs
0 Kudos
PeriklisPanagiotidis
by
Emerging Contributor
3 weeks ago

Hi Timo,

Thanks for having a look.

As I mentioned in my post, the problems start even before I publish the dataset to the server. The screenshots above are from Arcgis Pro that reads the table from the database. 

Responses to your questions:

  • Shared instance
  • When I publish the service I get errors related to caching like this:
Failed to cache extent: -20025278.418261 -30240971.958400 20037507.067200 20025278.418261 at scale 9244648.86861800029873848 
Drawing failure, layer = Layer name, error string = Could not draw layer Layer name
  • There are 21 instances running at the moment.

 

0 Kudos