none
An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset. (rsErrorExecutingCommand) Timeout expired. The timeout period elapsed prior to completion of the operation or the

    Question

  • Hi ,

    I am using SSRS 2008 R2 and one of my report is getting timed out.

    I tried so many things like increased time out in my shared dataset, report server site setting and in report server config file.

    But nothing helps.

    This report is working fine on other machines(non clustered env) but it is failing in clustered env.

    The stored procedure which i am calling from the report have one cursur.

    I can see the stored  procedure output on same server. But when i am running the report it is giving me timeout.

    Please suggest..


    https://www.mcpvirtualbusinesscard.com/VBCServer/card.aspx?tag=YagyaDattMishra&wa=wsignin1.0

    Monday, July 22, 2013 11:38 AM

Answers

  • Issue resolved after increasing the query time out in dataset....

    https://www.mcpvirtualbusinesscard.com/VBCServer/card.aspx?tag=YagyaDattMishra&wa=wsignin1.0

    • Marked as answer by Yagya Mishra Tuesday, July 23, 2013 10:57 AM
    Tuesday, July 23, 2013 10:57 AM

All replies

  • Issue resolved after increasing the query time out in dataset....

    https://www.mcpvirtualbusinesscard.com/VBCServer/card.aspx?tag=YagyaDattMishra&wa=wsignin1.0

    • Marked as answer by Yagya Mishra Tuesday, July 23, 2013 10:57 AM
    Tuesday, July 23, 2013 10:57 AM
  • is this the error which was fixed ?


    • An error has occurred during report processing. (rsProcessingAborted)
      • Query execution failed for dataset 'DataSet0'. (rsErrorExecutingCommand)
        • For more information about this error navigate to the report server on the local server machine, or enable remote errors


    • Edited by SS87 Tuesday, October 15, 2013 8:18 PM
    Tuesday, October 15, 2013 8:18 PM
  • No,

    It was time out error. If u  look at error details after the dataset time out mentioned.


    https://www.mcpvirtualbusinesscard.com/VBCServer/card.aspx?tag=YagyaDattMishra&wa=wsignin1.0

    Wednesday, October 16, 2013 4:34 AM