Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


Mike Burger
2018-11-28T17:11:58Z
I am a trial user running into a problem with the local DB. The logs show this error:

11/28/2018 12:02:20 PM	Debug	GetJobHistory called for Job: NA, fromDate: 11/27/2018 12:02:20 PM, toDate: 11/28/2018 12:02:20 PM
11/28/2018 12:02:20 PM	Err	Could not connect to local database: Unspecified error [ C:\ProgramData\VisualCron\output\log\VisualCron4.sdf ]
11/28/2018 12:02:20 PM	Debug	GetJobHistory in lock
11/28/2018 12:02:20 PM	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 VisualCronService.DBLoggerClass.JKJFHCNIENBMOEKHNNPDACMOCNIBILIDFAPM() in C:\sourcefiles\code\VisualCronService\Log\clsDBLogger.vb:line 105
11/28/2018 12:02:20 PM	Debug	GetJobHistory->Query: SELECT * FROM JobLogs WHERE StartDate > @FromDate AND StartDate < @ToDate AND ExitCodeResult = 2
11/28/2018 12:02:20 PM	Err	Error in GetJobHistory: ExecuteReader requires an open and available Connection. The connection's current state is Closed.
11/28/2018 12:03:25 PM	Err	Could not connect to local database: Unspecified error [ C:\ProgramData\VisualCron\output\log\VisualCron4.sdf ]
11/28/2018 12:03:25 PM	Err	Error in GetLogDBStats: Could not find file 'C:\ProgramData\VisualCron\output\log\VisualCron4.sdf'.
11/28/2018 12:03:29 PM	Err	Could not connect to local database: Unspecified error [ C:\ProgramData\VisualCron\output\log\VisualCron4.sdf ]
11/28/2018 12:03:29 PM	Err	Error in GetLogDBStats: Could not find file 'C:\ProgramData\VisualCron\output\log\VisualCron4.sdf'.


The problem is, that's not where the file is, and the Database Info location seems to be unchangeable in settings. How do I change the database location?
Sponsor
Forum information
Support
2018-11-29T07:52:13Z
Thanks for the report! We will look at how this could happen.

Can you manually copy from log folder of installation folder to: C:\ProgramData\VisualCron\output\log\ (you might need to create the log directory). After that, please restart the VisualCron service.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Mike Burger
2018-11-29T14:20:42Z
Just thought I would point out I solved the problem. Didn't realize I needed to stop and start the service. Once I did that, the DB was found.
Scroll to Top