PROBLEM

Unable to compress a geodatabase in ArcGIS for Server

Last Published: April 25, 2020

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.

Article ID: 000014135

Software:
  • ArcGIS Server

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options