Windows 10 20H2 Update Broke DLM?

Madmcs

Hi 

We've been successfully running DLM Dashboard 1.7 for some time now.  Last week I installed the Windows 10 20H2 and since then the DLM Dashboard doesn't seem to be working, its stuck on DLM Dashboard is starting up.

In the Red Gate Software Event Log,  there appears to be numerous errors like:

RedGate.SQLLighthouse.StorageService-1.7.5.1116

01/22/2021 17:50:20 +00:00 [Fatal] An unhandled exception occurred.

System.AggregateException: One or more errors occurred. ---> Autofac.Core.DependencyResolutionException: An exception was thrown while executing a resolve operation. See the InnerException for details. ---> Could not open transactional storage: C:\ProgramData\Red Gate\SQL Lighthouse\RavenDB\Data (See inner exception for details.) ---> System.InvalidOperationException: Could not open transactional storage: C:\ProgramData\Red Gate\SQL Lighthouse\RavenDB\Data ---> Microsoft.Isam.Esent.Interop.EsentInstanceUnavailableException: This instance cannot be used because it encountered a fatal error

   at Microsoft.Isam.Esent.Interop.Api.JetEndSession(JET_SESID sesid, EndSessionGrbit grbit)

   at Microsoft.Isam.Esent.Interop.Session.ReleaseResource()

   at Microsoft.Isam.Esent.Interop.EsentResource.Dispose(Boolean isDisposing)

   at Microsoft.Isam.Esent.Interop.EsentResource.Dispose()

   at Raven.Storage.Esent.TransactionalStorage.Compact(InMemoryRavenConfiguration ravenConfiguration, JET_PFNSTATUS statusCallback)

   at Raven.Storage.Esent.TransactionalStorage.EnsureDatabaseIsCreatedAndAttachToDatabase()

   at Raven.Storage.Esent.TransactionalStorage.Initialize(IUuidGenerator uuidGenerator, OrderedPartCollection`1 documentCodecs)

In the Application Log, there are ESENT errors with:

Raven (25376,R,98) 1-odmAB-C:\ProgramData\Red Gate\SQL Lighthouse\RavenDB\Data: The database format feature version 9180 (0x23dc) could not be used due to the current database format 1568.20.0, controlled by the parameter 0x410022D8 (8920 | JET_efvAllowHigherPersistedFormat).

Raven (25376,R,98) 1-odmAB-C:\ProgramData\Red Gate\SQL Lighthouse\RavenDB\Data: The database [C:\ProgramData\Red Gate\SQL Lighthouse\RavenDB\Data] format version is being held back to 8920 (0x22d8) due to application parameter setting of 0x410022D8 (8920 | JET_efvAllowHigherPersistedFormat). Current default engine version: 9180 (0x23dc).

Raven (25376,D,50) 1-odmAB-C:\ProgramData\Red Gate\SQL Lighthouse\RavenDB\Data:  Out of date NLS sort version detected on the database 'C:\ProgramData\Red Gate\SQL Lighthouse\RavenDB\Data' for Locale 'en-US', index sort version: (SortId=00000001-57ee-1e5c-00b4-d0000bb1e11e, Version=0006020F0006020F), current sort version: (SortId=00000001-57ee-1e5c-00b4-d0000bb1e11e, Version=0006030500060305).

If I rename the RavenDB folder in C:\ProgramData\Red Gate\SQL Lighthouse and restart the DLM services, the dashboard will recreate a blank accessible database and the Dashboard will prompt for all the configuration as its a new install.

Is the database likely to be corrupt, or has anyone any other ideas.

Thanks

David Atkinson

Our reliance of RavenDB as the storage engine was in hindsight a misjudgement. In all honesty it's unlikely that we'll have the capacity to look into this specific issue, and instead we're focusing on trying to reimagine how DLM Dashboard experiences should be experienced and architected today.

What is the primary "job to be done" that DLM Dashboard provides you today, as this insight will help us build the right solution for the future.

DanRouns

I believe most of us are looking for an external/internal audit schema change reporting process. Something that tracks SCHEMA changes and can produce various reports/alerts on any/all changes to any portion of the deployed DBMS.