Error: 'Column 'fltspamdefstring' does not belong to table Table' when searching in the quarantine and no results returned

Versions / Builds Affected

2012 / 20121218

Status

Resolved

Problem Summary

When searching in the quarantine, the error 'Column 'fltspamdefstring' does not belong to table Table' appears with a stack trace, and no results are returned.

TT / JIRAID

799

How to Identify

The quarantine UI will show this error: Column 'fltspamdefstring' does not belong to table Table. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.ArgumentException: Column 'fltspamdefstring' does not belong to table Table. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [ArgumentException: Column 'fltspamdefstring' does not belong to table Table.] System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) +4729427 System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) +1725 ContentSecurity.ML.QSS.IQuarFilterManager.getFilterDefList(Hashtable& filterDefList) +0 MEC.ML.QuarFilterManager.FilterHandler.GetFolderCounts() +182 MEC.Quarantine.UI.SearchFolderItemCountTable.PopulateTable() +13 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25 System.Web.UI.Control.LoadRecursive() +71 System.Web.UI.Control.LoadRecursive() +190 System.Web.UI.Control.LoadRecursive() +190 System.Web.UI.Control.LoadRecursive() +190 System.Web.UI.Control.LoadRecursive() +190 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3064 Additionally, this error is generated in the quarantine logs: 2013-01-08,05:38:21,401,1,"#00000C70","#0000000B","error ","Quar","error: failed with following error: System.ArgumentException: Column 'fltspamdefstring' does not belong to table Table. ; ;Server stack trace: ; at System.Data.DataRow.GetDataColumn(String columnName) ; at ContentSecurity.ML.QSS.DAL.FB.QuarFilters.FbQuarFilters.getFilterDefListByMask(UInt64 mask, Hashtable& filterDefList) ; at ContentSecurity.ML.QSS.DAL.FB.QuarFilters.FbQuarFilters.getFilterDefList(Hashtable& filterDefList) ; at ContentSecurity.ML.QSS.QuarFilterManagerImpl.getFilterDefList(Hashtable& filterDefList) ; at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) ; at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext) ; ;Exception rethrown at [0]: ; at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) ; at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) ; at ContentSecurity.ML.QSS.IQuarFilterManager.getFilterDefList(Hashtable& filterDefList) ; at ContentSecurity.ML.Quar.SFAutoPurge.GetSpamSearchFolders() ; at ContentSecurity.ML.Quar.SFAutoPurge.RetentionSfTimerElapsed()" 2013-01-08,05:38:21,401,1,"#00000C70","#0000000B","error ","Quar","error:SF Retention Timer: Column 'fltspamdefstring' does not belong to table Table."

Workaround / Fix Details

- Verify Customer is on MailEssentials 2014 build 20131107 or Later

Required Actions

- Verify Customer is on MailEssentials 2014 build 20131107 or Later Attach this article to the case and escalate the case to PSG after getting troubleshooter logs and a stack trace to confirm the issue. PSG will send the customer the patch.