nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Compressing SDE database

MichelleThorne

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

Find more posts tagged with

Accepted answers

George_Thompson

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.

All comments

TylerDuffyETL

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.

MichelleThorne

Thank you

George_Thompson

MichelleThorne

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.

George_Thompson

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"?

MichelleThorne

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.

George_Thompson

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?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.