Connection Property: kyvos.publish.error.data

Description:

This property is used to enable the publishing of erroneous data in the error messages and system logs.

Values and behavior:

true /false

If the semantic model processing fails due to non=unique primary key data, the error messaging displays the following behavior.

• kyvos.publish.error.data=true
  The primary key constraint is violated as the primary key column(s) [pid,startdate,enddate] in the dataset 'Dim' is not unique
  Below are some sample rows illustrating the issue:

• kyvos.publish.error.data=false
  The primary key constraint is violated as the primary key column(s) [pid,startdate,enddate] in the dataset 'Dates' is not unique
  To identify potential data anomalies, execute the following query on the raw data table:: SELECT pid,startdate,enddate, COUNT(*) AS NUM_ROWS FROM <table_name_for_Dates> GROUP BY pid,startdate,enddate HAVING COUNT(*)>1

Default value:

false

Scope: Semantic Model job summary

Comes into effect: This will come into effect from the next semantic model process.