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
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?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Anonymous I can access it in the source system properly without any problem.

       

      • AnthonyMathu's avatar
        AnthonyMathu
        Frequent Visitor
        3 years ago

        Was this solved? I am having the same challenge with refreshing an API. i keep recieving the error "The refresh operation failed because it took too long to complete. Consider reducing the size of your dataset or breaking it up into smaller datasets."; I have followed the instructions to no avail