SmartViews - Local DB / Cache Reset

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 database that is only visible to the user who makes those changes on that machine. When you click Sync in SmartViews, that pushes the changes from your local database up into the Cloud, and it also pulls down any changes that other users have pushed to the Cloud that aren't in your local database yet.

Resetting your local database/cache does a few things. First, it creates a backup of your local database in the SmartViews root directory. After that, it essentially performs a one-way sync: It pulls down a fresh copy of what is in the Cloud to your user. This means that any changes you've made on your end since your last successful sync (i.e. changes you've made that aren't in the Cloud database) will no longer exist in the main database, but they can be found in the backup if you need to find them again.

How do I reset?

There are two ways to perform the reset. First, if you hold down the Ctrl key while opening SmartViews, you will be prompted to reset your Local DB / cache. Click yes to reset. This may take a few moments.


Second, if you are on SmartViews v452.1000 or later, you can get the prompt to pop up by going to the (i) icon on the login screen and clicking either "Reset Local DB" (v462+) or "Cache Reset" (v452).


How do I restore a backup?

In the SmartViews root directory, you will find a file called "SmartViews_[your-user-key].sdf". If you've performed a local DB reset, you will also see a file with the same name but with the date and time of the reset appended to the file extension. The first file is your local database file, and the second file is the backup that was created by the reset.

You can find your user key in your SmartViews invite email, or from the (i) icon on the login screen.

If you lost unsynced data in your reset such as a new View that you wrote or a layout that you created, you can access them by restoring the backup. To do this, delete your local database (the one that ends in just ".sdf"), or rename it or move it to your Desktop. Then, rename the backup and remove the appended date and time so that the file extension is just ".sdf" so that SmartViews will recognize it as the local database file. Close and reopen SmartViews to be able to access the old database on sign-in, and you should find anything that was lost after you reset.

When should I reset?

There are a number of scenarios in which a Local DB / cache reset can be helpful or even necessary:
  1. You have made changes in SmartViews that you do not want to put out to other users. This is mostly applicable for designers and admins who want to test something locally and then revert it back.
  2. You forgot your password and have had it changed by an admin. Since you need to login to sync, the only way your local database will be able to get the new password from the cloud is by resetting it.
  3. SmartViews - Error “The specified table does not exist [sv_Users]” - Azure Cloud Database (zohodesk.com)
  4. You are getting an error when trying to sync. Older versions of SmartViews have been prone to occasional conflicts when certain changes are made locally or in the cloud. A cache reset may be needed to resolve that.
  5. You want to create a backup of your local database.

    • Related Articles

    • Clearing\Resetting The Local Cache in SmartViews

      This article is out of date. Read this one instead: Synergy Resources (zoho.com) There are times in which the local database becomes out of sync with the cloud database causing the sync functionality to stop working. Clearing the cache will solve ...

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

    • SmartViews Sync Error - "Cannot find column __"

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

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