topic Re: Compressing SDE database in Data Management Questions

Compressing SDE database

MichelleThorne — Wed, 23 Jun 2021 11:30:24 GMT

I am working in ArcGIS Desktop, 10.8.1 version, on Windows 10. We discovered recently that when compressing the SDE database we are not compressing to 1. We compress to 2.

We were told it is a bug and weren't sure when, or if this would be corrected but everything works in ArcPro.

Is this true that ArcGIS Desktop, 10.8.1 is unable to compress to 1?

Thanks,

Michelle

Re: Compressing SDE database

George_Thompson — Wed, 23 Jun 2021 12:44:42 GMT

I would say compressing to 1 or 2 is a good thing. Is there a specific reason you are trying to get to "1"?

Do you have a bug # for reference?

Re: Compressing SDE database

MichelleThorne — Wed, 23 Jun 2021 13:07:57 GMT

BUG-000136627 : Diagnose Version Tables and Repair Version Tables fail and return Error 999999 when the sde_tables_locks table has the tables_locks_fk foreign key constraint.

Re: Compressing SDE database

George_Thompson — Wed, 23 Jun 2021 13:11:17 GMT

That defect does not impact the compress function. It is also listed as fixed at ArcGIS Pro 2.8.x

Are you having any performance issues after the compress to "2"?

Re: Compressing SDE database

MichelleThorne — Wed, 23 Jun 2021 13:20:35 GMT

No issues I am aware of. We just spent months with ESRI technician trying to get to 1. It seemed important to the technician and the result was a somewhat work around, that may or may not always work, and that it is a bug, that may or may not get fixed by ESRI.

The solution the tech gave, just seemed a bit vague, and we wondered it others were having issues, too. And how important is it to compress to 1?

We do not work in ArcGISPro.

Re: Compressing SDE database

George_Thompson — Wed, 23 Jun 2021 13:42:06 GMT

Getting to state "0" is a good thing, but not necessary. As long as the compress is successful and there not performance issues after, then state "2" is fine.

Here is a great article that talks about getting a full compress when the EGDB has replicas: https://community.esri.com/t5/esri-technical-support-blog/tips-for-compressing-with-existing-geodatabase-replicas/ba-p/898380

I also know that you do not work in Pro, but I would start to look at migrating to using it.

Re: Compressing SDE database

MichelleThorne — Wed, 23 Jun 2021 13:45:14 GMT

Thank you

Re: Compressing SDE database

TylerDuffyETL — Thu, 24 Feb 2022 19:15:57 GMT

Commenting to let folks know: This bug report is intended to address the issue in ArcGIS Pro, but it worked for me on ArcGIS Desktop 10.8.1 as well.