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

Error: TdaMetaCache.GetFields: unable to find table INVOICES in cache

edited May 2005 in End User
Hello,

Sometimes I get the error "TdaMetaCache.GetFields:unable to find table
INVOICES in cache" and I have to populate the dictionary to fill the table
and field names.

This doesn't happen very often (once a month) and I can not reproduce it. Do
you know what I am doing wrong?

Thanks,

Jose Maria Sanmartin

Comments

  • edited May 2005

    Make sure that you have DataDictionary.UseTableOwner set appropriately. In
    most cases this should be set to false. See the RBuilder.hlp file.

    Perhaps you have some reports that use a different database connection than
    other reports? That could cause things to not work properly.


    --
    Nard Moseley
    Digital Metaphors Corporation
    http://www.digital-metaphors.com


    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited May 2005
    DataDictionary.UserTableOwnername is False and I use the same database
    connection for all the reports.

    When this happens if I go to the Report Design I don't see the data
    dictionary. Only the tables and field names. But not the alias saved in the
    dictionary.

    I can make a backup when this happens and check what is wrong. Should I do
    something when the error appears?

    Thanks,

    Jose Maria Sanmartin


  • edited May 2005

    This is not a known issue, so I am at a loss as to what to tell you. If it
    happens, access the report designer, select the Data workspace, and then
    select File | DataSettings to check how they are configured.

    The Designer.DataSettings that are used to create the report are saved as
    part of the report definition. Perhaps you have one or more reports that are
    saved with different datasettings than all of the other reports.


    --
    Nard Moseley
    Digital Metaphors Corporation
    http://www.digital-metaphors.com


    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited May 2005
    Thanks Nard,

    I'll study a database with the problem (before populating it) to see why the
    datadictionary is missing. I'll tell you if I can find something.

    Thanks for your support.

    Jose Maria Sanmartin
This discussion has been closed.