Hi,
We are encountering a problem. Ocationally when exporting data from Business Central (OnPrem) to Microsoft Fabric, tables occasionally remain in the InProgress state without completing.
This happens during a normal (manual) export of data, and some tables do not change their status to either a success or failed state. Instead, they appear to remain indefinitely in InProgress, with no visible error or indication that the process has failed or stalled.
From our observations and analysis, this behavior appears to be related to the user session that initiated the export. The initial export completes successfully.
However, after some time of inactivity (approximately 20–30 minutes), any data changes in tables (made before and after the inactivity period) can lead to those tables becoming stuck in the InProgress state during later export runs.
This suggests that the export process may be indirectly dependent on the original user session.
Additionally, when attempting to export a table that is already stuck in the InProgress state, a session ID briefly appears and then disappears, after which the table remains in the same state without further progress.
As a temporary workaround, we found that stopping the session using the "Stop export session" action, followed by re-exporting the schema, restores normal behavior. After applying this workaround, data exports run successfully again until the issue reoccurs.
Steps to reproduce
The issue is not consistently reproducible, but it can typically be observed using the following sequence:
Start data export
Wait for the export to complete successfully
After approximately 20–30 minutes, introduce changes to data in one or more tables
Start export
Observe that some tables remain indefinitely in InProgress
Workaround
The issue can be temporarily resolved by:
Stopping the current session using the “Stop export session” action
Re-running the schema export
Re-running the data export
After performing these steps, exports work as expected until the issue occurs again
Hi,
We are encountering a problem. Ocationally when exporting data from Business Central (OnPrem) to Microsoft Fabric, tables occasionally remain in the InProgress state without completing.
This happens during a normal (manual) export of data, and some tables do not change their status to either a success or failed state. Instead, they appear to remain indefinitely in InProgress, with no visible error or indication that the process has failed or stalled.
From our observations and analysis, this behavior appears to be related to the user session that initiated the export. The initial export completes successfully.
However, after some time of inactivity (approximately 20–30 minutes), any data changes in tables (made before and after the inactivity period) can lead to those tables becoming stuck in the InProgress state during later export runs.
This suggests that the export process may be indirectly dependent on the original user session.
Additionally, when attempting to export a table that is already stuck in the InProgress state, a session ID briefly appears and then disappears, after which the table remains in the same state without further progress.
As a temporary workaround, we found that stopping the session using the "Stop export session" action, followed by re-exporting the schema, restores normal behavior. After applying this workaround, data exports run successfully again until the issue reoccurs.
Steps to reproduce
The issue is not consistently reproducible, but it can typically be observed using the following sequence:
Start data export
Wait for the export to complete successfully
After approximately 20–30 minutes, introduce changes to data in one or more tables
Start export
Observe that some tables remain indefinitely in InProgress
Workaround
The issue can be temporarily resolved by:
Stopping the current session using the “Stop export session” action
Re-running the schema export
Re-running the data export
After performing these steps, exports work as expected until the issue occurs again