Emailsecurity quarantine search by sender sometimes returns no results – GFI MailEssentials Support

Versions / Builds Affected

2012/20120425-2158

Status

Resolved

TT / JIRAID

MEC130

How to Identify

When searching by sender in the MailEssentials 2012 quarantine, sometimes searches are returned and sometimes they are not, based on the criteria used for the search. This error will appear when doing a search: 2012-05-16,16:20:59,523,1,"#000019A8","#0000000C","info ","QSSItemsDalFb","Dal::composeQuarFilterCondition...ItemDisplaySrcAddr creditreportoptions@findforddealers.com" 2012-05-16,16:20:59,523,1,"#000019A8","#0000000C","info ","QSSItemsDalFb","Dal::composeQuarFilterCondition,Setting parameter value:%CREDITREPORTOPTIONS@FINDFORDDEALERS.COM%" 2012-05-16,16:20:59,523,1,"#000019A8","#0000000C","info ","QSSItemsDalFb","Dal::composeQuarFilterCondition...ok" 2012-05-16,16:20:59,524,1,"#000019A8","#0000000C","info ","QSSItemsDalFb","QuarSnapShotImpl::refreshSnapShot Query::SELECT filtertable.itemid FROM ( SELECT DISTINCT fulltable.itemid,fulltable.ItemIdShort FROM ( SELECT itemprops.itemid, itemprops.itemidshort ,itemdisplaysrcaddr FROM ( quaritems items LEFT OUTER JOIN quaritemprops itemprops ON items.itemid = itemprops.itemid) ) AS fulltable WHERE (1=1) AND ( (UPPER(SUBSTRING(itemdisplaysrcaddr FROM 1)) LIKE @parm0 ESCAPE '\') ) ) AS filtertable ORDER BY filtertable.ItemIdShort DESC ;" 2012-05-16,16:20:59,525,1,"#000019A8","#0000000C","info ","QSSItemsDalFb","QuarSnapShotImpl::getDataSetFromCommand..." 2012-05-16,16:21:00,185,1,"#000019A8","#0000000C","error ","QSSItemsDalFb","error:getDataSetFromCommand....EXCEPTION Dynamic SQL Error ;SQL error code = -303 ;arithmetic exception, numeric overflow, or string truncation" Compared to a successful result: 2012-05-16,16:25:53,710,1,"#000019A8","#00000003","info ","QSSItemsDalFb","Dal::composeQuarFilterCondition...ItemDisplaySrcAddr creditreportoptions" 2012-05-16,16:25:53,710,1,"#000019A8","#00000003","info ","QSSItemsDalFb","Dal::composeQuarFilterCondition,Setting parameter value:%CREDITREPORTOPTIONS%" 2012-05-16,16:25:53,710,1,"#000019A8","#00000003","info ","QSSItemsDalFb","Dal::composeQuarFilterCondition...ok" 2012-05-16,16:25:53,710,1,"#000019A8","#00000003","info ","QSSItemsDalFb","QuarSnapShotImpl::refreshSnapShot Query::SELECT filtertable.itemid FROM ( SELECT DISTINCT fulltable.itemid,fulltable.ItemIdShort FROM ( SELECT itemprops.itemid, itemprops.itemidshort ,itemdisplaysrcaddr FROM ( quaritems items LEFT OUTER JOIN quaritemprops itemprops ON items.itemid = itemprops.itemid) ) AS fulltable WHERE (1=1) AND ( (UPPER(SUBSTRING(itemdisplaysrcaddr FROM 1)) LIKE @parm0 ESCAPE '\') ) ) AS filtertable ORDER BY filtertable.ItemIdShort DESC ;" 2012-05-16,16:25:53,710,1,"#000019A8","#00000003","info ","QSSItemsDalFb","QuarSnapShotImpl::getDataSetFromCommand..." 2012-05-16,16:25:53,871,1,"#000019A8","#00000003","info ","QSSItemsDalFb","QuarSnapShotImpl::getDataSetFromCommand...ok"

Workaround / Fix Details

Upgrade customer to GFI MailEssentials 2015 or later

Required Actions