English

Problem: Unable to compress a geodatabase in ArcGIS for Server

Description

When attempting to compress a geodatabase using the Compress geoprocessing tool, the following generic error is returned:

Error:   
Failure to access the DBMS server[[Microsoft][ODBC Driver [version] for SQL Server] Communication link failure[dbo.DEFAULT][STATE_ID = [ ID ]] Underlying DBMS error[dbo.DEFAULT].
For example:
Failure to access the DBMS server[[Microsoft][ODBC Driver 13 for SQL Server] Communication link failure[dbo.DEFAULT][STATE_ID = 46550] Underlying DBMS error[dbo.DEFAULT].

Cause

This issue occurs because the sdedc_SQL_Server.log of the index of the feature class in the geodatabase is corrupted.

Note:
The sdedc_SQL_Server.log file can be used to check for extended error messages. The location of the log file can be found in: C:\Users\[username]\AppData\Local\Temp

Solution or Workaround

Use the Rebuild Indexes tool to resolve this issue. The Rebuild Indexes tool re-creates the indexes and updates the database statistics for the tables in the .db. To locate the Rebuild Indexes tool, navigate to ArcCatalog > Toolboxes > SystemToolboxes > Data Management Tools > Geodatabase Administration > Rebuild Indexes. For more information on how to use the Rebuild Indexes tool, refer to the following ArcGIS Web Help topic: Rebuild Indexes.

Note:
A recommended workflow for administrators is to frequently reconcile and post, compress the geodatabase, then run the Analyze Datasets and Rebuild Indexes geoprocessing tools.

Related Information