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.
Article ID:000014135
Software:
- ArcGIS Server
Get help from ArcGIS experts
Download the Esri Support App
Related Information
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback