--- title: Take care of entries from the Data Quality rules log description: "Depending on your Generator Configuration, some default Data Quality Rules are applied during the data load of your data solution.\nIt is also possible to add custom ones (See Understand Data Quality rules overview).\nThis article provides some explanation of how it works during the load and how to care for them." --- [Skip to content](https://knowledge.bigenius-x.com/take-care-of-entries-from-the-data-quality-rules-log#main-content) [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en) [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal?hsLang=en) [![TRI\_Logo\_biGENIUS\_2020\_RGB\_s](https://knowledge.bigenius-x.com/hs-fs/hubfs/Marketing/TRI_Logo_biGENIUS_2020_RGB_s.png?width=150&height=42&name=TRI_Logo_biGENIUS_2020_RGB_s.png)](https://www.bigenius-x.com/) Open main navigation Close main navigation - [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new) - [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal) How can we help you? - There are no suggestions because the search field is empty. 1. [biGENIUS-X Knowledge Base](https://knowledge.bigenius-x.com/?hsLang=en) 2. [Best practices](https://knowledge.bigenius-x.com/best-practices?hsLang=en) 3. [Use Cases](https://knowledge.bigenius-x.com/best-practices?hsLang=en#use-cases) # Take care of entries from the Data Quality rules log This article is valid for a Project with a **Generator Configuration version higher than or equal to 1.10.X**. For lower versions, see [Take care of entries from Cleansing Error tables](https://knowledge.bigenius-x.com/take-care-of-entries-from-cleansing-error-tables?hsLang=en). Depending on your Generator Configuration, some default **Data Quality Rules** are applied during the data load of your data solution. It is also possible to add custom ones (See [Understand Data Quality rules overview](https://knowledge.bigenius-x.com/understand-data-quality-rules-overview?hsLang=en)). This article explains how they work during the load and how to care for them. ### Default Data Quality rules There are currently 5 default Data Quality Rules: - [**Nulled Non-Nullable Business Keys**](https://knowledge.bigenius-x.com/nulled-non-nullable-business-keys-data-quality-rule?hsLang=en): checks if the Term set as Non-Nullable Business Keys contains nullable values - [**Duplicated Business Keys**](https://knowledge.bigenius-x.com/nulled-non-nullable-business-keys-data-quality-rule-0?hsLang=en): checks if the Term set as Business Key has duplicated values - [**Nulled Non-Nullable Term**](https://knowledge.bigenius-x.com/nulled-non-nullable-term-data-quality-rule?hsLang=en): checks if the Term set as Non-Nullable contains nullable values - [**Duplicated Term**](https://knowledge.bigenius-x.com/duplicated-term-data-quality-rule?hsLang=en): checks if the Term has duplicated values - [**Missing Foreign Keys**](https://knowledge.bigenius-x.com/missing-foreign-keys-data-quality-rule?hsLang=en): check if the Foreign Key Term value exists in the Model Object in relation to ### Data Quality rules check during load For each Model Object where Data Quality rules can be applied, a ***XXX\_DataQualityError*** table is created during deployment. When a **row violates a Data Quality rule**, and the ***Logging* option is set to *True* for the rule**, the row is logged to this table rather than in the usual target table. Example: ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Dec-16-2025-03-33-16-7675-PM.png?width=670&height=74&name=image-png-Dec-16-2025-03-33-16-7675-PM.png) ### Take care of the Data Quality rule entries During a load, you may have multiple entries in the ***XXX\_DataQualityError*** tables. **You need to take care of these entries regularly** because they show a potential problem in the design of your Model Object. An entry in this table can be of different types: - **Nulled Non-Nullable Business Keys**: - The Term set as Non-Nullable Business Key contains nullable values - ACTION TO DO: Define a Business Key that will never be null for any row - **Duplicated Business Keys**: - The Term set as Business Key has duplicated values - ACTION TO DO: Define a Business Key that will be unique for all your rows - **Nulled Non-Nullable Term**: - The Term set as Non-Nullable contains nullable values - ACTION TO DO: Define a Term that will never be null for any line - **Duplicated Term**:  - The Term has duplicated values - ACTION TO DO: Define a Term that will be unique for all your lines - **Missing Foreign Keys**: - The Foreign Key Term value doesn't exist in the Model Object in relation to - ACTION TO DO: Correct the Model Object in order to have all values used in related Model Objects For alternative methods to handle missing Foreign Key values and reduce the number of logged errors, refer to the article: [Reduce the volume of the Data Quality rules log](https://knowledge.bigenius-x.com/reduce-the-volume-of-the-data-quality-rules-log?hsLang=en).   - [Getting started](https://knowledge.bigenius-x.com/getting-started?hsLang=en#main-content) - [Guidelines](https://knowledge.bigenius-x.com/getting-started?hsLang=en#guidelines) - [Start working](https://knowledge.bigenius-x.com/getting-started?hsLang=en#start-working) - [Account](https://knowledge.bigenius-x.com/getting-started?hsLang=en#account) - [General overview](https://knowledge.bigenius-x.com/general-overview?hsLang=en) - [Artificial Intelligence](https://knowledge.bigenius-x.com/artificial-intelligence?hsLang=en) - [Application Modules](https://knowledge.bigenius-x.com/application-modules?hsLang=en#main-content) - [Administration](https://knowledge.bigenius-x.com/application-modules?hsLang=en#administration) - [Solutions](https://knowledge.bigenius-x.com/application-modules?hsLang=en#solutions) - [Global Features](https://knowledge.bigenius-x.com/application-modules?hsLang=en#global-features) - [Projects](https://knowledge.bigenius-x.com/application-modules?hsLang=en#projects) - [Branches](https://knowledge.bigenius-x.com/application-modules?hsLang=en#branches) - [Data Connections](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-connections) - [Dataflow Modeling - Overview](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-overview) - [Dataflow Modeling - Wizard Steps](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-wizard-steps) - [Dataflow Modeling - Terms](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-terms) - [Dataflow Modeling - Term Mapping](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-term-mapping) - [Dataflow Modeling - Relationships](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-relationships) - [Dataflow Modeling - Data Quality](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-data-quality) - [Dataflow Modeling - Indexes](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-indexes) - [Relationship Modeling](https://knowledge.bigenius-x.com/application-modules?hsLang=en#relationship-modeling) - [Generate Artifacts](https://knowledge.bigenius-x.com/application-modules?hsLang=en#generate-artifacts) - [Project Settings](https://knowledge.bigenius-x.com/application-modules?hsLang=en#project-settings) - [Data Marketplace](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-marketplace) - [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en#main-content) - [Fabric Warehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-warehouse) - [Fabric Lakehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-lakehouse) - [Databricks](https://knowledge.bigenius-x.com/generators?hsLang=en#databricks) - [Snowflake](https://knowledge.bigenius-x.com/generators?hsLang=en#snowflake) - [Microsoft SQL Server](https://knowledge.bigenius-x.com/generators?hsLang=en#microsoft-sql-server) - [Artifacts](https://knowledge.bigenius-x.com/generators?hsLang=en#artifacts) - [Replace Placeholders](https://knowledge.bigenius-x.com/generators?hsLang=en#replace-placeholders) - [Target solution environment](https://knowledge.bigenius-x.com/generators?hsLang=en#target-solution-environment) - [Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment) - [Deployment with an Azuze DevOps pipeline](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment-with-an-azuze-devops-pipeline) - [Delta Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#delta-deployment) - [Load control environment](https://knowledge.bigenius-x.com/generators?hsLang=en#load-control-environment) - [Load data with a native load control](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-a-native-load-control) - [Load data with Apache Airflow](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-apache-airflow) - [Model Object Type](https://knowledge.bigenius-x.com/generators?hsLang=en#model-object-type) - [Properties](https://knowledge.bigenius-x.com/generators?hsLang=en#properties) - [Default Terms](https://knowledge.bigenius-x.com/generators?hsLang=en#default-terms) - [Discovery application](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#main-content) - [Discovery configurations](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#discovery-configurations) - [Best practices](https://knowledge.bigenius-x.com/best-practices?hsLang=en#main-content) - [Modeling Approaches](https://knowledge.bigenius-x.com/best-practices?hsLang=en#modeling-approaches) - [Use Cases](https://knowledge.bigenius-x.com/best-practices?hsLang=en#use-cases) - [Business Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#business-rules) - [Data Quality Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#data-quality-rules) - [FAQs](https://knowledge.bigenius-x.com/faqs?hsLang=en) - [Product Release Notes](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#main-content) - [SaaS Application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#saas-application) - [Discovery application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#discovery-application) - [Generators](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#generators) - [Legal Documents](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#main-content) - [Current legal docs](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#current-legal-docs) - [Software Product and Limits](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#software-product-and-limits) - [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en) - [Customer Portal](https://knowledge.bigenius-x.com/customer-portal) - [Sign in](https://knowledge.bigenius-x.com/_hcms/mem/login) [![biGENIUS logo](https://knowledge.bigenius-x.com/hubfs/TRI_Logo_biGENIUS_2020_RGB-1.svg "biGENIUS logo")](https://www.bigenius-x.com) All rights reserved © 2025, biGENIUS AG