Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - TDeliverQuarantineThread.Execute
  FAQ FAQ  Forum Search   Register Register  Login Login

TDeliverQuarantineThread.Execute

 Post Reply Post Reply
Author
rudaf View Drop Down
Newbie
Newbie


Joined: 04 July 2007
Location: Italy
Status: Offline
Points: 38
Post Options Post Options   Thanks (0) Thanks(0)   Quote rudaf Quote  Post ReplyReply Direct Link To This Post Topic: TDeliverQuarantineThread.Execute
    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|<rcptto>@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?


Edited by rudaf - 14 November 2007 at 11:25am
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4106
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post 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

LogSat Software

Spam Filter ISP
Back to Top
rudaf View Drop Down
Newbie
Newbie


Joined: 04 July 2007
Location: Italy
Status: Offline
Points: 38
Post Options Post Options   Thanks (0) Thanks(0)   Quote rudaf Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.148 seconds.