SBS-1 Unable to open database file

[ColR]

Hi all
Getting a very annoying basestation error message that happens very often when running my SBS-1 box.
I get an error box appearing and within it i can see "unable to open database file"
I am on software 1.2.3.159 and firmware 306

Ant help would be appreciated.

Regards

Col

[Anmer]

Are you running any other software which is also accessing the Basestation.sqb database file?

[ColR]

Hi Anmer

Not that i am aware of

Regards

Col

[ColR]

My last error message read :-

EKALE xception - Exception Initing newly created aircraft : ED atabase Error unable to open database file

Regards

Col

[Anmer]

Maybe the database has some corrupt data?

Does the error recur if you close and restart Basestation?

[ColR]

Yes
Happens every time i use it !

Cheers

[Anmer]

How big is the sqb file?  If it's not too big maybe I can get a copy and check it for errors.

[ColR]

223,729kb

[Anmer]

Can you try emailing me a copy?

info@radarspotting.com

[ColR]

Tried but the file is too big for my e-mail.

[Anmer]

You could use YouSendIt, free Lite version.

http://www.yousendit.com/compare-plans

[ColR]

Tried but the max size which is free to send by yousendit is 50mb

[Anmer]

Sorry, I forgot about that limitation.

Would you be happy to try some SQL housekeeping on a copy of the sqb?

[ColR]

Yes no probs

[Anmer]

Apologies for the late reply.

You may have some SQL utilities, if not I find the free SQLite Expert Personal very good:

http://www.sqliteexpert.com/

Make a copy of the SQB file so you can revert if necessary.

Close Basestation and then run SQLite Expert and open the Basestation.sqb file (you will have to select Any File in the Files of Type window to expose the sqb file).

Select the SQL tab and enter this statement (omitting the quotation marks):

"PRAGMA Integrity_Check"

Then click "Execute SQL" button and let the query run.

If all is well the integrity check should complete with "OK".

If OK, then run a new query:

"Vacuum" to repack and reindex the database.

Execute the SQL.

If this runs OK, close the database and restart Basestation.

This may not find any errors so we may have to try something else.

By the way, are you using PlanePlotter or importing data from elsewhere?