CommandTimeout when running Maintain Database Indices Job

Fixed in

EPiServer.Commerce 11.2.2

Created

Aug 22 2017

Updated

Sep 13 2017

Area

Core

State

Closed, Fixed and tested


Description

With a big and highly fragmented database, the call to the SP can easily take more than 30 seconds.

To address this, a new parameter was added to the Commerce Scheduled Job "Maintain database indexes." The parameter lets you set a maximum number of seconds for which you want the job to run. Previously, the default value of 30 seconds was not adjustable