Print Page | Close Window

TDeliverQuarantineThread.Execute

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6297
Printed Date: 14 December 2025 at 9:29pm


Topic: TDeliverQuarantineThread.Execute
Posted By: rudaf
Subject: TDeliverQuarantineThread.Execute
Date Posted: 14 November 2007 at 10:44am
Problem with deliver quarantined email (STD ed. .718)
 
here's the log
 
11-14-07 16:13:30:578 -- (2196) Adding to C:\Program Files\SpamFilter\KeyFiles\AutoWhiteListForceDelivery.txt:<mail form>@domain.com|<rcpt mailto:domain.com|rcptto@domain.net - to>@domain.net
11-14-07 16:13:30:593 -- (2196) Exception occurred during TDeliverQuarantineThread.Execute: Insufficient key column information for updating or refreshing 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 36 37 38
 
1) the sender address has been correctly added to white list (AutoWhiteListForceDelivery.txt)
 
2) db at tblquarantine reported deliver = 1 expire = 0 server id = 1 (correct)
 
3) db at tblmsg join on the tblquarantine (msgid) is not null.
 
4) message keeps on remain in db
 
What's wrong?


Replies:
Posted By: LogSat
Date Posted: 14 November 2007 at 8:21pm
rudaf,

After delivering the quarantined message, actually the database record should contain:
deliver=0
expire=1

Could you please try editing the record directly from the database, and change the two values to match the above? We'd like to know if performing the operation manually is successful or not.

Does this happen for every email that is force-delivered from the quarantine, or did it happen just this time? If it happens every-time, could you try the manual change on one or two more entries to see if the error appears then as well?


-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP

Posted By: rudaf
Date Posted: 23 November 2007 at 4:40pm
Hi Roberto (dovrei dire ciao?),
 
we solved the problem. after a db moving Ouch primary keys on spamfilter table were lost.... once rebuilded things were back regulary.
 
Thanks


Print Page | Close Window