Oracle Cloud Infrastructure Documentation

Validate the Main Branch

On the Semantic Model Extensions page, when you see the banner to schedule the migration, don't click Schedule now until you've validated the main branch successfully with no errors.

Note these and take applicable action prior to initiating the validation process:
  • Don't perform any development or administrative activities that effect the semantic model extensions during validation or while the migration is in process. This includes modifying existing data augmentation or creating new data augmentation that have the semantic model extensions.
  • Remove leading and trailing spaces from the object names.
  • Remove special characters such as parenthesis from the object names.
  • Ensure all keys are present on the join columns.
  • Confirm all referenced source database objects and columns exist in Autonomous Data Warehouse.
  • Confirm grants are applied on all referenced source database objects using 
    GRANT SELECT ON "OAX_USER".“TABLE_VIEW" TO "OAX$OAC";
  • Resolve any duplicate object names.
  1. On the Semantic Model Extensions page, click the Actions Menu for the Main Branch, and then click Validate to produce the Validation report.

    Validate option in the Action menu for the Main branch

  2. Click the Activity tab on the Semantic Model Extensions page and wait for the validation of the main branch to complete. If the State is Failed, then don't proceed with the migration until you've resolved all of the errors.

    Validation of main branch displaying Failed state

  3. Click the Actions Menu for the Main Branch, and then click Validation Report to download and review the validation report.
    Note

    The validation report is enabled only if the validation fails with errors.
  4. Resolve all errors in the validation report and repeat Validate and Validation Report steps until you've resolved all errors. For any errors unresolvable, contact Oracle Support before proceeding.
  5. Click the Activity tab on the Semantic Model Extensions page and wait for the validation of the main branch to complete. If the State is Done and the report is error free, then proceed with scheduling the migration.

    Validation of main branch displaying Done state

    Note

    Don't proceed with the migration until all errors are resolved.