Hi, im currently having trouble with my Historian database. I noticed the store and forward local cache is constantly at 100%, how can i clear this manually? I have tried deleting the database and re-adding but it comes back at 100%.
I would look at the quarantine on the status page and see what records are stuck as the first step. Depending on how many tags you have in your historian(or using other store and forward features) the cache might need to be made larger.
It’s weird, the quarantine is clear and reading on the forums i tried enable/disabling cache. However it will just freeze on the re-enable stage.
When looking at the following page, are you seeing anything out of the ordinary that might look like a rogue query?
Status > Databases
Click the Details button for the DB in question
Also, are there any errors in your database logs?
The data in the cache is stored on the Gateway in the data/datacache directory in a folder named after the database connection you created. This folder doesn’t go away when you delete the DB, and the information contained in it would return if you created a connection of the same name. This is intentional as we don’t want you to lose that data accidently.
If you really need to clear the cache (as well as any of the data that was included in it, i.e. do so at your own risk), you would want to shut Ignition down and rename the DB folder to be something different. On startup a new folder will be created and Store & Forward will start using that folder structure and the cache will be cleared.
If the cache isn’t being cleared though, there is likely a separate cause that you should spend the time to identify. Looking at the logs and queries being run should help identify where an issue might exist.
the problem was indeed sorted by clearing the datacache through the directory. It has not reoccured since, so i suspect it just errored during the update to v8.
I deleted all database connections + real time and historic tag providers but still have a several old queuesof store and forward entries which i would like to clear.
I navigated to Ignition install folder\data\db and stopped ignition and then renamed db folder hoping it will be recreated but i got initial screen allowing me to choose which version of ignition i would like to install.
Can you please confirm if this is what i should do to clear completely store and forward (i dont need this data). Are there any other less extreme ways of clearing that store and forward data?
This is not what should have been done. the
\data\db folder contains the all the configuration for your Gateway and that is why the system is prompting you to recommission. You will want to:
- Shutdown Ignition
- Rename the folder back to what it was before
- Start Ignition to confirm that your Gateway's configuration was restored
The store and forward files are in the
data/datacache directory. Again I recommend only renaming them/relocating them and not deleting them. Only do this after you have confirmed your Gateway is back to a stable state.
thanks for reply - i understand the steps for normal ignition. Can you please confirm which folder to delete on edge gateway as i could not find datacache folder?
Edge doesn't have database connections, and therefore no store-and-forward caches. You say above that you deleted database connections. Ergo, not Edge.
Maybe you should start a new topic that has exactly your situation.
my problem is already solved and was related to full ignition. I thought that edge must have store and forward because it can keep up to a week of data but as you confirmed that was wrong.