V2.33.0.0 database disconnect multiple times

Post Reply
on6at
Advanced Class
Posts: 53
Joined: 19 Oct 2020, 13:36
Location: Gavere
Contact:

V2.33.0.0 database disconnect multiple times

Post by on6at »

Hello,

I have been using LOG4OMv2 for a few years now, and have noticed several times that the connection between the program and the database is lost.

Until now I have pressed backup after every shutdown of the program.
Normally this should not happen, because the program automatically creates a backup.
This way I can always restore a backup whenever necessary.

But it is frustrating to enter 20 to 25 QSL cards again, because you lost the database connection with your call.sql file.

The info is in the call.sql file, but not in the backup file, because it has not been created yet.

Apparently no backups are taken every so often.
Let's say a backup every 5 minutes.
This way the repairs in the database would be easy.

On the other hand, I don't know exactly what the reason is why the database is suddenly no longer found, because the SQL file is still present in the folder.
And yet the software can no longer connect to the file.

The program usually loses the database connection if, for example, you update LOTW or QRZ.COM where many operations are performed.

It is now the 5th time that I restart the database connection when entering a received QSL card. 😒

The program is open and I am working in QSL Manager.
Enter the call, then open the qso because I still have to fill in a few info for an award (DOK, IPA, Province, etc.)
You cannot do this by simply pressing qsl receive.

So the database gets an operation.

I don't use a transceiver during this operation, so I don't think USB link (CAT) interference is causing the database to "disappear".

I don't know if anyone else has this problem with this program. But I see this pop up on a regular basis in this forum.

Question: can the backup time be set to, for example, 3 minutes or changed?

73's de ON6AT Patrick
73 Patrick ON6AT
Member UBA-IPA
WCA: ON-01354
User avatar
G4POP
Log4OM Alpha Team
Posts: 11600
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: V2.33.0.0 database disconnect multiple times

Post by G4POP »

When these issues occur its is usually a windows permission issue with the file being marked either no access of read only.

Often this is after a windows update or when using OneDrive.

No you cant alter the backup interval and automatic intermittent backups is not something that has been requested or considered because normally the provided auto backups on program close have worked well.
73 Terry G4POP
on6at
Advanced Class
Posts: 53
Joined: 19 Oct 2020, 13:36
Location: Gavere
Contact:

Re: V2.33.0.0 database disconnect multiple times

Post by on6at »

Hi Terry,

I want to come back to this issue.

After a long search, because I don't use OneDrive, I found the problem.
I have a NAS system. And among other things, backups of my HAM software are made on the NAS.

Since there is a synchronisation between the Windows platform and the NAS, you get a kind of delay like OneDrive.
(I didn't realise this!)

This gives you the following:
When editing the QSOs via QSL Manager and you use QRZ.com to update your data, you get the error "log database not found"
or something like that after ending the task.

It took me a while to realise that the synchronisation with the NAS was also a problem.

Now everything is outside the synchronisation and everything goes very smoothly.

I just wanted to let you know this Terry.

Thank you for your great support about this program.
73 Patrick ON6AT
Member UBA-IPA
WCA: ON-01354
User avatar
G4POP
Log4OM Alpha Team
Posts: 11600
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: V2.33.0.0 database disconnect multiple times

Post by G4POP »

Thanks for letting us know Patrick that certainly would seem to be the issue
73 Terry G4POP
Post Reply