In a Multi-Install environment, the Attendant service on the slave servers crashes and stops synchronising

Versions / Builds Affected

GFI MailEssentials 2015

Status

Resolved

Problem Summary

The Attendant service starts crashing and the synchronisation stops on the slave servers of a Multi-Install environment. This will usually occur after upgrading GFI MailEssentials and SpamTag and clients restart the machines due to bulk transfers.

TT / JIRAID

2488

How to Identify

By the Problem Summary, adding that this will be caused by the import of the SpamTag contacts from the different users. A similar error should be present in the debug logs: "error ","MailEssentials.ControlLists.PBL","Error: Failed to update database. Error Message: Begin failed with SQL exception" "error ","MailEssentials.ControlLists.PBL","Error: Full Details: NHibernate.TransactionException: Begin failed with SQL exception ---> System.InvalidOperationException: BeginTransaction requires an open and available Connection. The connection's current state is Closed. ; at System.Data.SqlServerCe.SqlCeConnection.CheckStateOpen(String method) ; at System.Data.SqlServerCe.SqlCeConnection.BeginTransaction(IsolationLevel isolationLevel) ; at System.Data.SqlServerCe.SqlCeConnection.BeginDbTransaction(IsolationLevel isolationLevel) ; at System.Data.Common.DbConnection.System.Data.IDbConnection.BeginTransaction() ; at NHibernate.Transaction.AdoTransaction.Begin(IsolationLevel isolationLevel) ; --- End of inner exception stack trace --- ; at NHibernate.Transaction.AdoTransaction.Begin(IsolationLevel isolationLevel) ; at NHibernate.Transaction.AdoTransaction.Begin() ; at NHibernate.Impl.SessionImpl.BeginTransaction() ; at MailEssentials.ControlLists.CDataAccessLayer.OpenWithTransaction(Boolean stateless) ; at MailEssentials.ControlLists.Personal.Blacklist.CPBL_DBHandler.AddOrUpdate(List`1 pblEntries)" "error ","MailEssentials.ControlLists.PBL","Error: Failed to update database. Error Message: Begin failed with SQL exception" "error ","MailEssentials.ControlLists.PBL","Error: Full Details: NHibernate.TransactionException: Begin failed with SQL exception ---> System.InvalidOperationException: BeginTransaction requires an open and available Connection. The connection's current state is Closed. ; at System.Data.SqlServerCe.SqlCeConnection.CheckStateOpen(String method) ; at System.Data.SqlServerCe.SqlCeConnection.BeginTransaction(IsolationLevel isolationLevel) ; at System.Data.SqlServerCe.SqlCeConnection.BeginDbTransaction(IsolationLevel isolationLevel) ; at System.Data.Common.DbConnection.System.Data.IDbConnection.BeginTransaction() ; at NHibernate.Transaction.AdoTransaction.Begin(IsolationLevel isolationLevel) ; --- End of inner exception stack trace --- ; at NHibernate.Transaction.AdoTransaction.Begin(IsolationLevel isolationLevel) ; at NHibernate.Transaction.AdoTransaction.Begin() ; at NHibernate.Impl.SessionImpl.BeginTransaction() ; at MailEssentials.ControlLists.CDataAccessLayer.OpenWithTransaction(Boolean stateless) ; at MailEssentials.ControlLists.Personal.Blacklist.CPBL_DBHandler.AddOrUpdate(List`1 pblEntries)"

Workaround / Fix Details

Apply below patch. http://cdnpatches.gfi.com/me/20150102/ME2015_PATCH_20150131_2488.zip

Required Actions

Attach article to case and apply patch.