Home Server
New Blog Posts: Merging Reports - Part 1 and Part 2

Unable to find table in cache : (RB 10.09 Delphi 6.02)

edited October 2008 in Server
Hi

My deployed report server works fine except under the following conditions.

When I introduce a new report into the report catalog (tables in ORACLE) I
get the following error message when I try and run the report

"Server Error:_Processing request for report Reports\Tour General\PAN004 -
Mini Tour Query
ECustomReportBuilderError, TdaMetaCache.GetFields:_unable to
find table V_PAN004 in cache."

Now I guess the report server is not seeing the new report as the views for
the catalog have already been opened as when I restart the server all is
well. The other aspect to this is that I only get the error if I send
criteria to the report a request with no criteria sent works fine.

Is there anyway I can respond to this situation and get the catalog
refreshed?

Regards
Andrew

Comments

  • edited October 2008
    There is a global meta data cache that the ReportBuilder uses to cache
    information about the available database tables and fields. You can clear
    the meta data cache using the following code.

    uses
    daMetaDataManager;

    begin
    gMetaDataManager.Clear;

    end;

    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.