Hello,
Our production server is not logging any history to the internal SQL DB but our Dev server is. I need help on what to try to fix this. We are on server version 9.9.10 but previously it was 9.1.5 and that's when the SDF file was created I believe.
The file is there, the security permissions seem to match Dev, but no connection is coming through. Due to that, VC shows default 0 counts for records and dates of 1/1/0001. The file itself is 21 MB.
Here are some relevant startup logs showing a generic error using the DB:
4/20/2023 4:41:25 AM Debug StartDBLoggerThread - enter
4/20/2023 4:41:26 AM Debug Client.InitializeMessageXmlSerializer() - after
4/20/2023 4:41:26 AM Info ConnectDatabase->Connecting to internal DB: C:\ProgramData\VisualCron\output\log\VisualCron4.sdf
4/20/2023 4:41:27 AM Err GetConnection->Error: System.Data.SqlServerCe.SqlCeException (0x80004005): Unspecified error [ C:\ProgramData\VisualCron\output\log\VisualCron4.sdf ]
at System.Data.SqlServerCe.SqlCeConnection.Open(Boolean silent)
at System.Data.SqlServerCe.SqlCeConnection.Open()
at ProductSpecification.RestartDispatcher(Object , ProductSpecification )
at VisualCronService.DBLoggerClass.CancelAccount(DbConnection first) in C:\git\code\VisualCronService\Log\clsDBLogger.vb:line 970
4/20/2023 4:41:27 AM Err ConnectDatabase-> not connect to local database: ExecuteScalar requires an open and available Connection. The connection's current state is Closed.
4/20/2023 4:41:27 AM Debug StartDBLoggerThread - exit
4/20/2023 4:41:27 AM Debug CleanLocalDB started (True)
4/20/2023 4:41:27 AM Info Cleaning up local database according to cleanup rules
4/20/2023 4:41:27 AM Debug CleanLocalDB - retrieve stats - start
4/20/2023 4:41:27 AM Info ConnectDatabase->Connecting to internal DB: C:\ProgramData\VisualCron\output\log\VisualCron4.sdf
4/20/2023 4:41:27 AM Err GetConnection->Error: System.Data.SqlServerCe.SqlCeException (0x80004005): Unspecified error [ C:\ProgramData\VisualCron\output\log\VisualCron4.sdf ]
at System.Data.SqlServerCe.SqlCeConnection.Open(Boolean silent)
at System.Data.SqlServerCe.SqlCeConnection.Open()
at ProductSpecification.RestartDispatcher(Object , ProductSpecification )
at VisualCronService.DBLoggerClass.CancelAccount(DbConnection first) in C:\git\code\VisualCronService\Log\clsDBLogger.vb:line 970
There are many other log errors trying to connect to the DB to write events and they just have "unspecified error" and "requires open connection" messages.
I've tried changing the filepath for this database but it seems VC is hardcoded and won't let you.
There isn't anything on the production database that we want, so I wouldn't mind wiping it clean. I just don't if deleting the file will make VC regenerate it or how to go from here.
Please advise how to get this database reset or so that it will start logging again.
Thank you,
Geoff