SmartViews Error “The specified table does not exist [sv_Users]” - On Premise Installations

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 specified table does not exist [sv_Users]” 

When this occurs, log into the database that is hosting SmartViews and look at the schema of sv_Users.  If it doesn't contain a column named "Group", then run the following query:

ALTER TABLE sv_Users
ADD [Group] nvarchar(50) NULL;

Once complete, the error should be resolved.

    • Related Articles

    • SmartViews - Error “The specified table does not exist [sv_Users]” - Azure Cloud Database

      Depending on the version of SmartViews a customer is on, they may experience this error after updating to later versions: “The specified table does not exist [sv_Users]” The following steps should be tried in order to solve the issue. Try logging in ...

    • 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 - 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 Visual 11 - .NET 4.8 64 bit architecture if outgoing ports are blocked at the ...

    • 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 ...

    • 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 ...