Re: DXKeeper 16.1.0 is available


g4wjs
 

On 21/04/2021 18:00, Dave AA6YQ wrote:
+ AA6YQ comments below

I have just done this upgrade and had a problem when I started DXKeeper afterwards. I received a message saying the log database could not be opened, I do get this occasionally due to some background locking from Dropbox where I keep my log database. This is not normally an issue as I simply open the Config window and click the Open button to open the log. This has always worked up until now. This time there is no Open button because the log database has gone! In its place is Uncompacted_G4WJS.mdb. I assume  I can copy that back to G4WJS.mdb and proceed as normal, but how DXKeeper got to this point without any warning seems to be an issue. 

Hi again Dave,

as a follow up, since I have backups of everything, I went ahead and renamed the Uncompacted_G4WJS.mdb back to G4WJS.mdb, restarted DXKeeper, and SpotCollector; all seems OK now.

+ When altering the characteristics of an existing QSO item -- like increasing its maximum capacity from 8 characters to 12 characters - DXKeeper

1. creates a new QSO item with the desired characteristics and gives it a temporary name

2. in every copy the contents of the existing QSO item to the new QSO item in every logged QSO

3. deletes the existing QSO item from every logged QSO

4. changes the name of the new QSO item to that of the just-deleted QSO item

5. makes a copy of the log file; if the log file is named X.mdb, the copy is named uncompacted_X.mdb

6. compacts the log file to reclaim the space consumed by the deleted QSO item

Steps 1, 2, 3, 4, and 6 are accomplished by sending directives to the database engine (Microsoft Jet). Step 5 is accomplished with the Windows Scripting Host, a capability included in every version of Windows.

Any unrecoverable error that occurs during the above steps is reported to the user in an on-screen window, or in an errorlog.txt file whose presence is indicated in the title bar of DXKeeper's Main window. Is there an errorlog.txt file in your DXKeeper folder? If so, please attach it to an email message, and send it to me via aa6yq (at) ambersoft.com

Since DXKeeper was first made publicly available 20 years ago, the above procedure has been invoked in more than 25 different DXKeeper releases to expand the capacity of existing QSO items or alter their "data type" (e.g. from character string to date). 

In your case, Bill, the existence of a recently-created Uncompacted_G4WJS.mdb means that steps 1-5 above were completed successfully, but step 6 evidently failed. Given that you've had chronic problems with DropBox as the host of your log file, that's disappointing, but not surprising. My advice is to

A. backup your log file 

B. compact your log file (Configuration window, Log tab, "Log file" panel, Compact button)

C. correct whatever problem is causing DropBox to not reliably store your log file, or abandon it in favor of a mechanism that works reliably

       73,

                 Dave, AA6YQ

Hi Dave,

here is the tail of my DXKeeper ErrorLog.txt:

2021-04-06 19:26:38     > DXKeeper version 16.0.7
2021-04-06 19:26:38     > App.Path          : C:\DXLab\DXKeeper
2021-04-06 19:26:38     > App.exe           : DXKeeper
2021-04-06 19:26:38     > Module            : C:\DXLab\DXKeeper\DXKeeper.exe
2021-04-06 19:26:38     > Operating System  : Windows 8.1 (64-bit) build 9600
2021-04-06 19:26:38     > Locale ID         : 2057 (0x809)
2021-04-06 19:26:38     > ANSI CodePage     : 1252
2021-04-06 19:26:38     > OEM CodePage      : 850
2021-04-06 19:26:38     > Country           : United Kingdom
2021-04-06 19:26:38     > Language          : English
2021-04-06 19:26:38     > DecimalSeparator  : .
2021-04-06 19:26:38     > ThousandSeparator : ,
2021-04-06 19:26:38     > DXLab Apps        : 
2021-04-06 19:26:42     > Monitors          : 2
2021-04-06 19:26:42     > Monitor 1
2021-04-06 19:26:42     >    width          : 1920
2021-04-06 19:26:42     >    height         : 1080
2021-04-06 19:26:42     >    dimensions     : (0, 0)-(1920, 1080)
2021-04-06 19:26:42     > Monitor 2
2021-04-06 19:26:42     >    width          : 1920
2021-04-06 19:26:42     >    height         : 1080
2021-04-06 19:26:42     >    dimensions     : (-1920, 0)-(0, 1080)
2021-04-06 19:26:42.417 > program error 3050 in module DXLogModule.OpenLog, state =  15, Pathname = C:\Users\bill\Dropbox\Radio\DXLabs\DXKeeper\Shared databases\G4WJS.mdb: Could not lock file.
2021-04-06 23:06:10.049 > Common.Terminate: DXKeeper shutdown

2021-04-21 10:22:29     > DXKeeper version 16.1.0
2021-04-21 10:22:29     > App.Path          : C:\DXLab\DXKeeper
2021-04-21 10:22:29     > App.exe           : DXKeeper
2021-04-21 10:22:29     > Module            : C:\DXLab\DXKeeper\DXKeeper.exe
2021-04-21 10:22:29     > Operating System  : Windows 8.1 (64-bit) build 9600
2021-04-21 10:22:29     > Locale ID         : 2057 (0x809)
2021-04-21 10:22:29     > ANSI CodePage     : 1252
2021-04-21 10:22:29     > OEM CodePage      : 850
2021-04-21 10:22:29     > Country           : United Kingdom
2021-04-21 10:22:29     > Language          : English
2021-04-21 10:22:29     > DecimalSeparator  : .
2021-04-21 10:22:29     > ThousandSeparator : ,
2021-04-21 10:22:29     > DXLab Apps        : 
2021-04-21 10:22:35     > Monitors          : 2
2021-04-21 10:22:35     > Monitor 1
2021-04-21 10:22:35     >    width          : 1920
2021-04-21 10:22:35     >    height         : 1080
2021-04-21 10:22:35     >    dimensions     : (0, 0)-(1920, 1080)
2021-04-21 10:22:35     > Monitor 2
2021-04-21 10:22:35     >    width          : 1920
2021-04-21 10:22:35     >    height         : 1080
2021-04-21 10:22:35     >    dimensions     : (-1920, 0)-(0, 1080)
2021-04-21 10:22:35.877 > program error 3024 in module DXLogModule.OpenLog, state =  14, Pathname = C:\Users\bill\Dropbox\Radio\DXLabs\DXKeeper\Shared databases\G4WJS.mdb: Could not find file 'C:\Users\bill\Dropbox\Radio\DXLabs\DXKeeper\Shared databases\G4WJS.mdb'.
2021-04-21 10:23:51.336 > Common.Terminate: DXKeeper shutdown

2021-04-21 10:31:54     > DXKeeper version 16.1.0
2021-04-21 10:31:54     > App.Path          : C:\DXLab\DXKeeper
2021-04-21 10:31:54     > App.exe           : DXKeeper
2021-04-21 10:31:54     > Module            : C:\DXLab\DXKeeper\DXKeeper.exe
2021-04-21 10:31:54     > Operating System  : Windows 8.1 (64-bit) build 9600
2021-04-21 10:31:54     > Locale ID         : 2057 (0x809)
2021-04-21 10:31:54     > ANSI CodePage     : 1252
2021-04-21 10:31:54     > OEM CodePage      : 850
2021-04-21 10:31:54     > Country           : United Kingdom
2021-04-21 10:31:54     > Language          : English
2021-04-21 10:31:54     > DecimalSeparator  : .
2021-04-21 10:31:54     > ThousandSeparator : ,
2021-04-21 10:31:54     > DXLab Apps        : 
2021-04-21 10:31:58     > Monitors          : 2
2021-04-21 10:31:58     > Monitor 1
2021-04-21 10:31:58     >    width          : 1920
2021-04-21 10:31:58     >    height         : 1080
2021-04-21 10:31:58     >    dimensions     : (0, 0)-(1920, 1080)
2021-04-21 10:31:58     > Monitor 2
2021-04-21 10:31:58     >    width          : 1920
2021-04-21 10:31:58     >    height         : 1080
2021-04-21 10:31:58     >    dimensions     : (-1920, 0)-(0, 1080)
2021-04-21 10:31:58.313 > program error 3050 in module DXLogModule.OpenLog, state =  1, Pathname = C:\Users\bill\Dropbox\Radio\DXLabs\DXKeeper\Shared databases\G4WJS.mdb: Could not lock file.

Nothing unusual happened between the 6th April and Today other than I started Launcher Today, saw an application update, processed it, then tried to start the Suite as I usually do.

Note the "Could not lock file" messages which seem to correlate with the "whatever problem is causing DropBox to not reliably store your log file" issue you cite. It seems to me, that other than causing the MDB file to be locked periodically, DropBox is doing nothing wrong as files can become locked for a number of reasons unrelated to the application that owns and manages the file, and applications may be able to wait and retry to avoid that becoming a problem. For sure it is not a "chronic" problem with DropBox.

I don't see any error messages related to scripts failing, the log file clearly was not recreated during the compaction process. I note again that apart from an error that the log file could not be found, no other error messages were shown. As far as I was concerned the log file simply disappeared.

73
Bill
G4WJS.


--
73

Bill

G4WJS.

Join DXLab@groups.io to automatically receive all group messages.