Versions / Builds Affected
2012/20120425-2158Status
ResolvedTT / JIRAID
MEC130How 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 laterRequired Actions
Upgrade customer to GFI MailEssentials 2015 or later