Error ORF - ORF Forums

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.

@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/)