Update-EPiDatabase command timeout

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
  • Member since: 2011

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

    #122784 Jun 12, 2015 15:23
  • Member since: 2011

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

    #122785 Jun 12, 2015 15:42
  • 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
  • Member since: 2011

    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