Points from Enterprise Geodatabase not drawing
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?
