topic Re: Failed to Compress the database - ERROR 999999 in Geodatabase Questions

Failed to Compress the database - ERROR 999999

wilcow — Tue, 09 Mar 2021 15:04:05 GMT

ArcGIS Desktop version 10.6

SQL Server 2014

attempting to compress the DB and I get the following:

ERROR 999999: Error executing function.
Underlying DBMS error [dbo.DEFAULT]
Failed to execute (Compress).

I deleted all versions and killed all connections, but the error persists.

SDE_compress_log shows FAILURE -51 in compress_status and end_state_count is sky high.

I assume the state count is what's causing the problem, but I'm at a loss as to how to fix it.

I know there's a ton of posts about Failure to Compress, but most of them have explicit errors to work from.

I've used Analyze Datasets, and Diagnose Version tables ("0 multiversioned tables had orphaned, duplicate, missing or redundant rows")

Any advice on troubleshooting would be appreciated.

Re: Failed to Compress the database - ERROR 999999

DrVSSKiran — Tue, 09 Mar 2021 16:03:52 GMT

Hi,

Check on below link.

https://gis.stackexchange.com/questions/377883/executeerror-error-999999-error-executing-function-failed-to-execute-createf

Re: Failed to Compress the database - ERROR 999999

wilcow — Tue, 09 Mar 2021 16:23:47 GMT

Thanks but that seems to refer to a Create FGDB script in Python.

I don't see how it would help in this situation.

Am I missing something?

Re: Failed to Compress the database - ERROR 999999

George_Thompson — Tue, 09 Mar 2021 18:15:33 GMT

It may be best to work with technical support on this issue.

Re: Failed to Compress the database - ERROR 999999

wilcow — Tue, 09 Mar 2021 18:29:35 GMT

Yeah I guess so.

When I run the Compress GP Tool in Pro that's what it tells me as well.

Re: Failed to Compress the database - ERROR 999999

DrVSSKiran — Tue, 09 Mar 2021 18:51:20 GMT

Have you tried this work arround.

Try once these settings before you compress the DB.

On the machine where SQL Server is installed, navigate to Start > Programs > Microsoft SQL Server > SQL Server Management Studio.
Highlight and right-click the instance and click Properties.
In the Server Properties window:
A. Select 'Permissions'.
B. Highlight the 'sde' user. Verify the user has 'View Server State' permission available.
C. Click the check box under 'Grant' for the 'View Server State' permission

Re: Failed to Compress the database - ERROR 999999

wilcow — Wed, 10 Mar 2021 20:22:09 GMT

checked and the SDE user did not have View Server State granted.

so i granted the View Server State permission but still get the same error.

Re: Failed to Compress the database - ERROR 999999

WilliamRice — Sun, 09 May 2021 20:00:38 GMT

Also check the Windows Sever Event logs. If the compress failure is due to a SQL Server database table or index issue then the compress failure will often register a useful error message in the event logs.

Re: Failed to Compress the database - ERROR 999999

wilcow — Fri, 14 May 2021 14:02:38 GMT

fixed this with the help of tech support - the anonymous error referred to some orphaned locks in a couple of tables. we found them by searching SDE_state_locks and SDE_table_locks tables and deleting any locks that weren't present in SDE_process_information table