Finance | Project Operations, Human Resources, ...

Report giving timeout error

(0) Share

Report

Posted on by Mahwish Izhar

I have created a report and running it on 2 companies. 1st company has 100,000+ records and report is successfully rendering the data whereas the 2nd company has 20,000+ records only but it is still giving timeout error. Note that I have same report and rdp class for both the companies.

2330.20221214_5F00_011645.jpg

All responses (3)

Answers (0)

GirishS 27,823 Moderator on at

Like (0)

Report

RE: Report giving timeout error

First you try to troubleshoot the time out issues. Refer to below blog for troubleshooting.

https://www.avantiico.com/how-to-fix-ssrs-timeouts-in-ax-2012-the-right-way/#:~:text=SSRS%20report%20timeouts%20in%20AX,and%20explore%20the%20SSRS%20logs.

Have you gone through the below Microsoft documentation for specifying time out for the report.

https://learn.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/tips-to-help-prevent-long-running-reports-from-timing-out

Thanks,

Girish S.
Mahwish Izhar 10 on at

Like (0)

Report

RE: Report giving timeout error

I have already changed my report to preprocess and it is successfully inserting all the records but giving timeout error while rendering it.
Suggested answer

GirishS 27,823 Moderator on at

Like (0)

Report

RE: Report giving timeout error

Hi Mahwish Izhat,

For long running reports you can make use of "SrsReportDataProviderPreProcess".This class will prepare all the data required before calling the ssrs.

So your dp class should extend the above class.

There is some prerequisites to be done after changing it to "SrsReportDataProviderPreProcess".

Refer to the below link.

mfmujahidmim.wordpress.com/.../

Thanks,

Girish S.