SSRS 2016 Sporatic Error rrRenderingError









up vote
0
down vote

favorite












I have an SSRS 2016 Report. When I run the report by clicking the report in the SSRS Site it runs fine. When I use the url to create the pdf like this:



http://vmbksa69901mdt/ReportServer_ssrs1p?/DAS/CDO_Suite/PortfolioHoldings&rs:Command=Render&ReportName=OCTAGO28_Portfolio_Holdings_pdf_1&rs:Format=PDF



It gives me the error:




The webpage at
http://vmbksa69901mdt/ReportServer_ssrs1p?/DAS/CDO_Suite/PortfolioHoldings&rs:Command=Render&ReportName=OCTAGO28_Portfolio_Holdings_pdf_1&rs:Format=PDF
might be temporarily down or it may have moved permanently to a new
web address. ERR_INVALID_RESPONSE




When I look at the view [dbo].[ExecutionLog3], it shows an error of rrRenderingError.



What's odd is that if I change the url and put the "format=Excel", it works fine. And then right away change it back to PDF it works fine.



So my guess is this is a timeout issue. Can anyone tell if that is a valid assumption? If it is, how do I go about changing that timeout? The underlying stored procedure for the report can take > 60s.



If it's not a timeout, how do I dig deeper into the logs to show me what the error really could be?










share|improve this question























  • depending on your setup there may be several areas that could timeout. It sounds like you are using a shared dataset though as this might explain why it works on subsequent runs. Check this link, it might be useful docs.microsoft.com/en-us/sql/reporting-services/report-server/…
    – Alan Schofield
    Nov 8 at 16:55














up vote
0
down vote

favorite












I have an SSRS 2016 Report. When I run the report by clicking the report in the SSRS Site it runs fine. When I use the url to create the pdf like this:



http://vmbksa69901mdt/ReportServer_ssrs1p?/DAS/CDO_Suite/PortfolioHoldings&rs:Command=Render&ReportName=OCTAGO28_Portfolio_Holdings_pdf_1&rs:Format=PDF



It gives me the error:




The webpage at
http://vmbksa69901mdt/ReportServer_ssrs1p?/DAS/CDO_Suite/PortfolioHoldings&rs:Command=Render&ReportName=OCTAGO28_Portfolio_Holdings_pdf_1&rs:Format=PDF
might be temporarily down or it may have moved permanently to a new
web address. ERR_INVALID_RESPONSE




When I look at the view [dbo].[ExecutionLog3], it shows an error of rrRenderingError.



What's odd is that if I change the url and put the "format=Excel", it works fine. And then right away change it back to PDF it works fine.



So my guess is this is a timeout issue. Can anyone tell if that is a valid assumption? If it is, how do I go about changing that timeout? The underlying stored procedure for the report can take > 60s.



If it's not a timeout, how do I dig deeper into the logs to show me what the error really could be?










share|improve this question























  • depending on your setup there may be several areas that could timeout. It sounds like you are using a shared dataset though as this might explain why it works on subsequent runs. Check this link, it might be useful docs.microsoft.com/en-us/sql/reporting-services/report-server/…
    – Alan Schofield
    Nov 8 at 16:55












up vote
0
down vote

favorite









up vote
0
down vote

favorite











I have an SSRS 2016 Report. When I run the report by clicking the report in the SSRS Site it runs fine. When I use the url to create the pdf like this:



http://vmbksa69901mdt/ReportServer_ssrs1p?/DAS/CDO_Suite/PortfolioHoldings&rs:Command=Render&ReportName=OCTAGO28_Portfolio_Holdings_pdf_1&rs:Format=PDF



It gives me the error:




The webpage at
http://vmbksa69901mdt/ReportServer_ssrs1p?/DAS/CDO_Suite/PortfolioHoldings&rs:Command=Render&ReportName=OCTAGO28_Portfolio_Holdings_pdf_1&rs:Format=PDF
might be temporarily down or it may have moved permanently to a new
web address. ERR_INVALID_RESPONSE




When I look at the view [dbo].[ExecutionLog3], it shows an error of rrRenderingError.



What's odd is that if I change the url and put the "format=Excel", it works fine. And then right away change it back to PDF it works fine.



So my guess is this is a timeout issue. Can anyone tell if that is a valid assumption? If it is, how do I go about changing that timeout? The underlying stored procedure for the report can take > 60s.



If it's not a timeout, how do I dig deeper into the logs to show me what the error really could be?










share|improve this question















I have an SSRS 2016 Report. When I run the report by clicking the report in the SSRS Site it runs fine. When I use the url to create the pdf like this:



http://vmbksa69901mdt/ReportServer_ssrs1p?/DAS/CDO_Suite/PortfolioHoldings&rs:Command=Render&ReportName=OCTAGO28_Portfolio_Holdings_pdf_1&rs:Format=PDF



It gives me the error:




The webpage at
http://vmbksa69901mdt/ReportServer_ssrs1p?/DAS/CDO_Suite/PortfolioHoldings&rs:Command=Render&ReportName=OCTAGO28_Portfolio_Holdings_pdf_1&rs:Format=PDF
might be temporarily down or it may have moved permanently to a new
web address. ERR_INVALID_RESPONSE




When I look at the view [dbo].[ExecutionLog3], it shows an error of rrRenderingError.



What's odd is that if I change the url and put the "format=Excel", it works fine. And then right away change it back to PDF it works fine.



So my guess is this is a timeout issue. Can anyone tell if that is a valid assumption? If it is, how do I go about changing that timeout? The underlying stored procedure for the report can take > 60s.



If it's not a timeout, how do I dig deeper into the logs to show me what the error really could be?







sql-server reporting-services ssrs-2016






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 8 at 16:19









jarlh

27.8k52137




27.8k52137










asked Nov 8 at 16:13









Bill Schanks

53110




53110











  • depending on your setup there may be several areas that could timeout. It sounds like you are using a shared dataset though as this might explain why it works on subsequent runs. Check this link, it might be useful docs.microsoft.com/en-us/sql/reporting-services/report-server/…
    – Alan Schofield
    Nov 8 at 16:55
















  • depending on your setup there may be several areas that could timeout. It sounds like you are using a shared dataset though as this might explain why it works on subsequent runs. Check this link, it might be useful docs.microsoft.com/en-us/sql/reporting-services/report-server/…
    – Alan Schofield
    Nov 8 at 16:55















depending on your setup there may be several areas that could timeout. It sounds like you are using a shared dataset though as this might explain why it works on subsequent runs. Check this link, it might be useful docs.microsoft.com/en-us/sql/reporting-services/report-server/…
– Alan Schofield
Nov 8 at 16:55




depending on your setup there may be several areas that could timeout. It sounds like you are using a shared dataset though as this might explain why it works on subsequent runs. Check this link, it might be useful docs.microsoft.com/en-us/sql/reporting-services/report-server/…
– Alan Schofield
Nov 8 at 16:55

















active

oldest

votes











Your Answer






StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













 

draft saved


draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53211763%2fssrs-2016-sporatic-error-rrrenderingerror%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown






























active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes















 

draft saved


draft discarded















































 


draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53211763%2fssrs-2016-sporatic-error-rrrenderingerror%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

𛂒𛀶,𛀽𛀑𛂀𛃧𛂓𛀙𛃆𛃑𛃷𛂟𛁡𛀢𛀟𛁤𛂽𛁕𛁪𛂟𛂯,𛁞𛂧𛀴𛁄𛁠𛁼𛂿𛀤 𛂘,𛁺𛂾𛃭𛃭𛃵𛀺,𛂣𛃍𛂖𛃶 𛀸𛃀𛂖𛁶𛁏𛁚 𛂢𛂞 𛁰𛂆𛀔,𛁸𛀽𛁓𛃋𛂇𛃧𛀧𛃣𛂐𛃇,𛂂𛃻𛃲𛁬𛃞𛀧𛃃𛀅 𛂭𛁠𛁡𛃇𛀷𛃓𛁥,𛁙𛁘𛁞𛃸𛁸𛃣𛁜,𛂛,𛃿,𛁯𛂘𛂌𛃛𛁱𛃌𛂈𛂇 𛁊𛃲,𛀕𛃴𛀜 𛀶𛂆𛀶𛃟𛂉𛀣,𛂐𛁞𛁾 𛁷𛂑𛁳𛂯𛀬𛃅,𛃶𛁼

Crossroads (UK TV series)

ữḛḳṊẴ ẋ,Ẩṙ,ỹḛẪẠứụỿṞṦ,Ṉẍừ,ứ Ị,Ḵ,ṏ ṇỪḎḰṰọửḊ ṾḨḮữẑỶṑỗḮṣṉẃ Ữẩụ,ṓ,ḹẕḪḫỞṿḭ ỒṱṨẁṋṜ ḅẈ ṉ ứṀḱṑỒḵ,ḏ,ḊḖỹẊ Ẻḷổ,ṥ ẔḲẪụḣể Ṱ ḭỏựẶ Ồ Ṩ,ẂḿṡḾồ ỗṗṡịṞẤḵṽẃ ṸḒẄẘ,ủẞẵṦṟầṓế