November Happy Hour will be moved to Thursday December 5th.

Update-EPiDatabase command timeout

Vote:
 

Hi,

I upgraded EPiServer to newest version. I run update-epidatase command and got command timeout exception.   

The error occured on tblActivityLog table.

I used SQL Management studio to execute script.

I'm wonder if it's possible to use update-epidatase with some extended value of CommandTimeout property.

#122777
Jun 12, 2015 11:03
Vote:
 

So, did you manage to update database eventually through SQL Management Studio?

#122784
Jun 12, 2015 15:23
Vote:
 

even epideploy.exe does not provide out-of-the-box way to increase command timeout. defaults to 30

#122785
Jun 12, 2015 15:42
Vote:
 

I manage to update schema by running SQL scripts via SQL Management Studio. I did it on only my Dev environment. I need to update other collegues machines, Test, Staging and Production servers. Usually I used update-epidatase and Export‑EPIUpdates to export and execute scripts which save a lot of time.

I also checked the code of epideploy.exe. The GetConnection method of DatabaseHandler class used DbProviderFactories.GetFactory to create connection:

 protected virtual DbConnection GetConnection()
 {
      DbProviderFactory DbProviderFactory = DbProviderFactories.GetFactory(this.ConnectionStringSettings.ProviderName);
//...
}

Maybe I could try to chcange the provider to my own with Timeout property increased to more than 30 seconds.

#122790
Jun 12, 2015 23:16
Vote:
 

That should affect only connection timeouts and not Command timeouts.

Commands were created within DatabaseHandler or similar class. Not quite sure that we can override Command.Timeout value without changing source of epideploy.exe.

#122792
Jun 13, 2015 5:26
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.