1) Before the issue crops up, take a NinjaTrader backup everyday. It's really easy:
a) Disconnect all "Connections"
b) Click "Tools->Export->Backup File..."
c) Make sure "Configuration files", "Database", "NinjaScript files", "Templates", and "Workspaces" are checked
d) Click "Export"
e) Give the file a name and what folder it should be saved in
f) Click "Save"
2) Now that you've encountered the error when NinjaTrader starts, shut down NinjaTrader
3) Navigate to your folder where your NinjaTrader backups are kept
4) Make sure that file name extensions are visible:
a) In your folder Explorer window, click the "View" menu
b) Make sure "File name extensions" is checked
5) Make a copy of the most recent backup file
6) Rename the the copied file from "<yourfilename>.nt8bk" to "<youfilename>.zip"
7) Double-click on the Zip file and within the file now double click on the "db" folder
8) Right-click the "Ninjatrader.sqlite" file and select "Copy"
9) Open up another file Explorer window and navigate to this folder: "C:\Users\<Windows user>\Documents\NinjaTrader 8\db"
10) Right-click the "Ninjatrader.sqlite" file and rename it to "Ninjatrader.old"
11) Right-click in the folder and select "Paste" to paste in the new "Ninjatrader.sqlite" file
12) Open up NinjaTrader and the issue should be fixed! If it is not (which happened to me), you'll need to do this same process on your next most recent NinjaTrader backup file
NOTE that using this backup database will fix the issue, however your most recent trade performance results will not be part of the database any longer. A trade-off, but worth it to get this annoying issue fixed.
Cheers!
Comment