Radarspotting

Hello All
I use 2 different desktops both running Windows 7.  one at one address and other at another address.  I have just started on 17 Nov 2020 to manually populate my BaseStation Reporter.  I wanted to move my Sqb. file to desktop B. to transfer the the updated changes over.  I tried Copy & paste from A to B desktop but the changes in my Database were not updated across. 

Then I tried the Backup & Restore option and this caused my both my Reporter programs to result in Not Responding and freeze.

Could anyone in the forum please help me fix this please.
Thank You
Steven

It's possible your BaseStation install was to the default location and the Windows' Virtual Store is where the "active" Basestation.sqb is to be found.

Do you have a secure copy of the original sqb file somewhere, the one you copied and tried to paste?

If you have, at least you haven't lost data.

Google "Virtual Store" to see how to expose the folder location.  There you should see a Basestation.sqb file that should be much larger than the one you have in the Program Files folder.

If this progresses OK, you should be able to replace the one in the Virtual Store and get BaseStation to run OK and see your old data.  If this works, you can copy the active sqb file to the other PC, again replacing the one in its Virtual Store.

Any questions please post back here.

Hello

Thanks for reply.  I looked in the Virtual Store on Windows 7 and there is nothing in there. (Yes, I showed hidden files & Folders)  my Sqb file is backed up for safety and in my C: in the Kinetic Basestation Folder I have a basestation.Sqb. file & also a basestation.Sqb.backup file think this second Sqb was generated when I used SqlLite.file repair tool

Thanks
Steven

Thanks.

On your main PC (the donor), what's the folder path for Basestation?

And does this installation run OK?

Hello

My Kinetic BaseStation is in the C: drive (Local Disk) not in the Programme Files folder if this is the correct info your asking me for.  Its C: - Kinetic Basestation - Basestation which contains all the Kinetic prgramme files.
Thanks Steven

Thanks Steven.

That folder location avoids the Virtual Store.

QuoteAnd does this installation run OK?

Does it?

Hello Amner
I thought the Virtual Folder only came into use when running Vista which in my case its Windows 7.
Kinetic BaseStation is located in the C: Drive by its self and not in Programe files or programe files x86

So my problem is I am unable to run a backup in basestation Reporter as it locks up and crashes right at the end of the process.

When moving my Sqb file using copy & paste to my Ext HDD then copy & Paste onto my other Desktop will copy & paste across fine but any BaseStation Reporter editing where I have been adding new aircraft manually will not show with the updates.  E;g I added BAH 08 A9C-HWR a RJ85 On 17/11/20 But in the Reporter on my other Desktop this entry is blank and its not saved the updated Aircraft.  Same goes for all the others on this date. I have refrained from carrying on manualy populating my Reporter programme

If anyone can understand what the error log is telling me would be helpfull as below
App: BaseStation Reporter
Version: 1.0.0.29

ERROR(S)

Occurred : 22:07:02.383 2020/11/24
Error : EOutOfMemory - Out of memory
Previous : O-WriteToDebugMemo | I-WriteToDebugMemo | I-DoExportTable | O-DoExportTable | I-DoExportTable | O-DoExportTable | I-DoExportTable | O-DoExportTable | I-DoExportTable | O-DoExportTable | I-DoExportTable | O-DoExportTable | I-DoExportTable | O-DoExportTable | I-DoExportTable | O-WriteToDebugMemo | I-WriteToDebugMemo | O-WriteToDebugMemo | I-WriteToDebugMemo | I-DoBackupDatabase | O-GridTimerTimer | I-GridTimerTimer | O-GridTimerTimer | I-GridTimerTimer | O-GridTimerTimer | I-GridTimerTimer | O-GridTimerTimer | I-GridTimerTimer | O-GridTimerTimer | I-GridTimerTimer

Thanks for the update.

The Virtual Store is a feature of all Windows versions from Vista onwards, including Windows 7.  For BaseStation users, if the ProgramFiles default install location is used, the "active" Basestation.sqb file gets placed in the VirtualStore and this can cause issues with out-of-application database updates, copying and replacing.

The good news is you installed BaseStation in a folder of choice which avoids the Virtual Store.  One question, which we can put to one side for now, is this the same on the other PC?

Ignoring that question for the moment, it would be good to get BaseStation running again without errors on the original PC.  We can revisit copying the Basestation.sqb to another PC afterwards.

I would suggest you forget about using BaseStation Reporter for backups.  However, it's crashing when you do which suggests possible database corruption.

Another thing to mention is the BaseStation.sqb cannot be updated, simultaneously, from different PCs.  If you copy it to a new PC, updates on the donor PC will not appear on the recipient one and vice versa.

At this time, does BaseStation run without errors on the original PC and can you upadate the database OK? And how are you making the updates?  Are you only using BaseStation Reporter to edit the sqb file?

Hello Anmer
Thanks for getting back to me, I thank you for your time helping me !

Since posting the below Error generated when attempting to run a backup in Reporter I have Since found out that the RAM on the 2nd Desktop is faulty !  I have ran 2 different memory Diagnostic Test both showing bad results.  So am going to sort out replacement RAM.  Wouldn't mind but it was Corsair Blue Vengence Pro XMP and cost £128 6 years ago.  I will sort the RAM out and retest again twice and see what happens.  Personally I think this is why the error log states out of Memory.  Durr my fault.  Also I found running SAS crashes as well explains it more.  I will get back and update you hopefully with every working but Would like to know when the RAM is fixed how I can work with 2 different Desktops & Databases Please

Thanks

Follow on: - 

I get the error on both Desktops when trying to run the Reporter BaseStation built in tool.  BaseStation runs fine with no crashing.  Running BaseStation Reporter also works fine apart from when running the backup.  I have no problems updating new Aircraft in BaseStation Reporter which I do this manually.  I use to use GAS but stopped and prefer manually editing.

Yes I am only using BaseStation Reporter to edit the Sqb. file via the Database daily when time permits.

Thanks for the further update.

If BaseStation is running OK on the host PC and you can edit the sqb file using Reporter, I'm assuming it should work OK on the recipient PC if you copy the sqb file and replace it on that PC.  That also assumes the Virtual Store isn't an issue on the recipient PC.

Try again when you have the memory issue resolved.  Do you also have a lot of files in your OperatorFlags folder on that PC? This can be an issue if the PC doesn't have a lot of installed memory.

Although GAS doesn't support AD anymore, I still find AD Lite is the easiest option for updating the BaseStation.sqb file, manually.  Quicker and easier than Reporter.

Post back here if you still have a problem when the memory is resolved.

Try to run BasestationReporter as an Administrator (right-click on the icon and choose Run as administrator). That will quickly tell you if it is an access problem. As that backup process creates a new file, it needs the correct privilege to do that. Running the program as an administrator guarantees that the program has the needed priviliges. If that's successful you know where to look to correct it.

Hello Anmer & Faramir
I sorted the memory out by removing the faulty dimm so down to 8GB from 16GB

Still same problem can run and edit Basestation Reporter but even when running Backup in Reporter as Administrator it get to near the end of the process and goes into Programme not responding then generates the typical Kinetic clipboard reporter for sending to Kinetic.

I can tell you on Both of my desktops that I do not have any folders or files in my Virtual Folder when showing hidden folders & Files.  I remember when I had Vista I did and had to manually sort this out but both of my desktops run 7 Premium Home 64 bit.

Thanks
Steven

Thanks for the latest feedback.

You may want to try a database "repair" using this suggestion posted by Sabrejv on the old Kinetic forum which I've used before?

The link for SQLite3.exe in Sabrejv's notes below has changed and this link may help:

https://www.sqlitetutorial.net/download-install-sqlite/

Use this possible sqb file repair at your own risk, and only work with copies of your Basestation.sqb file.

Create a new folder on your PC that you have full read-write access to I've called mine c:\SQBRepair

From the SQLite3 website download the command-line shell program for accessing and modifying SQLite databases.

http://www.sqlite.org/download.html

look for the file sqlite-shell-win32-x86-3070701.zip and download.

from the downloaded zip extract Sqlite3.exe and place it in c:\SQBRepair or whatever you have named your folder

==
Open Windows Notepad and copy the following lines into notepad and then save the file as SQBfix.bat into the same folder c:\SQBRepair or whatever you have named it.

rename basestation.sqb basestation.old
sqlite3 basestation.old < repair1.txt
sqlite3 basestation.sqb < repair2.txt

===
Again using Notepad copy these lines and then save the file as repair1.txt and save again in the same folder. The leading full stops/periods are necessary.

.echo on
.output repairdb.txt
.dump
.exit

===
Once more for the following lines saved this time as repair2.txt note the Pragma line does NOT have a leading full stop.

.echo on
.read repairdb.txt
PRAGMA integrity_check;
.exit

===

You should now have in your folder these 4 files

SQLite3.exe
SQBfix.bat
repair1.txt
repair2.txt

Now copy your Basestation.sqb file into the folder, make sure that you have plenty of free diskspace on the drive I suggest at least 2 times the size of the sqb is a minimum.

Double click on SQBfix.bat and the repair process should start to run in a CMD window.

The Basestation.sqb file is renamed Basestation.old and is then dumped as text into a file named repairdb.txt this can take a while depending on sqb file size.
This text file is then read into a new Basestation.sqb file and the process will take even longer as the text is read back in to create the rebuilt sqb file.

As the process runs the CMD window should scroll as statements are executed. If successful then a integrity check is run on the new sqb and this should return OK. You can then close the CMD window.

If things stop and stall for a long time (say 5 minutes of no activity) then Ctrl+C should abandon things when the focus is on the CMD prompt window or try to close the CMD prompt window with the 'X' button at the top right.

This repair uses SQLite3's ability to dump a database and read it back in as SQL statements - it probably will only fix simple errors and does not guarantee a fix. Copy and keep your original sqb safe before trying anything.

As I noted in my opening, trying this is at your own risk - it worked here but that was using an undamaged sqb 100mb in size.

Finally I can't remember where I first came across this method on the web and it also has appeared on this forum and elsewhere, so apologies for not crediting those individuals.

==
Sabrejv

Thanks Anmer for reply !
I looked in the Virtual Store Folder last night before switching off my desktop.  I found the following

C: - Users - Steven - App Data - Local - Virtual Store - Program Files (x86) I have
2 Folders. One called "Kinetic" which has the following inside Basestation Folder then BaseStation Configuration Settings, another one called BaseStationReporter Configuration Settings & BaseStation.sqb file date 30/10/20

In the other Folder I have the following:-
Kinetic BaseStation with User Data Folder, BaseStation configuration settings - BaseStationReporter Configuration Settings & a BaseStation.Sqb file dated 17/10/20

Inside the User Data Folder I have 2 files Temp 1 & Temp 2 XML Docs but not associated to be opened (unless I Concert them)

I am away till about Sunday and have access to my desktop which I do not Run the main Program on with the SBS-1 I just run Reporter.

So can you see if there is anything wrong with BaseStation files in the Virtual folder please.

Have I got duplicates causing issues maybe ?

Thanks Steven

Check the links that start BaseStation and BaseStation Reporter.

Are both targets to the BaseStation folder outside of ProgramFiles?

Hello Anmer

I have selected Properties of both BaseStation & BaseStation Reporter and have the following
BaseStation on my Desktop's File Path is C:\Users\Steven\other folders\Desktop
BaseStation Reporter has the File Path C:\Kinetic Basestation\BaseStationReporter.exe"

Is this any clue ?

Thank You
Steven

Thanks.

I'm sure the desktop shortcut for BaseStation will have a different target than the one you have shown?

Otherwise BaseStation can't start if you use the shortcut.

Right mouse click on the shortcut and select Properties, see attached. 

[attachment deleted reduce file load]

Hello Anmer

On my Desktop A which is my main one which I use as home I have the following

Properties for BaseStation is "C:\Kinetic Basestation\BaseStation.exe"
Properties for Reporter is "C:\Kinetic Basestation\BaseStationReporter.exe"


But I have noticed on Desktop B which I use when I am away has the following

Properties for Basestation is C:\Users\Steven\other folders\Desktop
Properties for Reporter is "C:\Kinetic Basestation\Basestation Reporter.exe"

So Desktop B seems things are not right to me.  I think when I installed BaseStation on Desktop B I ended up Copy & Paste the main icon for each of the programs or used create shortcut and sent to Desktop because the desktop icon was incorrect.

But also this doesn't explain to me why Desktop A when running a backup from the Basestation reporter option it crashes.  I never have basestation running when I try and backup.  What I do get is several Excel files with the data from Reporter in.

Going back though these file paths to concentrate on please.
Thank You
Steven

Thanks Steven

Desktop B's shorcuts don't look  correct,  Does the Reporter one launch Reporter on Desktop B?

You've mentioned a number of issues.

1. Reporter errors when making a backup on Desktop A.

2. Changes to your database are not being shown on Desktop B

Do you still have issue No. 2?  See my previous reply:

https://radarspotting.com/forum/index.php?topic=12358.msg50836#msg50836

Your database structure may have been amended, for example have you imported an sqb file from a third party?

Hello Amner

Reporter does launch/open on Desktop B & also ok on A

Both A & B reporter errors lockup when trying to make a back-up

Changes on Reporter desktop B does save changes ok

The editing/adding new Aircraft I did on Desktop B I copied over the Sqb. file to Desktop A.  The changes were not shown in Reporter on A.

Thanks
Steven

Quote from: ChiperHead007 on November 30, 2020, 01:44:39 PM
The editing/adding new Aircraft I did on Desktop B I copied over the Sqb. file to Desktop A.  The changes were not shown in Reporter on A.

Ignoring the Reporter errors when backing up, can I check I understand what's happening when you make changes to the BaseStation.sqb on Desktop A?

You edit the sqb file on Desktop A using Reporter.  You confirm these changes by veiwing the aircraft record again and this shows the recent changes?

You then close BaseStation and copy the sqb file to Desktop B.

Do you copy the sqb to a removeable drive or how?

On viewing a recently changed aircraft record made on Desktop A, the changes don't appear on Desktop B?

Hello Anmer

Yes I edit the Sqb. File on Desktop A using Reporter.  These changes save fine on Desktop A in reporter with no missing details !

I copy the Sqb. File onto a memory stick or External Drive and past into Kinetic Folder replacing the older Sqb. file.

its the Changes on Desktop A which miss the updated info I edit/add on desktop B in reporter.  eg; I added a Aircraft on 17 Nov BAH 008 and other new aircraft added.  Copy to External Drive and replaced Sqb file on A by paste into Kinetic Folder.

Any more info please ask

Thanks
Steven

Sounds to me like the file being captured and shifted, isn't the newly written one.
OR, you aren't over-writing the correct in-use one on the 2nd. Same scenario will cause - Multiple files/not right dbase location.

use search to look for *.sqb and you'll probably have a normal one, and a backed up copy (or several).

Per usual. Always temp duplicate ones being over-written before doing so until the 'good' one is narrowed down (and then remove non-working once confirmed working to stop being re-confused)

Quote from: ChiperHead007 on November 30, 2020, 09:10:09 PM
its the Changes on Desktop A which miss the updated info I edit/add on desktop B in reporter.  eg; I added a Aircraft on 17 Nov BAH 008 and other new aircraft added.  Copy to External Drive and replaced Sqb file on A by paste into Kinetic Folder.

Thanks.  Can I clarify.

How are you "adding" new aircraft?  Reporter doesn't allow adding a new aircaft.  Or are you adding aircraft details to an existing Mode-S record, such as the owner/operator, type, registration etc?

Also, if this is what you're doing, am I correct in understanding that after you've done this and then copied the sqb file to Desktop B, the changes aren't displayed in Reporter on Desktop B?

Picking up on Oblivian's message, does the date and size of the BaseStation.sqb file change on Desktop B when you view it in Windows Explorer after you've copied over an edited version from Desktop A?

Hello Oblivian & Anmer

Firstly Oblivion:  On Desktop A my Home one in Kinetic BaseStation folder I have 2 Sqb. Files one named BaseStation.Sqb.  &  And a second called BaseStation.Sqb.backup

The first Sqb. File is dated 01/12/20 as I have BaseStation running all day today.  The Sqb.Backup file is dated 28/12/2016 which is when I had to run a program called SQLiteFileRepair.Setup to repair a corrupt database in 2016.

The file size of the 1st Sqb. file is 1.64GB & the SQB. Backup file is 148GB

Would this Second SQB.File Backup file which seems to have not been used since 28/12/16 need deleting ?

I Searched for *Sqb and found 5 files one being the Backup File.  I also have a backup copy of these in a folder on my desktop with a load of redundant work files I keep intending to sort out.
Re Temp Duplicate being overwritten then removing the non working ones I am not sure how to do this Oblivion.

Anmer:
I open BaseStation Reporter select a Flight which does not have any Aircraft Details yet like SAS 2550 which was dep from Manchester today (9 miles from me in the west) then I use Airframes and type the Mode S/HEX in and get the Reg, Aircraft type and so on.  Then OK Save change then get the next Flt which has no details.
So as you say, Yes like this existing Mode-S record, such as the owner/operator, type, registration etc?

No the changes are not being Saved when I copy the Sqb. file back to desktop A.  Thinking about it, I have not checked is Desktop A Sqb. Copy to Desktop B Works showing the same updated new additions.

Before getting back to you I uninstalled BaseStation from Desktop B as I wish to start Fresh and make sure Basestation is installee correctly this time.
So you say, BaseStation Reporter when installed should be installed into the Virtual Folder on Win 7 64 bit ?  How can I copy over from Desktop A all my configurations and custom radar screen settings which are just the basics to Desktop B.

Will hang fire to see what you say.  Thank You both for sticking this issue out with me !
Cheers
Steven

Quote from: ChiperHead007 on December 01, 2020, 11:45:10 PM
Would this Second SQB.File Backup file which seems to have not been used since 28/12/16 need deleting ?

Up to you, it's not impacting on the current issue.

Quote from: ChiperHead007 on December 01, 2020, 11:45:10 PM
I Searched for *Sqb and found 5 files one being the Backup File.

Is this on Desktop A (which you said was your main one)?  Can you list the names of each of these and their folder locations, see below.

Quote from: ChiperHead007 on December 01, 2020, 11:45:10 PM
No the changes are not being Saved when I copy the Sqb. file back to desktop A.

I thought you said Desktop A was the main one and the problem of changes not appearing was on Desktop B?

Quote from: ChiperHead007 on December 01, 2020, 11:45:10 PM
Thinking about it, I have not checked is Desktop A Sqb. Copy to Desktop B Works showing the same updated new additions.

Can I suggest you make a list of all .sqb files, as they exist at this point in time, showing date modified and size, together with their folder locations, as follows:

Desktop A
C:/Kinetic/Basestation
basestation.sqb 02/12/2020, 2,296,370 KB

I want to be sure I understand what files are where.  Then, maybe, we can undertake an agreed, careful plan of action and check the results.

Hello Anmer

The problem/s is on Desktop A my main desktop when I have copied over and pasted the Sqb using External HDD from Desktop B.  explain another way.  When I manually added aircraft details on Reporter on Desktop B and moved the Sqb to Desktop A the updates for adding new aircraft were not saved in desktop A reporter.

I will compile a list of my .sqb files asap

Thanks
Steven

Hello Anmer

All from Desktop A as follows.  This is from the First .Sqb file
C:\Users\Steven\Desktop\Desk Top Files for Sorting March 2019\Desk Top Files Bck up Transfer\Desk Top Files 26 Feb 2015\Desktop Files etc\Memory Stick Backup\BaseStation
915 MB (959,621,120 bytes) 
Created 25 ‎February ‎2015, ‏‎21:57:25, Modified 23 ‎March ‎2013, ‏‎23:29:14 & Accessed 23 ‎December ‎2016, ‏‎19:36:22


C:\Users\Steven\Desktop\BS Backup 30 Nov 20
1.64 GB (1,766,339,584 bytes)
Created 30 ‎November ‎2020, ‏‎23:16:50, Modified 30 ‎November ‎2020, ‏‎23:10:30 & Accessed 30 ‎November ‎2020, ‏‎23:16:50

C:\Kinetic Basestation
BaseStation.sqb 03/12/2020 (1,766,543,360 bytes)

In the same folder I have BaseStation.sqb.backup
28/12/2016 (Type its a Backup File) 1.48 GB (1,595,980,800 bytes)
Accessed 18/11/20

Hope the above can help you to be able to help me.

Thank You
Steven

Just to add.  I have not got any Basestation folder files in windows 7 64 bit Virtual Folder.
Has this got anything to do with it ?

Thanks
Steven

Quote from: ChiperHead007 on December 03, 2020, 11:36:02 PM
Just to add.  I have not got any Basestation folder files in windows 7 64 bit Virtual Folder.
Has this got anything to do with it

No, this is not an issue.

What about Desktop B?

Hello Anmer

I uninstalled BaseStation of Desktop B to start fresh.  I have the original Installation CD but I take it there would be a newer software version to download.
Will be back later.  Having to go on a call-out and its chucking down with snow here.  Great fun.

Thanks
Steven

The latest BaseStation version is 184.  You can download the CD file here:

https://www.kinetic.co.uk/basestationdownloads1.php

Download the Basestation_184 CD

Install it to a designated folder, not the default location.

Are Desktop A and Desktop B in a different physical location (address)?

Hello Anmer

I clicked on the BaseStation_184 Cd and it said in a little box "I accept the T & C's" nothing would download when selecting the link

Thanks
Steven

Something's changed.  But.....

Right mouse click and select "Open Link in new tab".

This should them offer you the file to Save somewhere.  It just did for me.

Hello Anmer
Got it downloaded and installed on C: drive and not in Program Files or Program Files (x86)
I made a folder in C Drive called Base Station.

Ok, went to run Reporter and told me I have no Database.  Correct as its a clean install and I do not have the SBS 1 Box here with me on Desktop B.

I dpo however have a copy of my main .Sqb file back-up !

Am I correct In thinking I can drop my Sqb file inside the Base Station Program folder ?

Thank You
Steven

Quote from: ChiperHead007 on December 04, 2020, 10:52:53 PM
Am I correct In thinking I can drop my Sqb file inside the Base Station Program folder ?

When BaseStation was launched it will have created an empty Basestation.sqb file.  Rename this to BasestationOld.sqb and copy the backup file to the folder.  Then try running Reporter and see if you still get errors.

Please report back.