11
Currently, error messages in DMF are only displayed in the Staging Data form and only for individual rows. It is difficult to get or provide an overview of errors, especially on larger imports. Provide a error message summary (on a separate tab on the staging table data form).
I've been summarizing the error messages in SQL...
SELECT cs.value AS [Message], COUNT(1) AS [Count]
FROM CUSTCUSTOMERV3STAGING a
JOIN DMFSTAGINGVALIDATIONLOG b ON b.EXECUTIONID=a.EXECUTIONID AND b.STAGINGRECID=a.RECID
CROSS APPLY STRING_SPLIT (ERRORMESSAGE, CHAR(10)) cs
WHERE a.EXECUTIONID=''
GROUP BY cs.value ORDER BY 1
I've been summarizing the error messages in SQL...
SELECT cs.value AS [Message], COUNT(1) AS [Count]
FROM CUSTCUSTOMERV3STAGING a
JOIN DMFSTAGINGVALIDATIONLOG b ON b.EXECUTIONID=a.EXECUTIONID AND b.STAGINGRECID=a.RECID
CROSS APPLY STRING_SPLIT (ERRORMESSAGE, CHAR(10)) cs
WHERE a.EXECUTIONID=''
GROUP BY cs.value ORDER BY 1
STATUS DETAILS
Under Review
Comments
Note. I recently reviewed a similar requirement. Check this entity. DataManagementExecutionJobDetails. It should expose the execution logs and enable you to report directly. Good luck!
Category: Data Management
Administrator on 12/17/2020 6:08:51 PM
Thanks for the ask. We are reviewing this and one approach could be to expose the errors as an entity. This can then be used in PBI for error analysis.