Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Refresh Timeout

Hi there, I have a report which shows a timeout error specifically on a single view across different reports. Any help in solving the issue would pretty much appreciated.

With regards,

 

Need Help

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I was trying to refresh a specific view in the dataset which is giving me a timeout error across different reports. Any help regarding the issue would pretty much appreciated.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous 

     

    Click on the "gear" icon next to the Source step in your query.

    Enter a number greater than 10 in the "Command timeout in minutes" parameter, under Advanced Options.

    You may need to experiment with increasing the timeout until the problem is resolved.  By default timeout is set to 10 minutes, so if your query takes longer than that to respond it will fail.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      HI Anonymous  I have tried that option by trial and error,i.e entering a series of values in the parameter, but still not solved.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Anonymous have you verified that the server/table/view that you're trying to access is actually responding properly in the source system?

  • Icey's avatar
    Icey
    Community Support
    5 years ago

    Hi Anonymous ,

     

    Can you query the whole table in SSMS successfully?

     

     

    Best Regards,

    Icey