Exception occurred during ChecktblReloadTableInfo
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=6531
Printed Date: 15 March 2025 at 7:58am
Topic: Exception occurred during ChecktblReloadTableInfo
Posted By: gns
Subject: Exception occurred during ChecktblReloadTableInfo
Date 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?
|
Replies:
Posted By: LogSat
Date 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://%20www.logsat.com/SpamFilter/Forums/forum_posts.asp?TID=6528#12287 - 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 http://www.logsat.com" rel="nofollow - LogSat Software http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP |
Posted By: gns
Date Posted: 29 July 2008 at 6:28am
| Recommended actions not helped. Mailed log, SpamFilter.ini and tblReloadTableInfo structure and content. |
Posted By: LogSat
Date 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 http://www.logsat.com" rel="nofollow - LogSat Software http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP |
Posted By: gns
Date Posted: 30 July 2008 at 4:54am
Yoahhoooo! It solved both problems! Thanx!
|
LogSat wrote: