Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Exception occurred during ChecktblReloadTableInfo
  FAQ FAQ  Forum Search   Register Register  Login Login

Exception occurred during ChecktblReloadTableInfo

 Post Reply Post Reply
Author
gns View Drop Down
Newbie
Newbie


Joined: 27 July 2008
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote gns Quote  Post ReplyReply Direct Link To This Post Topic: Exception occurred during ChecktblReloadTableInfo
    Posted: 27 July 2008 at 12:00pm
Hallo! We're using the latest stable build with SQL 2005 and we have 2 problems.
 
1. A lot of log entries like:
[skipped]
07/27/08 18:54:04:765 -- (2740) No Data Received
07/27/08 18:54:04:765 -- (2740) Disconnect
07/27/08 18:54:05:953 -- Exception occurred during ChecktblReloadTableInfo: String or binary data would be truncated
07/27/08 18:54:09:093 -- (3404) Connection from: 69.65.56.26  -  Originating country : United States
[skipped]
 
2. Can't save settings. For example, adding new IP to blacklist, clicking on "Save settings". Nothing happens, no error appears, actually settings not saved. Files/folders permissions are OK, configuration files are NOT marked as Read-Only. User accout have administrator privilegies.
 
Any ideas?


Edited by gns - 27 July 2008 at 12:15pm
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4068
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 28 July 2008 at 10:46pm
gns,
The most likely cause (without seeing your logs we can't be sure) is a misconfigured database, with either some triggers missing, and/or some patches not being applied to the database.

Could you try to follow the steps indicated in this recent post:

http://www.logsat.com/SpamFilter/Forums/forum_posts.asp?TID=6528#12287


And, after restarting SpamFilter, clicking on the "Create / Check Database tables" button in the "Settings - Enterprise / Standard Version" tab in SpamFilter?
Roberto Franceschetti

LogSat Software

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


Joined: 27 July 2008
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote gns Quote  Post ReplyReply Direct Link To This Post Posted: 29 July 2008 at 6:28am
Recommended actions not helped. Mailed log, SpamFilter.ini and tblReloadTableInfo structure and content.
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4068
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 29 July 2008 at 4:57pm
I'm afraid you've just uncovered a new bug (in SpamFilter Enterprise only). The "tablename" field in the table "tblreloadtableinfo" has a length of 45 characters. This length is not enough once this table reaches 9,999,999 rows.

If you can please edit this field length in SQL Server and increase it to VARCHAR(55) this will solve the issue. You may make the change on the fly while SpamFilter is running.
Roberto Franceschetti

LogSat Software

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


Joined: 27 July 2008
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote gns Quote  Post ReplyReply Direct Link To This Post Posted: 30 July 2008 at 4:54am
Originally posted by LogSat LogSat wrote:

If you can please edit this field length in SQL Server and increase it to VARCHAR(55) this will solve the issue. You may make the change on the fly while SpamFilter is running.
 
Yoahhoooo! It solved both problems! Thanx!
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.078 seconds.