Advantage Server Error 3111 HELP

I have an legacy application that I don't have the code for so I cannot debug it.  I'm getting the folllowing advantage server 9.1 error

Ads Error 3111:  Source Aof.c

I've looked up there error and see the following, but I can't find what this is.  I'm not an advantage expert by any means, but its server our foxpro tables and my billing application is no longer working

Unknown identifier found in the record filter expression

Who is Participating?
anderdw2Author Commented:
It was a corrupt index.  Reindex didn't solve the problem under we wipes the CDX file and started over.

I do wish advantage would give more errors
Olaf DoschkeSoftware DeveloperCommented:
If it's a legacy foxpro app, makes me wonder what it has to do with advantage database container. While I know ADS can be used to "serve" DBFs, a legacy app will not know it at all and would work on the DBFs directly. I can only make assumptions,  that ADS is having problems with a filter expression, as it does not support the whole foxpro language, even not the old foxpro functions available within native data access.

Bye, Olaf.
anderdw2Author Commented:
Strange is we haven't had any problems in two years up until this week.  I know nothing about AOF, from what I read they shoulld clear when a table is closed after an update
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

anderdw2Author Commented:
I do see this listed on advantage, but I have no idea where to set this property to test.


Advantage TDataSet Descendant

Indicates whether or not to use the Advantage Optimized Filters.

property AdsTableOptions.AdsOptimizedFilters;

This property indicates whether or not to use the Advantage Optimized Filters and affects how the filter property is implemented. By default this is True.

Advantage Optimized Filters (AOFs) provide state of the art filter optimization for Advantage Client Engine applications. AOFs speed filter processing by using index keys instead of table records. If a specified field has an index built on it, then an AOF uses the index file rather than the table to process the query. Performance is increased by reducing the amount of data that must be retrieved from the disk.

Note By setting this property to True, AOFs will be used for any procedures, functions, methods, or properties that use filters.
Strange is we haven't had any problems in two years up until this week.

Then the Standard question comes up - What was Changed?

Can you go back and test if the problem was caused by the change itself?

Good Luck

anderdw2Author Commented:
An initial reindex didn't solve the problem.  We went back and recreated the index from scratch, so perhaps the cdx file was corrupt
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.