Connection Property: kyvos.publish.error.data
This documentation is for Kyvos 2026.8.x. To view documentation for other Kyvos versions, click here. |
|---|
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:
pid startdate enddate NUM_ROWS
------------------------
1 2023-01-01 2023-01-18 2
1 2023-01-02 2023-01-19 3
Note
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_Dim> GROUP BY pid,startdate,enddate HAVING COUNT(*)>1
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.