topic Failed to compress database, why? in Data Management Questions

Failed to compress database, why?

IB1 — Thu, 09 May 2013 18:47:23 GMT

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?

Re: Failed to compress database, why?

JakeSkinner — Fri, 10 May 2013 14:06:55 GMT

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.

Re: Failed to compress database, why?

IB1 — Fri, 10 May 2013 18:20:39 GMT

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!

Re: Failed to compress database, why?

JakeSkinner — Fri, 10 May 2013 18:43:50 GMT

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.

Re: Failed to compress database, why?

IB1 — Fri, 10 May 2013 19:02:09 GMT

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.

Re: Failed to compress database, why?

JakeSkinner — Mon, 13 May 2013 09:42:38 GMT

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

Re: Failed to compress database, why?

IB1 — Mon, 13 May 2013 11:22:18 GMT

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

Perfect, thanks.

Re: Failed to compress database, why?

RickMomsen — Wed, 11 Dec 2013 21:35:26 GMT

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