Hi,
While running a query in compass i got an error.
This is a data storage error, "The payload contains a duplicate property: {property name}."
{property name}
How to fix this error and how to avoid this error in the future?
Regards,
M. Mohan Kumar
There should be a Data object id provided in the error detail.
Go to Atlas and inspect that data object id content and you likely will find some data formatting or other error in the data , that is causing the compass processing to be unable to read that data in.
You can mark the object as corrupt to get past the error, but that data will be omitted. You could delete the file and it will be permanently removed. You will need to reload that data file correctly depending on how it was published.
https://docs.infor.com/inforos/2022.x/en-us/datafabrug/default.html?helpcontent=dah1637571426420.html
there is a Compass skip reformatting option, but eventually you will want to process new data.
If you did not catch the data object id in the original error, rerun the query against that schema in Data Fabric Compass, or using the JDBC deriver.