Hi,

I have OnTime Web (7.1.1.7329) running on a server that also runs the OnTimeEmailService. They both use the same OnTime.config file.

When I start the Email Service it runs ok but, after a day or so, it stops retrieving email. I can then foce ontime to check the email throught the Manager Email Accounts->Check Now. After I restart the email service it still won't work, but when I run the Ontime Service Configuration->Manage OnTime Database, reenter the database password and test the connection (wich succeeds!) and then start the email service it works again (for a while).

I can never find exceptions in the exception viewer or in the windows event log. 

The whole time the Web Interface keeps on working.

Can you help me find what is going wrong here?

Thanks,

Marijn

 

Hello Marijn,

I see that you've also sent in an email to support, where you mention an error does occur :

"Exception Type: System.Data.SqlClient.SqlException
Errors: System.Data.SqlClient.SqlErrorCollection
Class: 11
LineNumber: 0
Number: -2
Procedure:
Server: XXXX\SQLSERVER2005
State: 0
Source: .Net SqlClient Data Provider
ErrorCode: -2146232060
Message: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
Data: System.Collections.ListDictionaryInternal
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean)
HelpLink: NULL"

To me, it appears as if this server is losing it's connection to your SQL database on your SQL server, and the Email Services aren't starting up again on there own. The temporary loss of connectivity to the SQL Server can be caused by a variety of things, which I'll leave to you to explore, but I may have a way to make sure you OnTime Services keep checking for new mail.

There is a way to tell Windows to restart the Services if they stop due to loss of connectivity to the SQL database.

First, from the server the Services reside on, go to "Start>Programs>Control Panel>Administrative Tools>Services". Find the 3 OnTime Services, right-click on one of them, and select 'Properties'. From the Properties window, select the "Recovery" tab.

From here you can select actions for Windows to take when the service fails. You'll see you can select "Restart the Service" instead of "Take No Action" for the first, second, and subsequent failures. You can also configure how many minutes to wait after a failure for the Service to restart.

Repeat for the other 2 OnTime Services, and you should be okay from now on if the Service fails.
 
Let me know if you have any further questions, or if that doesn't resolve your issue.