Problem: Unable to compress a geodatabase in ArcGIS for Server
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].
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.
- Microsoft Web Help: "General Network error," "Communication link failure," or "A transport-level error" message when an application connects to SQL Server
- ArcGIS Blog: Resources for rebuilding indexes and updating statistics in an SDE geodatabase
- ArcGIS Web Help: Rebuild dataset indexes using the Rebuild Indexes tool