Update-EPiDatabase command timeout

Grzegorz Wiecheć

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

valdis

Vote:

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

#122784

Jun 12, 2015 15:23

valdis

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

Grzegorz Wiecheć

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

valdis

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