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

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 again after each of these steps. If login is successful, there is no need to move onto the next step.
  1. Confirm whether or not they are on Azure cloud database by asking for either all of their user keys or specifically the validation key, accessed from the login screen. If the validation key is just zeros, that means they have an "On Premise" installation and should first try the steps in this KB article. Otherwise, ignore this step.
  2. Try a local cache reset.
  3. There may be a firewall issue. Make sure that the machine can access the address tcp:gjypiak7ki.database.windows.net at port 1433.
  4. Powershell Command: Test-Netconnection gjypiak7ki.database.windows.net -port 1433



    • Related Articles

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

    • 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 - 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 - 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 - Access to the database file is not allowed

      This is a folder permission issue. Make sure the folder permissions allow users modify rights. This should be done on the Smartviews folder which is the parent folder. If this is Terminal server, that will need to be done by an admin account.