SmartViews - Troubleshooting - 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 - Troubleshooting - 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 - How To - 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 - Troubleshooting - Sync Error - "Cannot find column __"
If this error is ever encountered, update SmartViews as this was corrected in v452.1800
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 ...