topic SDE Compression End State Count Issue in Data Management Questions

SDE Compression End State Count Issue

ClaytonCooley2 — Tue, 14 Mar 2017 12:24:19 GMT

For the past few months I've been having an issue getting my SDE Compression End State Count down to "1". It acts like there are connections but I've checked everything I can think of but it won't go any lower than 5. Any suggestions?

I've attached a screenshot for reference.

https://community.esri.com/groups/geodatabase?sr=search&searchId=960f8a53-d2fd-4599-802e-651564f1fb42&searchIndex=0‌ https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=a3c6e9ce-91a1-4144-b0ab-1eb60658fd42&searchIndex=0‌

Re: SDE Compression End State Count Issue

RobertScheitlin__GISP — Tue, 14 Mar 2017 12:44:24 GMT

Clayton,

Do you have a replica based on this database (check the sde.SDE_versions table)? What does your sde.SDE_state_locks and sde.SDE_table_locks look like? See who is the owner of state 5 in your sde.SDE_states table and then check that machine for a hung ArcMap.exe or ArcCatalog.exe

Re: SDE Compression End State Count Issue

RebeccaStrauch__GISP — Sat, 11 Dec 2021 21:26:26 GMT

Interesting, I have never paid much attention to that value in the compress_log. We have SQL, and I run a few selects in Management Studio where I track things. In case this gives you any clues:

use mysde_database
select name, owner, version_id, state_id, parent_name, parent_owner from [mysde_database].[dbo].[SDE_versions]
select * from  [mysde_database].[dbo].[SDE_versions]
select * from [mysde_database].[dbo].[SDE_states] order by state_id
select * from [mysde_database].[dbo].[sde_state_lineages] order by lineage_name, lineage_id
/* now I've added */
select TOP(5) * from [mysde_database].[dbo].[SDE_compress_log] order by compress_end DESC‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I also use the "hack" install the old GDBT toolset to view the version-Lineage within Catalog.

edit: use SQL syntax highlighter and added TOP(5) to last line, to limit number of records returned from the compress_log query.

Re: SDE Compression End State Count Issue

ManviLather1 — Tue, 21 Mar 2017 18:29:03 GMT

Hello,

Please check the following:

1)From sde_version table check if there are any existing version?

If any version represents, reconcile and post all the edits and delete the version.

If sync_send version is present then from ArcCatalog, unregister the replica.

2)From sde_process_information table check if any user is connected to the geodatabase?

3)Shut down the map services, if any.

4)Check below tables if any lock exist:

SDE_table_locks;
SDE_layer_locks;
SDE_object_locks;
SDE_state_locks;