A Resolve Common Errors in Semantic Model Extensions
Here's the list of common errors in the semantic model extensions and the solutions to resolve them.
Error: Column missing from augmentation or mapped augmentation column not available
Description: A column that is selected in the data augmentation column can no longer be found in the referenced source.
- Reset the data augmentation cache. See Reset the Cache.
- From the Console in Oracle Fusion Data Intelligence, navigate to Data Configuration, then Data Augmentation. Locate and edit the problematic data augmentation. Continue to the subsequent step to review the selected attributes. Uncheck any attributes no longer available in the source. Navigate through the configurations using Next, then click Finish to save and schedule your changes.
- Following the completion of the data augmentation process, ensure to refresh and update the semantic model extensions that reference the data augmentation target table to remove any deactivated columns.
Error: Custom columns have leading or trailing whitespace character
Description: The display name of an attribute, derived column, or physical column begins or ends with a space.
Resolution Tip: Edit the logical star, then edit the problematic customization, locate, and remove all leading and trailing spaces on attribute, derived column, or physical column names.
Error: Subject area attributes have leading or trailing whitespace character. Please check subject area name/description/folders/columns for possible whitespaces
Description: The display name of a subject area name, description, folder, or column name begins or ends with a space.
Resolution Tip: Edit the subject area, then edit the problematic customization, locate, and remove all leading and trailing spaces on subject area names, descriptions, folders, and column names.
Error: Step is in error state
Description: An error occurred in this step during the semantic model compilation.
Resolution Tip: Edit the failed step, investigate, identify the errors, and resolve them.
Error: Last step in the branch has consistency check errors.
Description: An error occurred during the semantic model compilation.
Resolution Tip: The error indicates a failure in the final step, but the root cause likely lies in an earlier stage. Edit the last failed step, investigate, identify the errors, and resolve them.