The "Connecting..." status is often displayed and then you see "Last synchronization" during eWay-CRM synchronization

Description

If the DebugLevel = 0 (in registers), this message can be in the log:

HASH: F3F522677A9CD9FC62C1519CD54FF849
Synchronization failed
eWay.Core.Exceptions.InternetConnectionException: The operation has timed out ---> System.Net.WebException: The operation has timed out
at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)
at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest request)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at eWay.Core.eWayWS.eWayWS.LogIn(String UserName, String PasswordHash, String ClientVersion, String ClientID)
at eWay.Core.WebService.Connection.LogIn()
at eWay.Core.WSDataInterface.eWayWSConnection.LogIn()
at eWay.Core.WebService.Connection.get_SID()
at eWay.Core.WSDataInterface.eWayItemStore.b__18()
at eWay.Core.WebService.BasicItemStore.CallWebServiceMethod[TResult](WebServiceMethodDelegate`1 method, Boolean supressAfterReLoginEventHandler)
at eWay.Core.WebService.BasicItemStore.CallWebServiceMethod[TResult](WebServiceMethodDelegate`1 method)
at eWay.Core.WSDataInterface.eWayItemStore.CallWebServiceMethod[TResult](WebServiceMethodDelegate`1 method)
at eWay.Core.WSDataInterface.eWayItemStore.GetItemsLastChange(DateTime& lastChange)
--- End of inner exception stack trace ---
at eWay.Core.WSDataInterface.eWayItemStore.GetItemsLastChange(DateTime& lastChange)
at eWay.Core.CachedDataInterface.CachedItemStore.GetItemsLastChange(DateTime& lastChange)
at eWay.StandardEdition.Synchronization.SynchronizeThread.TryGetItemsLastChange(DateTime& lastChange, Int64& lastChangeId)
--- END TRACE ---

The server log shows this message:

[12] ERROR w3wp [(null)] - Operation time-out
System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
v System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
v System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
v System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
v System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
v System.Data.SqlClient.SqlDataReader.get_MetaData()
v System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
v System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
v System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
v System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
v System.Data.SqlClient.SqlCommand.ExecuteScalar()
v eWay.Core.Data.SynchronizedSqlCommand.<>c__DisplayClass1.b__0()
v eWay.Core.Data.SqlCommandRepeater.RunSqlCommand(SqlCommand command, SqlCommandDelegate sqlCommand)
v eWay.Core.Data.SynchronizedSqlCommand.ExecuteScalar()
v eWay.WebService.MSSQLDataInterface.WsSqlCommand.<>c__DisplayClass9.b__8()
v eWay.WebService.MSSQLDataInterface.WsSqlCommand.RunCommand(SqlCommandDelegate method)
2015-06-22 09:36:29,580 [12] ERROR w3wp [(null)] - Request processed with error response 'rcDatabaseTimeout'
eWay.WebService.Core.Exceptions.WebServiceInternalException: Operation time-out
v eWay.WebService.MSSQLDataInterface.WsSqlCommand.RunCommand(SqlCommandDelegate method)
v eWay.WebService.MSSQLDataInterface.WsSqlCommand.ExecuteScalar()
v eWay.WebService.ServiceLogic.Security.ClientSession.UpdateSession(Guid sid)
v eWay.WebService.ServiceLogic.Security.ClientSession..ctor(Guid sid, ItemStore itemStore)
v eWayWSImpala.eWayWS.GetItemsLastChange(Guid SID)

The transaction log of the database is not emptying and its size can be even in gigabytes.

Version

All versions of eWay-CRM

Difficulty

Medium

Resolution

Option 1: Active backup

You need to check whether the backup of eWay-CRM is active. The active backup ensures that the transaction log is emptied.

Option 2: Individual backup (inactive)

If you don't want to use the active backup, you need to solve the backup of transaction log.

You can set the Recovery model of the eWay-CRM database from FULL to SIMPLE. This can be done in the database properties of the Microsoft SQL Management Studio (see the picture below).