Applies to Product – Dynamics 365 Finance
What’s happening?
The customer is unable to enable the Advanced Query feature on a data integration project between Finance and Operations and Dataverse. After clicking the "Advanced Query" button, the operation times out after several minutes, displaying an error message indicating a timeout.
Reason:
The timeout issue occurs because the Data Integrator has a timeout limit of 5 minutes. If the Data Import Export Framework (DIXF) operation takes longer than this limit, the Advanced Query will timeout. This behavior is by design, particularly in scenarios where the Finance and Operations entity has a post-load method, leading to asynchronous exports.
Resolution:
- Ensure that the DIXF operation completes within the 5-minute timeout limit. If the operation is expected to take longer, consider optimizing the data export process to reduce the time taken.
- If the DIXF operation is not fast enough, it will fail with a timeout, which is dependent on the export response. Therefore, it is crucial to monitor the performance of the data export to avoid timeouts.
- For further details on service protection API limits, refer to the documentation provided by Microsoft.