Skip to content
  • There are no suggestions because the search field is empty.

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