AirNav Systems Forum
AirNav RadarBox and RadarBox24.com => AirNav RadarBox and RadarBox24.com Discussion => Topic started by: markyeulett on March 08, 2008, 12:56:52 PM
-
Air Nav
This morning after 2 hours of operation my computer crashed with a serious error caused by RB 2008. On re-boot the machine works fine but RB2008 will not boot up. I get an SQL error (see attached file for full details). From what I can make out the checkdb.dll file is corrupted. I have uninstalled and re-installed software but the problem persists. Anybody else had this - what do I need to do to fix?
Anybody else had this - ideas - Its really frustrating cos I am now locked out?
Thanks
[attachment deleted by admin]
-
In your AirNav RadarBox 2008\Data folder, do you see any db3-journal files, named NavData.db3-journal and MyLog.db3-journal?
You could try deleting the journal files. BIG WARNING - this may result in you losing some information.
-
After you have uninstalled, go back to the RadarBox 2008 folder in program files and remove any files in the data folder. Note: This will remove any enteries you had in the database.
Then install again. Important you seem to one the few customers who either is running RB without the internet or with a internet connection which is dropping (or wireless). For that reason insure when you start to disable sharing and turn the network off.
-
thx will try that and let you know - I have internet running on this machine which is the one that crashed so you can rule that out
-
tried that folks and same problem persists - however the uninstall did not seem to work correctly. When I re-installed it told me that for a number of the files the programme was unable to overwrite the existing files. should i delete all of the folders manually using file manager?
-
just tried to install into a seperate folder and problem persists
-
just renamed original files and moved them to another folder and re-installed and the problem persists
-
Uninstall and then delete the RadarBox 2008 folder and install again.
You may have had the internet connection on but it might have dropped or if it was wireless that may have dropped.
-
Done and back working - thanks (I had to manually delete everything). Any idea what caused the crash - has this occured before?
-
i saved my data folder - is there any way to copy that back and replace the new one?
-
There isn't it has been corrupted.
Important you seem to one the few customers who either is running RB without the internet or with a internet connection which is dropping (or wireless). For that reason insure when you start to disable sharing and turn the network off. So far out of the 300+ customers who have upgrade you are one of the few who have that this issue.
Its is being looked into.
-
the data file was not the one that was corrupted it was the checkdb.dll file - if its not corrupted how would you do it?
-
done it - just copied it all back and overwrote the files - brilliant !! I will be an expert soon :-)
Thx
-
Important you seem to one the few customers who either is running RB without the internet or with a internet connection which is dropping (or wireless). For that reason insure when you start to disable sharing and turn the network off. So far out of the 300+ customers who have upgrade you are one of the few who have that this issue.
RadarBox 2008 runs very well without an internet connection. I have been running it for 6 hours at a time on a laptop without an internet connection.
The problem as I see it is when you are running RadarBox on an Internet computer and for whatever reason, the internet connection briefly drops. I suffer from this problem due to my location. A wireless internet connection is always going to be a potential problem, as the connection can drop out every now and then.
So, what we need in the next RadarBox bug fix, is a more robust response to the internet dropping out.
As I was typing this, I got a red light on my modem as the internet dropped out again - the problem with living away from the town is that the phone lines have to stretch further :-(
RadarBox froze to a white screen due to the internet dropout. Closed it using the red X top right (which still works!) and started it again no problem.
-
I now have a similar problem - my computer has crashed and rebooted. When I re-started RadarBox, the following error message appeared:
SQLite Error 26 - file is encrypted or is not a database
And RadarBox refuses to start. I'm going to uninstall, remove the 2008 directory, clean the registry and re-install. I do hope this isn't going to be a persistent problem...
Although I have been connected on and off to the internet, I was not connected when the crash occurred.
DC
** Update - that seemed to work!
-
If you make a backup of these 2 databases every now and then, if your working databases do get corrupted, you can try replacing the working databases with the backups. This might save you time in doing a full unistall and reinstall and will preserve your data to the time of the last backup.
MyLog.db3
NavData.db3
Both in C:\Program Files\AirNav Systems\AirNav RadarBox 2008\Data
I back up my databases quite often as I'm playing around with them using other SQL programs - SQLite Database Browser and SQLite Maestro.
I've done some fairly major changes to both these db3 files, but I've never got to the point where RadarBox won't run.
Be advised that I'm no SQL expert, so it's your risk if you try this :-)
-
Deadcalm - make sure you remove all the files/folders. You should save your Data file as it propably will not be corrupted. You can then replace the new data files with your existing ones.
-
Have had the same SQL26 error message with Internet switched off but ok once reinstalled 2008
So do we NEED internet on at all times
-
Have had the same SQL26 error message with Internet switched off but ok once reinstalled 2008
So do we NEED internet on at all times
No, you do not need internet on all the time. RadarBox runs well very without the internet.
But if you do have internet, and the internet connection drops even for a very short time, then RadarBox locks up on some computers.
However, without the internet, you will get no Network data and no autopopulate of aircraft details.
-
If RadarBox does freeze, always use the red X in the top right of the RadarBox window to shut down if you can - usually this still works.
I have used this method to close RadarBox and I have never had an SQL error message or a corrupted SQL file.
-
Just a question which anti-virus are you using? I seem to be having occasional problems waking my computer after it has gone to standby since I installed Kaspersky and have to force the program which was running to close.
This hasn't happened with RB yet though
-
I use AVG Free - because it's FREE :-)
I don't think that we've done a poll to see what people are using.
-
AVG Free here too
-
so idem for me, AVG (but not free !!!)
i don't think that the reason of freezing.
Patrick
-
so idem for me, AVG (but not free !!!)
i don't think that the reason of freezing.
Patrick
Patrick, I think the reason for your freezing issues may be an interrupted internet connection. Are you working wireless?
-
We already have our main programmers correcting this issue. It is already identifies and easy to correct. We are waiting for updates and bug reports so we can release a patch in 1 to 2 weeks time.
-
My machine was working for 6 hours with no prloblems and then when I went to check an aircraft in my log and it froze on me. I have the wirless USB dongle on the table next to me and the connected light was showing all the time. If a disconnection took place it must have lasted only milliseconds - too quick to see but long enough for RB to detect and throw a wobbly :-(
-
Hello,
Good News that AirNav have identify the problem.
i have make some tests, with screenshots, to understand how and when
RB freezing, and it's not easy .... (for helping AirNav, but if they have found the problem)
There is a "connection" with internet, but i don't think thats about slower
and disconnect, but rather request who have no answer.
Thats "funny" to observe that performance make slower with at first
information in the interface freez, after flight positions but not the trail
line and in the end all the system (and always with 1 processing photo or
info request ....).
in this "period" if we want to acces to another function, freezing is immediat.
No difference about computer performance (on the scope), when RB start freezing the processus goes to 00.
i think it's only with specific request, but i'm happy that AirNav correcting the isssue and waiting for the release.
Thanks for your hard job
i confirm the "bug" about local time in the report , and i my opinion
it will be better if ALL the date and time are on local time with
this option (screenshot, recorder, files ...).
Patrick / F6GSG
-
I've had RB2008 freezing with a white screen the last 2 nights. I have recording running at the time, and each night the last recording entry was at 3:25am. With the 5 minute delay, that means RB2008 failed at exactly 3:30am each night.
Looking in the system log, I have the same event at 3:30am both nights:
"The WinHTTP Web Proxy Auto-Discovery Service service entered the stopped state."
-
Yesterday night, I raised screen saver ... but this morning freezer.Io think that would have been better off some functions, but a reliable operation.
Gianni --- Italy
-
Just had the same problem with "SQLite Error 26 - file is encrypted or is not a database"
Mine has been caused by a power outage that closed down the PC when RB was running.
Do I take it the only fix is to uninstall & reinstall, thus losing any data? Is there no way to fix the DB?
-
okay disregard, managed to fix mine by deleting two hidden files in the Data folder ( NavData.db3-journal & NavData.db3-stmtjrnl ) I guess these were open when the power outage happend and did not close correct!
-
okay disregard, managed to fix mine by deleting two hidden files in the Data folder ( NavData.db3-journal & NavData.db3-stmtjrnl ) I guess these were open when the power outage happend and did not close correct!
Beware doing this, it can result in a corrupted database - see http://rbgazette.com/?p=320
Much better to open the two databases in another SQLite tool (eg SQLite Maestro), which will force the journals to be flushed. Radarbox should attempt to flush the journals when it opens really to avoid SQLite lockout problems.
-
I had the same problem last saturday, the solution was desinstal and reinstal ANRB2008 again, I missed all flight update.
Brgds
CA
-
Guys - I am getting fed up of this now - just had 2 more complete SQL error system crashes in last 30 minutes - any ideas when we will get a bug fix to this ?
Thanks
Mark
-
Folks I have just read through the whole thread - are we confusing 2 issues here
- Programme Freezing - requiring shut down & restart
and
-SQLlite errors causing complte system failure, de-install, clean directories & re-install
My problem is the latter and its getting worse. I want to ensure that AirNav are focussing on both. The former is an irritant the latter is making the programme unusable.
Mark
-
I've never, ever had an SQL corruption issue - and this includes all the beta testing I've done and loads of unwise mucking around with the database files - am I lucky, or is there another issue here?
-
Hi Mark,
We haven't seen this issue regarding SQL Lite errors happening if RB is running. Obviously if RB crashes there is then a chance of it corrupting the database causing errors. We are rectifying the RB crashes and hence there will no corruption.
If you are getting corruption issues after a crash and have copied your old databases across you may need to start from scratch as they would have been corrupted.
-
Guys
You are missing the point - a number of people on this thread - which is specifically about a recurring SQL Lite errors and created on Saturday so dont know how you have not seen it before - have experienced the same thing. The only way to fix this is a complete de-install (including manual removal of folders and files) and reinstall. This has happened to me 3 times and has also been reported by the following:-
CarlosAbreu
DaveG
lennox2604
Deadcalm
So its clearly. I cant work out if you are saying you think its linked to the network drop out issues or not? Either way I think you need to log it as a seperate bug and look at a fix (which may = same as network drop out). I am going to get increasingly frustrated if I have to uninstall/re-install the programme every day and go through thge laborious process of copying the data logs/photos etc.
-
As on another post this problem is being corrected. It is being reported by 5% of the users that upgraded so it can even be related to the OS version you are using. We are working on it and have just sent a PM to the users where this is happening to get more details on their systems.
-
Mark,
We will explain it again to make it clear, I know there are lot of posts and hence there has been confusion.
1.) If RB runs fine without any termination (crashing or forcing to to close) there are NO SQL Lite Errors.
2.) If RB crashed while running just like any other program which has open files it is likely to casue corruption of the database (this is what you are getting when you re run after a crash)
As mentioned in our post above we are trying to rectify the crashing issue hence there will not be a chance to create the corruption. We will then look into making the database more redudant.
Tarbat has mentioned in post that with certain program you can get the database back from a corrupted state.
Hope that explains things.
-
AirNav while accepting that you are working on the problem which is much appreciated, telling people that there are programs (that cost money) that can get your database back, is not realy a way forward. The program mentioned by Tarbat costs in the region of £30 - and to have to buy it to fix AirNav problems is taking things a bit too far.
-
The program mentioned by Tarbat costs in the region of £30 - and to have to buy it to fix AirNav problems is taking things a bit too far.
Firstly, SQLite Maestro is a free trial for 30 days, and hopefully Airnav will have fixed this problem within 30 days ;) Alternatively, use a free SQLite data utility - http://sqlitebrowser.sourceforge.net/ is free. Just opening the two ANRB databases in a utility will flush the journal files and so may allow ANRB to run next time without problems.
I realise that this isn't ideal, and that Airnav need to fix this. But in the meantime, flushing the journal files may get you back to a working system much quicker than uninstalling/reinstalling.
-
Guys - to be clear thedatabase is not corrupted when this crashes - the file CheckDB.dll is corrupted. I can backup the database files before de-installation and re-installation and then copy them back in afterwards and all is well.
-
Guys - to be clear thedatabase is not corrupted when this crashes - the file CheckDB.dll is corrupted. I can backup the database files before de-installation and re-installation and then copy them back in afterwards and all is well.
What evidence do you have for this? If this is the case, then you've got a different problem to the SQLite Error 26 I've seen a few times. All I've even done is flush the journal files, and Radarbox opens fine.
I've NEVER had a corrupted CheckDB.dll , and I'd be surprised if Radarbox is updating DLL's.
When you say "I can backup the database files before de-installation and re-installation and then copy them back in afterwards", which files are you refering to?
-
Roadrunner,
Of course we are not suggesting customers to purchase the software. It does have a 30 trial period and you can bring your database back from corruption this way. We heop to have a solution by then.
markyeulett,
As mentioned in previous posts we are talking about the database being corrupted. It may bring up an error from the dll file but thats only because the dll file is checking the health of the database and find its corrupted and complains. You need to either remove the hidden database files (delete NavData.db3-journal & NavData.db3-stmtjrnl ) or use the program that tarbat has suggested.
Once again we aplogise for the issues.
-
I get to join the SQL error club. Mine started after a power failure that occured while at work. My son called and re-started my ACARS computers (what a great guy!) and couldn't get RB going and the SQL error is showing up. Will try the short fix before going to the re-install version of a fix. Hope this works....
Steve
-
Sadly just joined the number with the sqlite error 26 problem and the error was in my checkdb.dll....whatever that is.
If its any help to anybody,I had already made a complete copy of Radarbox 2008 within the Airnav folder and just copied the 2 database files across to the copy from the defunct file and it worked straight away....no using other programs or lengthy file copy procedures etc.
For the record,I have internet connection via a wire in the hotel so no connection dropout noticed and my whole pc froze...no white screen just stopped working and would not even ctl alt del.
Looking forward to the fix
-
We are working on it exactly now! Expect a new EXE in a few days.
-
It´s the second time this happens to me in one week !!!
All update work missing...I'm going to uninstall ans install v1.4 but without any manual update untill all problems being solved.
My backup from folder Data was not enough to recover the database !!!
Brgds
Carlos
-
After install again v.14 I copied my backup from folder "data" to the ANRB directory and this time it works fine...!!!
I only loose one day of updates, better than nothing...!!! Let's keep waiting for the patch to solve this problem.
brgds
CA
-
Carlos can you contact me now on my email?