Last Updated: 11 Nov 2021 14:57 by ADMIN
Release R3 2021 SP1
Created on: 26 Nov 2020 13:36
Type: Feature Request
Make MSSQL Database Storage CommandTimeout configurable

Currently, the MsSqlServerStorage CommandTimeout is with the default value that is 30 s. In some scenarios, like when the Search functionality is enabled and the report is very big, the generated ClientSearchItemsResource may be too big, and when attempting to save it in the storage the latter may throw the exception 'System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.'

The error may be avoided if the CommandTimeout can be increased.