EHX Data Storage - EHXDatastore.sdf
This information refers only to non client-server installations - the majority of installations.
In Eclipse Configuration System (versions 1 to 5.2.x) the SQL Server Express database EclipseServer.mdf was used to hold configuration information and event logs. CCN files are exported and imported into the database for operation and the SQL Server CLEARCOMXX service has to be running for ECS to work.
Since Eclipse HX (version 7 onwards) the database has been changed into a SQL Compact Edition file, and it no longer contains configuration information - those are stored in memory and in HXN files.
If this EHXDatastore.sdf file becomes large, pages which rely on it, such as the Event Log, will become slow to open and the Save Diagnostics file will be huge.
It is also possible for the SDF file to become locked (by an antivirus program or by a drive compression operation) or corrupt (due to a system crash). Given the SDF file does not contain much valuable information unless an Eclipse issue has occurred, the fastest way to overcome these issues is to overwrite the existing file with a new file from a fresh install.
Files for major software revisions are available from this page - use the version closest to your installation and rename the existing EHXDatastore.sdf to EHXDatastore.old or similar in case of issues.
Additionally, a SDF Repair tool is attached for users who have received the message:
The database file may be corrupted. Run the repair utility to check the database file.
The file will extract the required software. Click the button and choose the EHXDatastore.sdf file for repair.
As the default EHX installation is in the Program Files directory, Windows may need Administrator privileges to run. The SDF file can also be copied to a less protected directory, such as the Desktop, if needed.
If any messages about version compatibility are shown, please install the correct SQL Compact 4 file for your computer from https://www.microsoft.com/en-us/download/details.aspx?id=30709
CAN'T FIND YOUR ANSWER? CLICK HERE TO CONTACT SUPPORT
This solution was provided to you by Clear-Com via a question submitted to us by customers like you. If your question wasn’t answered, you need help or you have a recommended solution for our database, please send us an email at support@clearcom.com
The information on this page is owned by Clear-Com and constitutes Clear-Com’s confidential and proprietary information, may be used solely for purposes related to the furtherance of Clear-Com’ business and shall not be disclosed, distributed, copied or disseminated without Clear-Com’s prior written consent. Click Here for Clear-Com's privacy statement.