locked
Server timeout error RRS feed

  • Question

  • Hi,

    I have added a report web part in a Share Point site. Report viewer is pointing to report which is inside the report library of site. I am getting server timeout error if query is taking more than 90 seconds. I have changed the script timeout in IIS settings to 00:05:30 (330 seconds), still error is shown after 90 seconds.


    • Changed type Mike Walsh FIN Thursday, May 19, 2011 7:41 AM q
    • Moved by Mike Walsh FIN Thursday, May 19, 2011 7:41 AM BI ? - not programming (From:SharePoint - Development and Programming (pre-SharePoint 2010))
    Tuesday, May 17, 2011 9:42 AM

Answers

All replies

  • Hi sunil10788,

    If I understand correctly, you met the error in a SQL Server Reporting Services(SSRS) report. The error is shown within the report, not the whole page timeout.

    This is a SSRS question. In SSRS, there have many timeout setting. For example, DataSet query timeout, Server Session timeout, Server Session access timeout, and database query timeout.

    I would suggest you following these articles to fix the timeout issue:
    http://msdn.microsoft.com/en-us/library/bb283188.aspx (please see "To set processing time-out values")
    Setting Time-out Values for Report and Shared Dataset Processing (SSRS): http://msdn.microsoft.com/en-us/library/ms155782.aspx

    If you have any more questions, please feel free to ask.

    Also, in order to get better support about SSRS, please post the question in http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/threads

    Thanks,
    Jinchun Chen


    Jin Chen - MSFT
    Monday, May 23, 2011 7:04 AM
    Moderator
  • >Also, in order to get better support about SSRS, please post the question in >http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/threads

    As you will have noticed I earlier moved the thread to the BI forum (the pre-SP 2010 BI forum that is).

    In my opinion any question that starts "I have added a report web part in a Share Point site." belongs in the SharePoint forum that deals with SSRS rather than in a purely SQL Server Reporting Services forum as you suggest in your post.

    (and as duplicate/parallel threads are never a good idea, I presume you are suggesting posting *only* there ...)


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Monday, May 23, 2011 8:38 AM
  • Hi Mike,

    I agree with you. As sunil10788 mentioned she/he added a web part to render a report, so I answered her/his question.

    However, once we narrow down the issue, and confirm that the error is thrown by the SSRS, we can ask another question(e.g. How to solve Timeout in SSRS) in SSRS forum. The SSRS experts can give more valuable suggestion regarding SSRS.

    Thanks,
    Jinchun Chen


    Jin Chen - MSFT
    Monday, May 23, 2011 8:46 AM
    Moderator
  • I see what you mean.

    I think the solution is to suggest posting SSRS questions that don't involve Sharepoint to a SQL Server Reporting Services forum.

    So that we continue here to act as the first place for SSRS questions connected with SharePoint until such time the problem is confirmed to be a standard SSRS question (i.e. one that isn't unique to the SP environment) and then the thread here is closed and the user asked to post the specific SSRS question as a new thread to the SQL Server RS forum.

    (I have a horror of the same thread being in two forums because neither set of answerers know what has been answered in the other thread.)

    Mike


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Monday, May 23, 2011 9:27 AM
  • Thanks Mike Walsh FIN and Jin Chen for your inputs.

    Let me again explain the issue.

    My report gets rendered if query is not taking more than 90 seconds. when query takes more than 90 seconds reports viewer webpart displays nothing and JavaScript error is shown "PageRequestManagerTimeoutException: The server timed out." Should I post this issue in SSRS forum?


    Tuesday, May 31, 2011 8:51 AM
  • Hi Sunil,

    I think you should increase the executiontime in the web.config file and can you check if this link helps? http://social.msdn.microsoft.com/Forums/en/sharepoint2010general/thread/71b19dbf-8ed7-4bc7-af9e-54ed31d5f804

    Thanks,
    Skancharla

    Tuesday, May 31, 2011 8:56 PM
  • Thanks Skancharula!!!

    It works for me.

    Wednesday, June 1, 2011 5:39 AM
  • > It works for me.

    I don't understand how because that is a thread about SPF 2010.

    Your question - as it was posted to a pre-SP 2010 forum - was surely about MOSS 2007 (or an earlier / same generation product).

    Moderator

     

    Are you saying that your question in this thread was about SPF/SPS 2010 all the time ?


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters


    Wednesday, June 1, 2011 11:14 AM