SmartViews - Extend Query Timeout

SmartViews - Extend Query Timeout

In some cases, you may want to extend the connection timeout in SmartViews if the query takes longer than the default 30 seconds to execute.  To do this:

Edit / Create a New View, select your database connection, then click "Edit"


When the Connection Wizard opens, click on "Advanced"


Scroll the advanced options until you see "Connect Timeout" and raise the limit.  (This field is in seconds):



Click OK here, and in the main Connection Wizard to save these changes.  Sync afterwards so this connection change can be synced on other SmartViews machines.

Please note that extending the connection timeout can cause performance issues on the database.  The query itself should always be investigated first and optimized before choosing to extend the connection timeout.

    • Related Articles

    • SmartViews - Release Notes

      v462.2001 (8/9/2024) Fixed memory limitations and leaks when loading large amounts of data in a View Turned off automatic syncing upon opening/closing SmartViews when the DisableSync flag is true v462.2000 (7/22/2024) Fixed tracking of versions used ...

    • SmartViews - User Guide

      Prerequisites: Windows Server 2016-2022 Windows 10-11 SQL Server 2012R2-SQL 2019 SQL Server 2017 minimum Cumulative Update (CU) is 31 (14.0.3456.2) Visual 7x-10 .NET 4.6.2 if outgoing ports are blocked at the organization’s firewall, the following ...

    • SmartViews LillyWorks connection - Can't load ProductionExecution "virtual" table schema

      This error does not come from SmartViews, but rather from the web service request. The error in the HTTP message itself is the "real" error, which could be one of many (i.e. it does not have to be "Call frequency cannot be more often than every 5 ...

    • Sql Server LocalDB Installation for New SmartViews

      Installation Instructions As of version 462.1000, SmartViews uses LocalDB 2017 in place of the previous local cache. As such, LocalDB 2017 or later needs to be installed on the machine, and an important patch needs to be applied. LOCALDB 2019 ...

    • SmartViews Network Requirements

      In addition to connecting to other databases to view their data, SmartViews also needs to be able to connect to a designated SmartViews database in order to run. This SmartViews database stores the data in SmartViews, such as user accounts, Views, ...