I am able to view the attribute table without any errors when I connect the database using Arcmap.
Any idea on the issue?
Thanks in advance
Which versions are you working with? Is that a PostGIS database by any chance?
Without further details, I surmise the problem is related to validation: Database data and ArcGIS—Help | ArcGIS Desktop
I am working with ArcGIS Pro 2.3.0 and yes it is a PostGIS database.
All right. I think that you're running into a flavor of this limitation: BUG-000119406: The error message, "Shape Integrity Error" is return..
The root cause would appear to be the validation checks. The easiest workaround is to use a version of ArcMap lower than 10.6.1 or a version of ArcGIS Pro lower than 2.2.
Alternatively, you could import that same data into a SDE-enabled database (Enterprise Geodatabase) and it should load without issue.
Having new tables created that work okay makes sense as they are using newer rules
Have you also attempted to test the integrity of the geometries with ST_IsSimple? ST_IsValid does not garantuee that there are no self intersections. I would recommend double checking with both ST_IsValid and ST_IsSimple, unless you have a specific reason to allow self intersections in another application that creates or manages the original data:
Note that polygons are considered by definition simple, according to this help page, so this advice is especially for line feature classes:
Marco Boeringa thanks for your advice, but it's not better.
All my features are simple ("NOT ST_IsSimple" return nothing).
Instead of make data valid (ST_MakeValid) I delete them. But ArcMap and ArcGIS Pro always throw the same error.
Retrieving data ...