Page History

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

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

• Verify that the tables and columns of the Domain Data Source 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 Data Source 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 Data Source Designer—this check detects any inconsistencies in Domain Data Source 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 Data Source design file. 

• Clicking the  OK button to exit the Domain Data Source Designer.