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.

You only need to perform this step for the non-production instances because you can deploy the validated semantic model later to the production instance using the Bundles capability.

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 that you can't resolve, 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:

    To avoid migration issues, resolve all errors and deploy the validated semantic model bundle to all instances, including production, while maintaining the branch framework, before initiating the migration.