--- title: PartialSet delete detection settings (Business Rule) description: These business rules check the settings of a Store Entity whose Delete Detection Method is PartialSet. --- [Skip to content](https://knowledge.bigenius-x.com/partialset-delete-detection-settings-business-rule#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. [Business Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#business-rules) # PartialSet delete detection settings (Business Rule) **Applies to** Platform: Microsoft SQL Server · Snowflake · Databricks · Fabric Lakehouse · Fabric Warehouse · Oracle Architecture: Data Store These business rules check the settings of a Store Entity whose [Delete Detection Method](https://knowledge.bigenius-x.com/delete-detection-method-model-object?hsLang=en) is `PartialSet`. Each broken rule raises an error, which blocks generation in the client until you fix it. The rule IDs are ID-10060, ID-10061, ID-10062 and ID-10063. ### Messages Each message names the Store Entity in place of ``. The Generate Artifacts page lists the messages without the rule ID. #### No partial terms selected The client shows an error with this text: ``` Model object '' of type 'Store Entity' has delete detection method 'PartialSet' configured but no partial terms are selected. Configure at least one partial term. ``` On the model object card, point to the error icon to see this message with the rule ID: Error ID-10060. Cause: [Delete Detection Partial Terms](https://knowledge.bigenius-x.com/delete-detection-partial-terms-model-object?hsLang=en) is empty. Fix: select at least one term whose values define the part of the data a load delivers. #### A partial term does not exist The client shows an error with this text: ``` Model object '' of type 'Store Entity' has delete detection partial term with id '' configured, but no corresponding term could be found on the model object. ``` On the model object card, point to the error icon to see this message with the rule ID: Error ID-10061. Cause: a selected partial term no longer exists on the Store Entity. `` stands for its ID. Fix: open Delete Detection Partial Terms, remove the missing term and select an existing one. #### PartialSet with a delete detection source The client shows an error with this text: ``` Model object '' of type 'Store Entity' has delete detection method 'PartialSet' and a delete detection source configured. 'PartialSet' uses the dataflow source directly; remove the delete detection source or choose 'DeletedSet'. ``` On the model object card, point to the error icon to see this message with the rule ID: Error ID-10062. Cause: [Delete Detection Source](https://knowledge.bigenius-x.com/delete-detection-source-model-object?hsLang=en) is set. Fix: clear Delete Detection Source, or set Delete Detection Method to `DeletedSet`. #### Unknown partial operator The client shows an error with this text: ``` Model object '' of type 'Store Entity' has an unrecognised delete detection partial operator ''. Allowed values are 'And' and 'Or'. ``` On the model object card, point to the error icon to see this message with the rule ID: Error ID-10063. Cause: [Delete Detection Partial Operator](https://knowledge.bigenius-x.com/delete-detection-partial-operator-model-object?hsLang=en) holds a value the client does not offer, shown in place of ``. Fix: set the operator to `And` or `Or`. Available since Generator 2.2. ### Check the result The error icon is gone from the Store Entity, and generation is no longer blocked by it. ### Example In a Data Store project on Microsoft SQL Server, the Store Entity `delete_detection_partialset_one_term_delete` has `PartialSet` and no partial terms. The client shows: ``` Model object 'delete_detection_partialset_one_term_delete' of type 'Store Entity' has delete detection method 'PartialSet' configured but no partial terms are selected. Configure at least one partial term. ``` With one partial term selected, the error is gone and the project generates. ### Related articles - Reference: [Delete Detection Method (Model Object)](https://knowledge.bigenius-x.com/delete-detection-method-model-object?hsLang=en), [Delete Detection Partial Terms (Model Object)](https://knowledge.bigenius-x.com/delete-detection-partial-terms-model-object?hsLang=en), [Delete Detection Partial Operator (Model Object)](https://knowledge.bigenius-x.com/delete-detection-partial-operator-model-object?hsLang=en), [Delete Detection Source (Model Object)](https://knowledge.bigenius-x.com/delete-detection-source-model-object?hsLang=en) - See also: [Configure delete detection](https://knowledge.bigenius-x.com/configure-a-delete-detection-behavior?hsLang=en), [Understand warnings and errors](https://knowledge.bigenius-x.com/understand-warnings-and-errors?hsLang=en), [Troubleshoot generation, deployment and load failures](https://knowledge.bigenius-x.com/troubleshoot-generation-deployment-and-load-failures?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) - [Oracle](https://knowledge.bigenius-x.com/generators?hsLang=en#oracle) - [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