Entity <ObjectID> cannot load words from table {tableid}.

English Query

English Query

Entity <ObjectID> cannot load words from table {tableid}.

Message Text

This entity has an alternate table specified to load words from, but that table does not contain the fields that represent this entity.

Explanation

While building an application, English Query loads the vocabulary in the database either from the table that contains the entity or from an alternate table. If an alternate table is used, it must contain denormalized copies of the fields that represent the entity.

For example, the database for a project contains a Customers table and an alternative table called Current Customers, which contains fields that are marked as denormalized. If the Customers table contains a Suite number field and the Suite number field is missing from the Current Customers table, English Query will not be able to load words from the table.

This error can occur when:

  • The Semantic Modeling Format (SMF) text file has been edited and a field is missing from one table but not the other.

  • A field is marked as a denormalized copy of a field and deleted in one table without making the same changes in the corresponding field of the other table.
Action

To correct this error:

  • Mark one field as a denormalized copy of the other field.

  • Add the missing field to the appropriate table.

  • Edit the SMF text file to either add the field or remove it from the other table.

  • Refresh the tables.

See Also

Advanced Tab (Table/New Table Dialog Box)

Compile-Time Error Messages (Authoring Object Model)

How to add a field to a table

How to add tables and views from a SQL data source

How to edit a table

How to refresh all tables in a project

SQL Database Normalization Rules