ArcGIS Pro Enterprise 10.9.1: Compressing an enterprise geodatabase (SQL Server) fails to transfer the content of delta table into the base table,

[JamalNUMAN]

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?

[JamalNUMAN]

I think the issue can be replicated easily as I tried it several times from scratch but I got the same result. After performing the “compress”, the number of records of base table doesn’t match their corresponding attribute table of the feature class

[George_Thompson]

If you have a repro case, I would log a case with tech support to investigate and report back to development, if appropriate.

[JamalNUMAN]

I referred to other threads and found out that we need three tools in order to match the attribute table with its base table; they are “compress”, “rebuild index” and “analyze dataset”. The model needs to run twice to get them identical (attribute table + base table)

Not sure what’s the secret here!

[George_Thompson]

I am not sure how rebuild indexes and analyze datasets would prevent the compress from happening. That is weird.

Glad to know that running the tool twice fixed it but should not take 2 times.