We are getting a timeout on the Domain.Build(myURL) call. Domain.Build used to run in just under one minute, now it tries and fails just after one minute.

So, is there a way to govern the timeout in the URL properties? We are using MS SQLServer 2008, NOT 2008 R2.

I have tried setting the Domain.Sessions SessionConfiguration collection by adding a SessionConfiguration with a defaultquerytimeout set to 300 seconds.

Wondering if that will have an affect, in otherwords, during the Domain.Build, will the underlying domain build code, use the SessionConfiguration collection to setup the connection?

Thanks.... Ken

asked Mar 06 '12 at 18:22

kcrismon's gravatar image

kcrismon
5222


One Answer:

Hello Ken,

you might need to increase connection timeout.

Try the following snippet to set connection timeout to 3 minutes:

sqlserver://YourServer/YourDatabase?Connection Timeout=180

Connection URLs support the same parameters as connection strings.

Alternatively you can use standard connection strings:

From app.config:

<domain
  name="mydomain"
  provider="sqlserver"
  connectionString="Data Source=YourServer;Initial Catalog=YourDatabase;Integrated Security=True;Connection Timeout=180">

or from the code:

 var connectionString = "Data Source=YourServer;Initial Catalog=YourDatabase;Integrated Security=True;Connection Timeout=180";
 domainConfiguration.ConnectionInfo = new ConnectionInfo("sqlserver", connectionString);

For upgrade you might probably need to increase command timeout as well:

There is a special session configuration called "System" that is used for system purposes:

<domain name="mydomain"
  ...>
  <sessions>
    <session name="System" commandTimeout="180" />
  </sessions>

or the same from the code

 domainConfiguration.Sessions.System = new SessionConfiguration {CommandTimeout = 180};

answered Mar 07 '12 at 00:16

Denis%20Krjuchkov's gravatar image

Denis Krjuchkov
179325

edited Mar 12 '12 at 07:07

Your answer
Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!
toggle preview

Subscription:

Once you sign in you will be able to subscribe for any updates here

Tags:

×3
×3

Asked: Mar 06 '12 at 18:22

Seen: 1,776 times

Last updated: Mar 12 '12 at 07:07

powered by OSQA