You are viewing limited content. For full access, please sign in.

Question

Question

Forms Data Sources - Adjust timeout for Refresh?

Forms Self-Hosted
Updated October 10, 2024
asked on October 3, 2024

When the refresh button for a data source throws this error how can we approach it? Can we increase the timeout? We do want to perform the refresh to access new tables.

Message: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

0 0

Replies

replied on October 7, 2024

Hi Chad,

When clicking the refresh button, an api call will send to Forms service to check the data source's status, from this error it might be the profile is not correct, or connection is slow to the database server, can you verify the profile is still valid? And check in Event Viewer, is there more detailed error logs? You can open a support case then we can continue there.

1 0
replied on October 8, 2024

It is a slow database server in this case. We are able to refresh at certain times of the day when the server is less busy but we would like to be able to refresh anytime we need.

0 0
replied on October 8, 2024

To increase the timeout, you can find the Forms\Web.config from your Forms installation path, then find SQLServerCommandTimeout, and set it to a bigger value you like.

0 0
replied on October 10, 2024

Oh it seems we already increased this to 300 to allow for data maintenance to run overnight, did not realize they share the same configuration.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...