Message on the screen:
"Error has occurred in NinjaTrader database cache. Close NinjaTrader and delete 'Documents\NinjaTrader 8\db\cache' folder."
The solution by NinjaTrader:
Please use the following steps to rename the database file so NinjaTrader automatically creates a new one:
- Close NinjaTrader
- Go to Documents folder > NinjaTrader 8 > db > NinjaTrader.sqlite, right-click on this file and select 'Rename' and change the name to "NinjaTrader Old.sqlite" and then click off of it anywhere to save the name change
From there, use the following steps to remove all of the old Historical Data from the platform and re-download the new data:
- Close NinjaTrader
- Go to the Documents folder > NinjaTrader 8 > db, this folder holds all of the historical data
- Delete the following folders:
- Tick
- Minute
- Day
- Cache
- Do NOT delete any other files or folders
- After Deleting these folders, reopen NinjaTrader and it will make New ones automatically.
- Delete the following folders:
From here, reopen NinjaTrader.
The radical Solution:
- Close NinjaTrader. Delete 'Documents\NinjaTrader 8\db\cache' folder. If this didn't help see #2.
- Close NinjaTrader. Delete 'Documents\NinjaTrader 8\db' folder. You will lose all loaded market data. Backup this folder before deleting. NinjaTrader 8 will re-create \db folder on the next run.
- Run this utility to delete database cache BEFORE each NinjaTrader run: https://drive.google.com/file/d/1cGTd-4SjpWO2dujzr08dj4LGDci2flqe/view?usp=sharing