After several years of flawless operation i have a problem. Every week or so for the past few weeks I notice that my jobs are not running. The Tray Client is loaded and when I open it the server is running but there are no jobs in the list! Today (31st) I noticed it again and the solution I have used is to import the most recent backup zip which I found was dated 5/26 at 11pm which is the last day any jobs executed. After importing the jobs it runs fine for a few days.

Here is my server_startup log

5/28/2012 3:22:39 AM Debug Starting up
5/28/2012 3:23:02 AM Debug Loading settings
5/28/2012 3:23:03 AM Debug Preparing SqlCe files (x64) from base folder: C:\Program Files (x86)\VisualCron\x64\sqlce
5/28/2012 3:23:28 AM Debug Prepare interaction
5/28/2012 3:23:42 AM Debug Credential provider was already installed.
5/28/2012 3:23:42 AM Debug Credential provider failed: ControlAltDeleteDisabled is false. Need to be set to true.
5/28/2012 3:23:42 AM Debug Prepare XML writer settings
5/28/2012 3:23:44 AM Debug Create directories
5/28/2012 3:23:44 AM Debug Output folder: C:\ProgramData\VisualCron\output
5/28/2012 3:23:44 AM Debug Startup function called
5/28/2012 3:23:45 AM Info VisualCron - Server: 6.1.1 - build: 14806 - protocol: 6.0.9
5/28/2012 3:23:48 AM Info Cleaning up local database according to cleanup rules
5/28/2012 3:23:56 AM Debug Startup path: C:\Program Files (x86)\VisualCron
5/28/2012 3:23:57 AM Debug Loading license file
5/28/2012 3:23:58 AM Debug License file was succesfully loaded
5/28/2012 3:23:58 AM Debug Saving license file
5/28/2012 3:23:58 AM Debug License file was saved successfully
5/28/2012 3:23:58 AM Debug Successful verification of Activation code
5/28/2012 3:23:58 AM Info License status: Activated
5/28/2012 3:23:58 AM Debug Loading language
5/28/2012 3:23:59 AM Debug Variables file did not exist.
5/28/2012 3:23:59 AM Info No Certificates loaded, file not found
5/28/2012 3:24:00 AM Debug Loading connections
5/28/2012 3:24:00 AM Info Loaded: 0 FTP connection(s)
5/28/2012 3:24:00 AM Debug Loading users
5/28/2012 3:24:16 AM Info Loaded: 5 users(s)
5/28/2012 3:24:16 AM Info No Conditions loaded, file not found
5/28/2012 3:24:16 AM Debug PGP Key Rings file did not exist.
5/28/2012 3:24:16 AM Debug Time exceptions file did not exist.
5/28/2012 3:24:16 AM Debug Loading network credentials
5/28/2012 3:24:16 AM Debug Loaded: 1 network credential(s)
5/28/2012 3:24:16 AM Debug Notifications file did not exist.
5/28/2012 3:24:16 AM Debug Network Drives file did not exist.
5/28/2012 3:24:16 AM Debug Exiting NetworkDrivesAPI.Load
5/28/2012 3:24:17 AM Debug Loading jobs
5/28/2012 3:24:18 AM Info Loaded: 0 job(s)
5/28/2012 3:24:18 AM Debug Expiring old triggers
5/28/2012 3:24:18 AM Info Searching for jobs that should have been executed
5/28/2012 3:24:18 AM Info Running missed jobs between 5/28/2012 3:20:45 AM and 5/28/2012 3:24:18 AM
5/28/2012 3:24:18 AM Debug Recalculating all jobs
5/28/2012 3:24:18 AM Debug Starting main threads
5/28/2012 3:24:18 AM Debug Flushing memory
5/28/2012 3:24:18 AM Debug InternalWorkerThreadClass was started
5/28/2012 3:24:18 AM Debug Startup finished
5/28/2012 3:24:18 AM Debug Starting IPC server.
5/28/2012 3:24:20 AM Debug Server certificate read
5/28/2012 3:24:20 AM Debug VisualCron - Server starting on port: 16444
5/28/2012 3:24:21 AM Info Starting IPV6 listener
5/31/2012 6:45:54 AM Debug Loading settings

As you can see it didn't load any jobs the last time the PC was rebooted. It shows my settings load just a while ago as the last entry.

Any ideas?

The only other clue is my server log from 5/21 which says:

5/21/2012 8:39:47 AM Err Database version error: The specified table does not exist. [ DBVersion ]
5/21/2012 8:39:47 AM Debug Copying database file from installation folder to: C:\ProgramData\VisualCron\output\log\VisualCron.sdf
5/21/2012 8:39:47 AM Debug CleanLocalDB - retrieve stats - start
5/21/2012 8:39:47 AM Debug CleanLocalDB - retrieve stats - end
5/21/2012 8:39:47 AM Debug CleanLocalDB - start
5/21/2012 8:39:47 AM Debug CleanLocalDB - end
5/21/2012 9:24:28 AM Debug GetJobHistory called
5/21/2012 9:24:28 AM Debug GetJobHistory in lock
5/21/2012 9:24:28 AM Debug GetJobHistory ended
5/21/2012 9:35:54 AM Debug CleanLocalDB - retrieve stats - start
5/21/2012 9:35:56 AM Debug CleanLocalDB - retrieve stats - end
5/21/2012 9:35:56 AM Debug CleanLocalDB - start
5/21/2012 9:35:56 AM Debug CleanLocalDB - end
5/21/2012 9:35:54 PM Debug CleanLocalDB - retrieve stats - start
5/21/2012 9:35:54 PM Debug CleanLocalDB - retrieve stats - end
5/21/2012 9:35:54 PM Debug CleanLocalDB - start
5/21/2012 9:35:55 PM Debug CleanLocalDB - end

I did upgrade about that time from 5.xx to 6.11 if that has anything to do with it.

Thanks for any light you can shed on this.

The error at the 21st seems to be related to changes in the database file between 5 and version 6. Somehow the old database has not been overwritten or the new one has been overwritten. This is not the cause for the problem though and the database part seem ok now.

What you need to do is to go back in the logs look for errors. If you zip the log_serverDATE.txt between 21st and 28th and send to support@visualcron.com we can look at it.

---

I have a similar problem using the VC client (6.1.1).
After running an Office Macro which failed but continued to show it as processing on the VC Client I stopped and restarted the client. Once restarted all jobs have dissapeared. Administrator stopped and re-started VC on the server but still the same problem with my client.

I have a similar problem using the VC client (6.1.1).
After running an Office Macro which failed but continued to show it as processing on the VC Client I stopped and restarted the client. Once restarted all jobs have dissapeared. Administrator stopped and re-started VC on the server but still the same problem with my client.

Lez, this seems different. A problem in Client should not affect server. If you still cannot see your Jobs then send similar log files to support@visualcron.com.

---