I have one custom data entity which has multiple data sources. I have recently added one more data source to apply a Range and afterwards the entity is failing in DMF export project.
Now when I try to use this Entity in a DMF export project (Excel as output format) it is giving following error for around 60+ positions
I have tried the following to solve this issue:
- Regenerated the staging table
- Checked the index on staging table, its also intact.
- Restarted the AOS service.
- Full build/Sync the model.
- Ran the following query on data entity to check for duplicates
SELECT TOP 1 COUNT(RECID) AS KEYCOUNT
FROM HRORGCHARTEXPORTENTITY
GROUP BY POSITIONID
Looking forward to helpful responses on this issue.