ArcGIS Pro Enterprise 10.9.1: Compressing an enterprise geodatabase (SQL Server) fails to transfer the content of delta table into the base table,
I have already posted this issue in the past but got no root solution.
Not sure why compressing an enterprise geodatabase (SQL Server) fails to transfer the content of delta tables (Add\delete) into the base table. I expect that the delta tables should get blank while all edits are transferred to the base table
What could be the issue here?
Are you compressing the database to state 0? I believe there are multiple ways to compress a database, but to ensure that all adds and deletes are moved to the base table, you need to ensure the database is compressed to state 0.
Review your states table and look for other community posts on this subject.
Correct. I wanted to compress the geodatabase to state 0
Here are some links to review that might be helpful:
Most applicable I believe - https://community.esri.com/t5/data-management-questions/enterprise-geodatabase-states-will-not-compr...
I went through several documents related to compressing but didn’t find what I’m encountered in.
In the screenshots of my first post, there is a difference between the number of records of the attribute table of the feature class and its corresponding the base table despite the fact that the compress tool is performed.
How to get them (the attribute table of the feature class and its corresponding base table) identical in terms of number of records?
Ne versions are there as per the second screenshot
What does your dbo.versions table look like?
There must be something pinning the state. Have you run the reconcile / post tool yet?
Are you only editing in dbo.DEFAULT version?
Are there any locks on the tables?
Have you run the reconcile / post tool yet?
No, as I don’t have versions
Are you only editing in dbo.DEFAULT version?
Correct
Are there any locks on the tables?
No
What is in the dbo.versions table in SSMS?
Something is blocking the full compress.
Here you go a screenshot for the version
Ok, thanks. You should be able to get a full compress.
Not sure why it is not happening.