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

1474
13
09-25-2022 01:44 AM
JamalNUMAN
Legendary Contributor

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?

 

Clip_232.jpgClip_233.jpgClip_234.jpg

----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
0 Kudos
13 Replies
MichaelVolz
Esteemed Contributor

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.

JamalNUMAN
Legendary Contributor

Correct. I wanted to compress the geodatabase to state 0

----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
0 Kudos
JamalNUMAN
Legendary Contributor

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

Clip_237.jpg

Clip_238.jpg

 

----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
0 Kudos
George_Thompson
Esri Frequent Contributor

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?

--- George T.
JamalNUMAN
Legendary Contributor

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

----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
0 Kudos
George_Thompson
Esri Frequent Contributor

What is in the dbo.versions table in SSMS?

Something is blocking the full compress.

--- George T.
JamalNUMAN
Legendary Contributor

Here you go a screenshot for the version

 

Clip_247.jpg

----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
0 Kudos
George_Thompson
Esri Frequent Contributor

Ok, thanks. You should be able to get a full compress.

Not sure why it is not happening. 

--- George T.