Trace Data Entity Import Status and Progress in Dynamics 365 Finance and Operations
6 February 20201 min read
Dynamics 365 Finance & OperationsD365Data ManagementData EntitySQLStaging TablesImport
When importing data via the Data Management Framework in Dynamics 365 Finance and Operations, you can trace the import status and progress by querying the staging table directly using SQL.
SQL Query
SELECT *
FROM [AxDB].[dbo].ProjectStaging
WHERE ExecutionId = N'projects-2020-02-04T15:26:27-D55FE9CFB5894BAFB4C68023F9C56695'
AND TransferStatus = 1
Replace ProjectStaging with the relevant staging table for your data entity, and update the ExecutionId to match your specific import job.
Transfer Status Values
| Value | Status |
|---|---|
| 0 | Not processed |
| 1 | Completed |
This approach is useful for monitoring large imports or troubleshooting records that have not been processed as expected.