Error ORF - ORF Forums

Error ORF RSS Back to forum

1

Hello!
The Last time there are such mistakes in the logs:
Text description: Unexpected Greylisting Test error. EABSException "Error on opening table "GREY" (InMemory = 0) in SQL query: Table 'GREY' not exists. - Native error: 30396 - Native error: 10303".
How can we correct them ?

by Aleksey Usoltsev 8 years ago
2

The error message indicates that ORF could not find the table called "GREY" in the SQL database your connection string points to (Configuration / Filtering - Before Arrival / Greylisting, Database button > External SQL Server - Configure). Either the SQL database has been set up incorrectly (i.e. not as described in our database guides at http://www.vamsoft.com/dbguides.asp, and the table called GREY does not exists), or the connection string is incorrect (and points to the wrong location). I suggest checking both possibilities.

by Krisztian Fekete (ORF Team) 8 years ago
3

@Aleksey Usoltsev: Sorry, I just noticed that you are using the embedded database engine of ORF and not an external SQL database. In this case, the error may indicate that your Greylisting database file (called greylist.abs located in the ORF directory) got corrupted.

To solve this problem, you should first repair the current (embedded) database file:

1. Start the ORF Administration Tool
2. Expand Configuration / Filtering - Before Arrival / Greylisting in the left navigation tree
3. Click the Database button, then click Manage > Repair.

If this does not help, try to delete the Greylisting database file from the ORF directory (greylist.abs). Note that this requires stopping the ORF Service first. ORF will create a new database file automatically when the first emails is greylisted.

To avoid possible future database corruptions, I strongly recommend switching to an external SQL database: we have some guides regarding this at http://vamsoft.com/dbguides.asp You can also convert your current databases to SQL if you want to using the Database Converter Tool (http://www.vamsoft.com/vsdbconvert/)

by Krisztian Fekete (ORF Team) 8 years ago
(in reply to this post)

New comment

Fill in the form below to add a new comment. All fields are required. If you are a registered user on our site, please sign in first.

It will not be published.
hnp1 | hnp2