Delete detection source Business Key exists (Business Rule)
Applies to
Platform: Microsoft SQL Server · Snowflake · Databricks · Fabric Lakehouse · Fabric Warehouse · Oracle
Architecture: Data Store
This business rule checks that the model object set in Delete Detection Source has a term for each business key term of the Store Entity. It raises an error, which blocks generation in the client until you fix it. The rule ID is ID-10044.
Message
The client shows an error with this text on the Store Entity. <model object name> and <type> stand for its name and type.
Model object '<model object name>' of type '<type>' has a delete detection source configured, but for a business key term the corresponding source term in the referenced model object could not be found.
On the model object card, point to the error icon to see this message with the rule ID: Error ID-10044. The Generate Artifacts page lists the message without the ID.
Cause
Delete Detection Method of the Store Entity is not None, and the model object in Delete Detection Source has no term with the name of one of its business key terms. The names are compared with case.
Fix
Do one of the following:
- Open Edit Model Object of the Store Entity and select a Delete Detection Source that has a term for every business key term.
- Rename the term in the delete detection source to the name of the business key term, see Edit a Term.
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 dd_deletedset_bk_only has the business key term CUSTOMER_ID. Its Delete Detection Source is changed to the Stage supplier, which has no term CUSTOMER_ID. The client shows:
Model object 'dd_deletedset_bk_only' of type 'Store Entity' has a delete detection source configured, but for a business key term the corresponding source term in the referenced model object could not be found.
Related articles
- Reference: Delete Detection Source (Model Object), Delete Detection Method (Model Object)
- See also: Configure delete detection, Edit a Term, Delete detection source exists (Business Rule), Understand warnings and errors