SmartViews Sync Error - "Cannot find column __"

SmartViews Sync Error - "Cannot find column __"



If this error is ever encountered, update SmartViews as this was corrected in v452.1800

    • Related Articles

    • SmartViews - User Guide

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

    • SmartViews - Release Notes

      v480.1000 (2025.01.09) Change to framework 4.8 Remove 32 bit requirement Update DevExpress to v23.2Change to framework 4.8 v462.2001 (8/9/2024) Fixed memory limitations and leaks when loading large amounts of data in a View Turned off automatic ...

    • SmartViews - Local DB / Cache Reset

      What is it? SmartViews has a feature called "Reset Local DB," or "Cache Reset" as it was called before v462.1100. When you make changes in SmartViews, those changes don't immediately get pushed to the Cloud; instead, they are only made in a local ...

    • SmartViews 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 Error “The specified table does not exist [sv_Users]” - On Premise Installations

      SmartViews has an "On Premise" type of installation that allows customers to use a local SQL Server instead of the Azure cloud database. Depending on the version they are on, they may experience this error after updating to later versions: “The ...