Domain Validation

The validation of a Domain ensures that all of its components are consistent. The Domain Designer checks the syntax of files when they are uploaded, but overall consistency must be checked when saving a new or edited Domain.

When you click the Check Design tool bar item, the Domain Designer performs a validation based on the following criteria:
 

• Verify that the tables and columns of the Domain design exist in the specified data source.
  
  

• Verify that all items in each defined set originate in the same join tree.
  
  

• Verify that all items reference existing columns.
  
  

• Verify that derived tables have valid SQL queries.
  
  

• Verify that all items and sets in the security file exist in the Domain design (if a security file has been uploaded).
  
  
  

  In special cases where you need to create a design before the data source is available, the verification of tables and columns related to a data sources can be omitted. This can be accomplished by setting a parameter in the server configuration file. 

If validation fails, a message appears to help you correct the error(s). Make the necessary changes to the settings and save your design. If the settings are in the uploaded files, edit the files and upload them again. 
In addition to clicking the Check Design tool bar item, validation also occurs when:
 

• Opening the Domain Designer—this check detects any inconsistencies in Domain designs from uploaded files.
  
  

• Navigating from tab-to-tab under certain circumstances—this check detects problems on the tab where they occur.
  
  

• Changing the data source.
  
  

• Exporting the Domain design file.
  
  

• Clicking the OK button to exit the Domain Designer.