Advantage Server Error 3111 HELP

Posted on 2011-10-05
Last Modified: 2012-05-12
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

Question by:anderdw2
    LVL 29

    Expert Comment

    by:Olaf Doschke
    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.

    Author Comment

    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

    Author Comment

    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.
    LVL 12

    Expert Comment

    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


    Accepted Solution

    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

    Author Closing Comment

    An initial reindex didn't solve the problem.  We went back and recreated the index from scratch, so perhaps the cdx file was corrupt

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: (http://msd…
    Digital marketing agencies have encountered both the opportunities and difficulties that emerge from working with a wide-ranging organizations.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now