Reporting Services Report in CRM 2015 error

(0) Share

Report

Posted on by Vijayakumar Kenchug...

1,075

Hello,

I am getting an error (see below image) exact after 5 mins (300 secs). It works well when I use SQL data tool report designer preview. It takes more than 6 mins during Preview. But when I launch this report from Account form on CRM 2015, it throws the error. Please let me know if some one already face this kind of issues before. I checked reporting server settings in SSRS website URL for timeout setting. There, it is defaulted to 1800 secs (30 mins). Is there any other place inside CRM application about Reporting timeout settings?

Many thanks in advance.

2248.SSRS-Report-error.jpg

*This post is locked for comments

All responses (4)

Answers (1)

Vijayakumar Kenchug... 1,075 on at

Like (0)

Report

RE: Reporting Services Report in CRM 2015 error

Hi Nadeeja,

Web.Config httpRuntime executionTimeout="3600" fixed my issue. Thanks!!!
Verified answer

Nadeeja Bomiriya 6,804 on at

Like (0)

Report

RE: Reporting Services Report in CRM 2015 error

Hi VJ,

I believe so. Check below article which includes additional steps such as web.config changes. See the comments by Joseph Bonomo.

crmtipoftheday.com/.../when-publish-all-fails
Vijayakumar Kenchug... 1,075 on at

Like (0)

Report

RE: Reporting Services Report in CRM 2015 error

Hey Scott,

Thanks for quick response. I am using CRM2015 on premise. I am not sure all those timeout settings are still applicable for CRM2015 on SQL server 2012. Please let me know.
Suggested answer

ScottDurow 50,177 on at

Like (0)

Report

RE: Reporting Services Report in CRM 2015 error

If you are running CRM onPrem then you'll need to increase the query timeouts - blogs.msdn.microsoft.com/.../microsoft-dynamics-crm-timeout-settings