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; } } }

Failed to compress database, why?

IB1

When I try to compress our versioned SDE geodatabase I get the following error:

[ATTACH=CONFIG]24177[/ATTACH]

We are running ArcGIS Desktop 10.1 with ArcGIS Server 10.1 and SQL Server 2012.

Why would I be getting this error?

error.PNG

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

RickMomsen

This worked perfect for me too, but it took a lot of searching to find this thread.
adding key words for future victims...
Failed to compress the database
Cannot insert the value NULL into column 'compress_id', table SDE_COMPRESS_LOG
column does not allow nulls. INSERT fails

IB1

Take a look at the following link. It has a description of each system table for the geodatabase.

Perfect, thanks.

jskinner

Take a look at the following link. It has a description of each system table for the geodatabase.

IB1

I would recommend deleting the log file, as it keeps track of each database compress. But, if you were to delete it, it would be recreated after your next compress.

Okay, I figured that's what'd you'd say.

Last question ...for now... is there any documentation for what the fields in the log mean?

I've done some searching but can't seem to find anything.

Also, is there any documentation which explains some of the extra tables that I can see within SQL Server?

Like the SDE_versions table, etc.

jskinner

I would recommend deleting the log file, as it keeps track of each database compress. But, if you were to delete it, it would be recreated after your next compress.

IB1

Did you happen to register the SDE_COMPRESS_LOG file with the geodatabase? Try the following:

1. Rename the SDE_COMPRESS_LOG file using the Catalog window to SDE_COMPRESS_LOG_1
2. Execute the compress again

This should recreate a new SDE_COMPRESS_LOG file.

You nailed it.

So, it's alright to just delete the log file after I run the compress each time?

Thanks!

jskinner

Did you happen to register the SDE_COMPRESS_LOG file with the geodatabase? Try the following:

1. Rename the SDE_COMPRESS_LOG file using the Catalog window to SDE_COMPRESS_LOG_1
2. Execute the compress again

This should recreate a new SDE_COMPRESS_LOG file.

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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