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

rbuser

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

nardmoseley

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