Styjun

Has any country ever had 2 former presidents in jail simultaneously?

On a tidally locked planet, would time be quantized?

dpdt switch to spst switch

Is there any references on the tensor product of presentable (1-)categories?

Start making guitar arrangements

Why did the Mercure fail?

How to implement a feedback to keep the DC gain at zero for this conceptual passive filter?

Non-trope happy ending?

Longest common substring in linear time

How do I color the graph in datavisualization?

What does "Scientists rise up against statistical significance" mean? (Comment in Nature)

Is it possible to have a strip of cold climate in the middle of a planet?

C++ debug/print custom type with GDB : the case of nlohmann json library

Added a new user on Ubuntu, set password not working?

Should I outline or discovery write my stories?

Strong empirical falsification of quantum mechanics based on vacuum energy density

"Spoil" vs "Ruin"

Multiplicative persistence

Why can Carol Danvers change her suit colours in the first place?

Why Shazam when there is already Superman?

It grows, but water kills it

What is this called? Old film camera viewer?

Offered money to buy a house, seller is asking for more to cover gap between their listing and mortgage owed

Reverse int within the 32-bit signed integer range: [−2^31, 2^31 − 1]

SSRS - report is aborted after 5 minutes, procedure runs 6 minutes in db

Hidden Features of SQL ServerSelect columns from result set of stored procedureWhat is the best way to auto-generate INSERT statements for a SQL Server table?SSRS - Severe error message when running stored procedureSSRS - Report returns no dataParameters from Stored procedures Inside SSRSReset identity seed after deleting records in SQL ServerSSRS: Reporting services with a stored procedure that returns columns with same nameSSRS Report timing out after 10 minutesSSRS Error after 240s

0

someone can advise me? I have procedure which runs 6 minutes in database. But when i start report with this procedure so report is aborted after 5 minutes. We have set timeout in Reporting Services on 30 minutes. Report has 550 rows and 32 columns (low size). Before in procedure was INSERT INTO dbo.table now i change it on #table. Can't Report Server remember last problem with insert into dbo.table?

sql-server reporting-services

share|improve this question

asked 2 days ago

Mike43279Mike43279

1

New contributor

Mike43279 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I am really not sure what your question is. A problem with the timeout, or is there an error on the table? Please update and clarify a) what code you are executing b) the change you're trying to make to the code.
  
  – Jacob H
  2 days ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I think that procedure is OK. In db is procedure successful. But report in browser shows: Loading... but after 5 minutes Report Server has status for this report: rsProcessingAborted.
  
  – Mike43279
  2 days ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I would rephrase your question. 5 minutes is a decent amount of time for a Stored Proc to run for an SSRS report. I can't imagine a user having to wait for 5 minutes for a dataset to return under most circumstances. Perhaps as a start you'd like help determine why your code is slow? If so, post the code, and the actual execution plan. Here is a good guide on how to do that.
  
  – scsimon
  2 days ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you check the log file for a corresponding thread aborted exception? Also, what is the ssrs client, report manager, report viewer or ssrs api in web app?
  
  – Ross Bush
  yesterday
  
  

  
  
  
  

add a comment | 

0

someone can advise me? I have procedure which runs 6 minutes in database. But when i start report with this procedure so report is aborted after 5 minutes. We have set timeout in Reporting Services on 30 minutes. Report has 550 rows and 32 columns (low size). Before in procedure was INSERT INTO dbo.table now i change it on #table. Can't Report Server remember last problem with insert into dbo.table?

sql-server reporting-services

share|improve this question

asked 2 days ago

Mike43279Mike43279

1

New contributor

Mike43279 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I am really not sure what your question is. A problem with the timeout, or is there an error on the table? Please update and clarify a) what code you are executing b) the change you're trying to make to the code.
  
  – Jacob H
  2 days ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I think that procedure is OK. In db is procedure successful. But report in browser shows: Loading... but after 5 minutes Report Server has status for this report: rsProcessingAborted.
  
  – Mike43279
  2 days ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I would rephrase your question. 5 minutes is a decent amount of time for a Stored Proc to run for an SSRS report. I can't imagine a user having to wait for 5 minutes for a dataset to return under most circumstances. Perhaps as a start you'd like help determine why your code is slow? If so, post the code, and the actual execution plan. Here is a good guide on how to do that.
  
  – scsimon
  2 days ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you check the log file for a corresponding thread aborted exception? Also, what is the ssrs client, report manager, report viewer or ssrs api in web app?
  
  – Ross Bush
  yesterday
  
  

  
  
  
  

add a comment | 

someone can advise me? I have procedure which runs 6 minutes in database. But when i start report with this procedure so report is aborted after 5 minutes. We have set timeout in Reporting Services on 30 minutes. Report has 550 rows and 32 columns (low size). Before in procedure was INSERT INTO dbo.table now i change it on #table. Can't Report Server remember last problem with insert into dbo.table?

sql-server reporting-services

share|improve this question

asked 2 days ago

Mike43279Mike43279

1

New contributor

Mike43279 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

sql-server reporting-services

sql-server reporting-services

share|improve this question

asked 2 days ago

Mike43279Mike43279

1

New contributor

Mike43279 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

asked 2 days ago

Mike43279Mike43279

1

New contributor

Mike43279 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 2 days ago

Mike43279Mike43279

1

New contributor

Mike43279 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 2 days ago

Mike43279Mike43279

1

2 Answers
2

active

oldest

votes

0

check the remote query timeout on SQL Server by running

sp_configure 'remote query timeout (s)'

If this says 300 then this is likely to be the issue. You can increase this value, check the documentation here..

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-remote-query-timeout-server-configuration-option?view=sql-server-2017

share|improve this answer

answered 2 days ago

Alan SchofieldAlan Schofield

6,45011021

add a comment | 

0

There are multiple timeout settings that affect SSRS report execution:

1) On a dataset level:

2) On SSRS instance level, config file rsreportserver.config:

<Add Key="DatabaseQueryTimeout" Value="120"/>

3) In a web.config file, which can be found in the same folder as rsreportserver.config:

<httpRuntime executionTimeout="9000" requestValidationMode="2.0" />

4) In a SSRS configuration table:

USE ReportServer
select Name, Value from ConfigurationInfo
WHERE Name in ('SessionTimeout','SystemReportTimeout')

If any value changed in 2, 3, 4 the restart of SSRS service is required

share|improve this answer

edited yesterday

answered yesterday

Alexander VolokAlexander Volok

3,372925

add a comment | 

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',
autoActivateHeartbeat: false,
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
);



);

Mike43279 is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55281447%2fssrs-report-is-aborted-after-5-minutes-procedure-runs-6-minutes-in-db%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

check the remote query timeout on SQL Server by running

sp_configure 'remote query timeout (s)'

If this says 300 then this is likely to be the issue. You can increase this value, check the documentation here..

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-remote-query-timeout-server-configuration-option?view=sql-server-2017

share|improve this answer

answered 2 days ago

Alan SchofieldAlan Schofield

6,45011021

add a comment | 

0

check the remote query timeout on SQL Server by running

sp_configure 'remote query timeout (s)'

If this says 300 then this is likely to be the issue. You can increase this value, check the documentation here..

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-remote-query-timeout-server-configuration-option?view=sql-server-2017

share|improve this answer

answered 2 days ago

Alan SchofieldAlan Schofield

6,45011021

add a comment | 

check the remote query timeout on SQL Server by running

sp_configure 'remote query timeout (s)'

If this says 300 then this is likely to be the issue. You can increase this value, check the documentation here..

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-remote-query-timeout-server-configuration-option?view=sql-server-2017

share|improve this answer

answered 2 days ago

Alan SchofieldAlan Schofield

6,45011021

sp_configure 'remote query timeout (s)'

share|improve this answer

answered 2 days ago

Alan SchofieldAlan Schofield

6,45011021

answered 2 days ago

Alan SchofieldAlan Schofield

6,45011021

answered 2 days ago

Alan SchofieldAlan Schofield

6,45011021

0

There are multiple timeout settings that affect SSRS report execution:

1) On a dataset level:

2) On SSRS instance level, config file rsreportserver.config:

<Add Key="DatabaseQueryTimeout" Value="120"/>

3) In a web.config file, which can be found in the same folder as rsreportserver.config:

<httpRuntime executionTimeout="9000" requestValidationMode="2.0" />

4) In a SSRS configuration table:

USE ReportServer
select Name, Value from ConfigurationInfo
WHERE Name in ('SessionTimeout','SystemReportTimeout')

If any value changed in 2, 3, 4 the restart of SSRS service is required

share|improve this answer

edited yesterday

answered yesterday

Alexander VolokAlexander Volok

3,372925

add a comment | 

0

There are multiple timeout settings that affect SSRS report execution:

1) On a dataset level:

2) On SSRS instance level, config file rsreportserver.config:

<Add Key="DatabaseQueryTimeout" Value="120"/>

3) In a web.config file, which can be found in the same folder as rsreportserver.config:

<httpRuntime executionTimeout="9000" requestValidationMode="2.0" />

4) In a SSRS configuration table:

USE ReportServer
select Name, Value from ConfigurationInfo
WHERE Name in ('SessionTimeout','SystemReportTimeout')

If any value changed in 2, 3, 4 the restart of SSRS service is required

share|improve this answer

edited yesterday

answered yesterday

Alexander VolokAlexander Volok

3,372925

add a comment | 

There are multiple timeout settings that affect SSRS report execution:

1) On a dataset level:

2) On SSRS instance level, config file rsreportserver.config:

<Add Key="DatabaseQueryTimeout" Value="120"/>

3) In a web.config file, which can be found in the same folder as rsreportserver.config:

<httpRuntime executionTimeout="9000" requestValidationMode="2.0" />

4) In a SSRS configuration table:

USE ReportServer
select Name, Value from ConfigurationInfo
WHERE Name in ('SessionTimeout','SystemReportTimeout')

If any value changed in 2, 3, 4 the restart of SSRS service is required

share|improve this answer

edited yesterday

answered yesterday

Alexander VolokAlexander Volok

3,372925

<Add Key="DatabaseQueryTimeout" Value="120"/>

<httpRuntime executionTimeout="9000" requestValidationMode="2.0" />

USE ReportServer
select Name, Value from ConfigurationInfo
WHERE Name in ('SessionTimeout','SystemReportTimeout')

share|improve this answer

edited yesterday

answered yesterday

Alexander VolokAlexander Volok

3,372925

answered yesterday

Alexander VolokAlexander Volok

3,372925

answered yesterday

Alexander VolokAlexander Volok

3,372925