Repository Manager Guide

10.3 HotFix 1

Back Next

Operational Reference Store Metadata Validation

You can run use the Repository Manager tool in the Hub Console to validate Operational Reference Store (ORS) metadata.

You must validate ORS metadata and resolve all errors and fatal issues before you perform a promotion operation, import operation, or an export operation. You must also validate the metadata and resolve all errors and fatal issues before you upgrade.

By default, all validation checks are enabled, but you can choose to validate specific areas of the repository.

The following table lists the validation checks that you can select:

Validation Check	Description
All System Checks	Performs the following systems checks: repository tables system columns system views primary key constraints foreign key constraints constraints on indexes sequences trigger signatures packages
All Physical Checks	Compares repository structure with database metadata. For example, for base object tables, the repository metadata must match the physical database metadata for tables, constraints, views, and sequences.
All Repository Checks	Validates metadata stored in the repository

The following table describes the individual repository checks you can select:

Validation Check	Description
Repository	Validates the repository
Mappings	Validates mappings between landing and staging tables
Cleanse	Validates Process Servers , cleanse functions, and cleanse lists
Queries	Validates queries
Schema	Validates the following data model design objects: base object tables base object columns landing tables match configuration external match tables validation rules message queues relationships staging tables custom indexes
Trust	Validates the source system trust configuration and trust columns
Security Access Manager	Validates resource groups, secure resources, and roles
Hierarchy Manager	Validates entity types, relationship types, hierarchies, packages, profiles, sandboxes, and Hierarchy Manager metadata
Miscellaneous	Validates all other supported design objects