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 again after each of these steps. If login is successful, there is no need to move onto the next step.
- 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.
- Try a local cache reset.
- There may be a firewall issue. Make sure that the machine can access the address tcp:gjypiak7ki.database.windows.net at port 1433.
- Powershell Command: Test-Netconnection gjypiak7ki.database.windows.net -port 1433
Related Articles
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 ...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 - Error - Method not found: 'Int32 System.Runtime.InteropServices.Marchasl.SizeOf(!!0)'
This applies to SmartViews Version 452.1000 and above on Windows 7. Versions of SmartViews 452.1000 and above uses the .NET Framework 4.5.2 (as denoted by the first 3 digits of the version of SmartViews). If a user is on Windows 7 and encounters this ...SmartViews - Troubleshooting - Send User Invite - Failure Sending Mail
If you are running a version of SmartViews older than v452.1600, clicking Send User Invite will fail to email the receiving user. You will have to update to resolve this issue, but for a temporary workaround, click Show User Invite to view the user's ...Troubleshooting - Error - Cannot find specified protocol entry
If the following error is encountered while trying to launch Visual, check if there are any ODBC connections with the same name as the database name specified for the Visual connection. ...