Error ‘An error occurred during report data sets execution’ in D365 Operations
Introduction:
In this blog article, we will see how to resolve timeout error in D365 Operations. Refer below screenshot for error. This error occurs when a report is processing many records and takes too long to execute. A report processing times out in 10 minutes.
Steps:
To resolve the error, follow below steps,
- Go to Tmp Table and change its Table Type property to TempDB.
- Go to RDP class and extend the class from SrsReportDataProviderPreProcessTempDB
- Save, Build and Deploy the Report.
Related posts:
How to review and accept changes to confirmed Purchase Orders in D365 F&O
How to run an SSRS report on a selected record in the CRM using FetchXml
Project Operations as source of truth for Professional Services Organizations
Streamlining Build Pipelines with YAML Template Extension: A Practical Guide