Error messages

If error conditions are detected in the Access Definition or the Extract Request when the Extract is run, processing stops and an error message is displayed. For example, errors can occur if changes were made to the tables since the Access Definition was created.

The following error messages appear in the message bar of the Extract Request Editor:

Duplicate Table Entries
A single table is listed in the Access Definition twice. You cannot specify a table and one or more views or aliases of that table, or specify more than one view or alias of a table.
No Valid Table
No valid table is specified. The list of tables in the Access Definition does not include any valid tables. The tables might have been dropped from the database.
Invalid WHERE Clause
An SQL WHERE Clause is invalid. Selection criteria for one or more tables are invalid. For example, a column that is used in the SQL WHERE Clause was dropped from the table.
Invalid Start Table
The Start Table is invalid. This error can occur when the table is dropped or the Creator ID changed. The table is then marked as Unknown and cannot be used as the Start Table.
Missing Primary Keys
A child table that has multiple parents does not have a primary key. The primary key is required when the child table is related to multiple parents to ensure that multiple copies of a row are not extracted.

A parent table does not have a primary key. Relationships that are defined in the Optim™ Directory are not required to include a primary key for the parent table. However, a primary key is required to enable tracking of outstanding parent rows.

Improper Authorization
The person who requested the extract is not authorized to access data from a table included in the Access Definition.


Feedback