Understand warnings and errors

Applies to
Platform: Microsoft SQL Server · Snowflake · Snowflake dbt · Databricks · Databricks dbt · Fabric Lakehouse · Fabric Warehouse · Oracle

biGENIUS-X checks every model object against business rules when you change the model, and marks each broken rule with a warning or an error. An error blocks generation in the client until you fix it, and a warning does not. Each rule has an ID, and the rule index below links the article that explains it.

Warnings and errors

Warning: the model object breaks a rule that should be respected, but generation continues. The artifacts still contain the model object.
Error: the model object breaks a rule that must be followed. You can't generate the code until the error is resolved.

Errors of a deactivated model object are still listed on its card, in the status bar and on the Generate Artifacts page, but they do not block generation: the Generate button stays enabled.

One error appears during generation itself: when a template fails, error ID-90001 reports it on the Generate Artifacts page only, without an icon on the card, and the client does not offer the incomplete artifacts for download. See Error when parsing template script (Business Rule). Failures during deployment or load have no rule ID; Troubleshoot generation, deployment and load failures covers them.

Where the client shows them

A model object that breaks a rule gets a warning icon or an error icon on its card, after the model object type and before the name. The icon appears wherever the card is shown:

Point to the icon to see the messages of the model object, one block per message. Each block starts with the severity and the rule ID, for example Error ID-10003 or Warning ID-10049, followed by the details. A warning block also has the link Hide similar warnings.

The status bar shows the number of errors and warnings in the project, for example 3 Errors and 5 Warnings. Point to a number to see the names of the model objects concerned.

The Generate Artifacts page lists every error and warning in a grid with the columns Type, Time and Message. The Message column shows the details without the rule ID. While the project has errors, the page shows Calculation failed. Fix errors and try again., and Generate and Generate View are disabled. When a template fails during generation, the page shows Generation failed. Fix errors and try again. and lists the error.

Hide and show warnings

You can hide warnings, but not errors. Point to the warning icon and select Hide similar warnings. The client hides the warnings with this rule ID in the whole project: the icon disappears from the card, the warning count in the status bar goes down, and the Generate Artifacts page no longer lists these warnings. The client saves this as a project setting (HiddenWarnings, see Understand the Config YAML file content). See also Hide warnings.

To show hidden warnings again, open Project Settings > Advanced Settings > Warnings. The grid lists each hidden rule with the columns Hidden, Code and Message. Message shows the general text of the rule, for example Model object has nullable business key terms defined. for ID-10013. The row menu offers Show. See also Manage warnings.

Read a message

The details of a message name the model object and its type and state what the rule expects. The rule ID is shown only in the popup of the icon. Search the knowledge base for the ID, or find it in the rule index below. The rule articles show each message with placeholders such as <model object name> in place of the names of your project.

Example

In a Data Mart project on Microsoft SQL Server, the Fact Load Strategy of the Mart Fact deduplication_partition_mart_fact is cleared. The Mart Fact card gets an error icon. Pointing to it shows Error ID-10026 with these details:

Model object 'deduplication_partition_mart_fact' of type 'Mart Fact' has
has no option for property FactLoadStrategy selected. At least one value
has to be selected.

The rule index links ID-10026 to Fact Load Strategy selected (Business Rule). Until a Fact Load Strategy is selected for the dataflow, you can't generate the code. After you select Truncate Insert, the error icon is gone, and generation is no longer blocked by it.

Rule index

The list gives every rule ID the current generators raise, grouped by ID range, with the article that explains it, the severity and the architectures it checks. "All" stands for all five architectures. A platform in brackets means that the rule runs on that platform only. "Error or warning" means that the severity depends on the model object type, which the article names. Retired rules are no longer checked; their articles name the last release that checked them.

ID-10000 to ID-10068

ID-10000: Dataflows amount (Error; All)
ID-10001: Dataflow Sets amount (Error; All)
ID-10002: Dataflow Sets Aggregation Amount (Error; All)
ID-10003: Dataflow Set Model Objects amount (Error; Stage, Data Vault)
ID-10004: Relationships amount (Error; All)
ID-10005: Terms amount (Error; All)
ID-10006: Supported Term Data Types (Error or warning; All)
ID-10007: Supported Term Mappings (Error; Data Vault)
ID-10008: Supported Historization Types (Error; Data Store, Dimensional, Data Mart)
ID-10009: Supported Historization Types (Error; Dimensional)
ID-10010: Supported Missing BK Behavior (Retired; Dimensional)
ID-10011: Supported Aggregation Types (Error; Stage, Data Vault, Data Mart)
ID-10012: Business Key Terms amount (Error or warning; Data Store, Data Vault, Dimensional, Data Mart)
ID-10013: Business Key Terms not nullable (Warning; Data Store, Data Vault, Dimensional, Data Mart)
ID-10016: Identity Terms amount (Error; All)
ID-10017: Identity Terms not nullable (Error or warning; All)
ID-10018: Supported Implementation Types (Error; All)
ID-10019: Implementation Type Dataflows amount (Error; Data Store, Data Vault, Dimensional, Data Mart)
ID-10020: Implementation Type Incremental Filter (Error; Stage)
ID-10021: Supported Deduplication Methods (Error; All)
ID-10022: Supported Load Cachings (Error; Data Store, Data Vault, Dimensional, Data Mart)
ID-10023: Foreign Key Mapping (Error or warning; Data Vault, Dimensional, Data Mart)
ID-10024: ValidFromSourceTerm exists (Retired; Data Store, Data Vault, Data Mart)
ID-10025: Supported Fact Load Strategies (Error; Dimensional, Data Mart)
ID-10026: Fact Load Strategy selected (Error; Dimensional, Data Mart)
ID-10027: One Fact Load Strategy selected (Warning; Dimensional, Data Mart)
ID-10028: Effective Timestamp mapped (Warning; Dimensional, Data Mart)
ID-10029: No incremental load with a Deduplication (Retired; Stage, Data Mart)
ID-10030: Deduplication with multi-version load (Retired; Data Store)
ID-10031: Dataflows amount with multi-version load (Error; Data Store, Data Vault, Data Mart)
ID-10032: Dataflow Sets amount with multi-version load (Error; Data Store, Data Vault, Data Mart)
ID-10033: Aggregation with multi-version load (Error; Data Store, Data Vault, Data Mart)
ID-10034: Historized Source (Error; Data Mart)
ID-10035: Version Valid From Term configured (Warning; Data Store, Data Mart)
ID-10036: No Cyclic Dataflow (Error; Data Store, Data Vault, Dimensional, Data Mart)
ID-10037: No Cyclic Relation (Error; Dimensional)
ID-10040: No delete detection with multi-version load (Error; Data Store)
ID-10041: No delete detection source with a deleted set (Error; Data Store)
ID-10042: Delete detection source exists (Error; Data Store)
ID-10043: Delete detection source name is unique (Retired; Data Store)
ID-10044: Delete detection source Business Key exists (Error; Data Store)
ID-10045: No delete detection with an incremental load in the source (Warning; Data Store)
ID-10046: Delete detection without historization set in the terms (Warning; Data Store)
ID-10047: No deduplication for Stage objects (Warning; Stage)
ID-10048: Fact Load Strategy Dataflows amount (Warning; Dimensional, Data Mart)
ID-10049: Model object has problematic characters in name (Warning; All)
ID-10050: Model object has term with problematic characters in name (Warning; All)
ID-10051: Partition deduplication without business keys (Warning; All)
ID-10053: Data quality rules after load (Warning; Data Store, Data Vault, Dimensional)
ID-10054: Cached Mart Dimension referenced by other model objects (Error; Data Mart)
ID-10055: Cached Mart Dimension referenced by other model objects (Error; Data Mart)
ID-10056: Setting ignored for a Virtual model object (Warning; All)
ID-10057: Valid from timestamp mapped without effect (Warning; Data Store, Dimensional)
ID-10058: Valid from timestamp mapped without effect (Warning; Data Store)
ID-10059: Mixed historization types (Warning; Data Store, Dimensional, Data Mart)
ID-10060: PartialSet delete detection settings (Error; Data Store)
ID-10061: PartialSet delete detection settings (Error; Data Store)
ID-10062: PartialSet delete detection settings (Error; Data Store)
ID-10063: PartialSet delete detection settings (Error; Data Store)
ID-10064: Historization without result views or persisted validity (Error; Data Store, Data Vault, Dimensional)
ID-10065: Target object name conflict (Error or warning; All)
ID-10066: Excluded from Delta Detection settings (Error; Data Vault)
ID-10067: Excluded from Delta Detection settings (Warning; Data Vault)
ID-10068: Excluded from Delta Detection settings (Warning; Data Vault)

ID-20000 to ID-20007

ID-20000: Relationships from Link (Error; Data Vault)
ID-20001: Relationships from PIT (Error; Data Vault)
ID-20002: Current View and History View sources (Error; Data Vault)
ID-20003: Current View and History View sources (Error; Data Vault)
ID-20004: Effectivity end mapped while calculated (Warning; Data Vault)
ID-20005: Oracle - Parallel degree and hash group size values (Error; All (Oracle))
ID-20005: Current View and History View sources (Error; Data Vault)
ID-20006: Oracle - Parallel degree and hash group size values (Error; All (Oracle))
ID-20007: Data quality rules on Data Vault relationships (Warning; Data Vault)

ID-21000 to ID-21002

ID-21000: Fact Load Strategy Insert needs Incremental selected (Warning; Data Mart)
ID-21001: PIT joined with INNER JOIN (Warning; Data Mart)
ID-21002: Composite model object from another layer (Warning; Data Mart)

ID-30000 to ID-30005

ID-30000: Snowflake - Use Stream and incremental load settings (Error; All (Snowflake))
ID-30001: Supported Implementation Types for stage-driven load plans (Warning; Stage (Snowflake))
ID-30002: Snowflake - Use Stream and incremental load settings (Error; Stage (Snowflake))
ID-30003: Snowflake - Use Stream and incremental load settings (Error; Stage (Snowflake))
ID-30004: Snowflake - Use Stream and incremental load settings (Error; All (Snowflake))
ID-30005: Invalid data type configuration (Warning; All (Snowflake, Snowflake dbt))

ID-31000 to ID-31003

ID-31000: Invalid data type configuration (Warning; All (Databricks, Databricks dbt, Fabric Lakehouse))
ID-31001: Optimization Method without columns or with parallel dataflows (Warning; All (Databricks, Fabric Lakehouse))
ID-31002: Optimization Method without columns or with parallel dataflows (Error; All (Databricks, Databricks dbt, Fabric Lakehouse))
ID-31003: Setting ignored for a Virtual model object (Warning; All (Databricks, Databricks dbt, Fabric Lakehouse))

ID-32000 to ID-32010

ID-32000: Microsoft SQL Server - Index definitions (Error; All (Microsoft SQL Server))
ID-32001: Microsoft SQL Server - Index definitions (Error; All (Microsoft SQL Server))
ID-32002: Microsoft SQL Server - Index definitions (Warning; All (Microsoft SQL Server))
ID-32003: Microsoft SQL Server - Index definitions (Error; All (Microsoft SQL Server))
ID-32004: Microsoft SQL Server - Index definitions (Error; All (Microsoft SQL Server))
ID-32005: Microsoft SQL Server - Index definitions (Error; All (Microsoft SQL Server))
ID-32006: Business key data type not usable in constraints (Warning; All (Microsoft SQL Server))
ID-32008: Microsoft SQL Server - Index definitions (Error; All (Microsoft SQL Server))
ID-32010: Invalid data type configuration (Warning; All (Microsoft SQL Server))

ID-33000 to ID-33005

ID-33000: Oracle - Index definitions (Error; All (Oracle))
ID-33001: Oracle - Index definitions (Warning; All (Oracle))
ID-33002: Invalid data type configuration (Warning; All (Oracle))
ID-33003: Oracle - Parallel degree and hash group size values (Error; All (Oracle))
ID-33004: Oracle - Parallel degree and hash group size values (Error; All (Oracle))
ID-33005: Setting ignored for a Virtual model object (Warning; All (Oracle))

ID-34000 to ID-34002

ID-34000: dbt incremental read filter not applied (Warning; Data Vault, Data Mart (Snowflake dbt, Databricks dbt))
ID-34001: dbt incremental read filter not applied (Warning; Data Vault, Data Mart (Snowflake dbt, Databricks dbt))
ID-34002: dbt incremental read filter not applied (Warning; Data Mart (Databricks dbt))

ID-35000 to ID-35003

ID-35000: Invalid data type configuration (Warning; All (Fabric Warehouse))
ID-35001: Business key data type not usable in constraints (Warning; All (Fabric Warehouse))
ID-35003: Model object type not supported on Fabric Warehouse (Warning; Data Vault, Data Mart (Fabric Warehouse))

ID-90001

ID-90001: Error when parsing template script (Error; All)

See also: Troubleshoot generation, deployment and load failures, Hide warnings, Manage warnings, Generate artifacts, Understand the Config YAML file content