SmartViews - How To - 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 - How To - Sql Server LocalDB Installation for New Instance
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, ...SmartViews Scheduler - User Guide
PREREQUISITES Supported Visual version are 7.0 – 11.x Database Platform: SQL Server & Oracle Microsoft .Net Framework 4.8 ADMINISTRATION LICENSING Request for a license key can be made via email. Send your request to CustomerCare@wm-synergy.com and ...SmartViews - Troubleshooting - Error - Missing FilterCriteria token, Add: FilterCriteria = @FilterCriteria
If you encounter the above error in SmartViews, you need to add the Filter Criteria to the WHERE clause of the query. Open up the Designer and navigate to SQL Designer -> SQL. If the query already contains a WHERE clause, append "AND FilterCriteria = ...SmartViews - Troubleshooting - 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 ...