Spectrus DB: Enterprise Server cannot connect to the Remote database due to Incorrect database schema version

Description

When attempting to connect to a database schema in Enterprise Server Manager Console (ESMC), the following error message appears:

"Incorrect database schema version, expected: [x], but was: [y]."

This error occurs when the ESMC version does not match the Spectrus DB schema version. It typically happens if:

• ESMC is launched from an older installation directory while a newer version of Spectrus DB Enterprise Server is present.
• Multiple versions of Spectrus DB Enterprise Server are installed on the same machine, and the wrong ESMC executable is used.

Solution

1. Confirm the Error

Verify that the error message explicitly states a schema version mismatch (e.g., "expected: 2023.1, but was: 2022.2").

2. Identify the Latest Installation

• Check for multiple installations of Spectrus DB Enterprise Server on the machine.
• Locate the latest version by comparing installation directories (e.g., C:\ACD\SpectrusDB_2023.1\ vs. C:\ACD\SpectrusDB_2022.2\).

3. Launch ESMC from the Correct Directory

• Navigate to the latest installation folder of Spectrus DB Enterprise Server.
• Open ESMC.exe from the \SPECTRUSDB.SRV\ subdirectory.

4. Update Shortcuts (Optional)

• Modify existing desktop or Start Menu shortcuts to point to the latest ESMC executable.
• Consider removing or archiving older installations to avoid confusion.

5. Retry the Connection

• Launch ESMC from the correct directory and attempt to connect to the database schema again.

6. Escalation Steps

If the issue persists:

• Note the expected and actual schema versions from the error message.
• Contact Revvity Signals Support and provide:
  • The exact error message.
  • The versions of Spectrus DB Enterprise Server and ESMC in use.
  • Steps already attempted to resolve the issue.