LOTW upload error keeps repeating

[M0MDS]

Hi,

Recently I noticed LOG4OM was not uploading correctly to LOTW, it was hanging when you shut down LOG4OM trying to do something.
I turned on the more verbose version of the logging and it reported an error on TQSL "Already Uploaded QSO suppressed on line 9....
Giving me a choice to Ignore or cancel.
The QSO in question was from a long time ago, it looks like LOG4OM is trying repeatedly to upload the QSO.

I deleted the QSO from the log and it is still doing it, I have no idea where it is even storing the QSO ?

Please can you help?

Mike
M0MDS


=========================================

#++++++++++++++++++++++++++++++++++++
# Log4OM 2 by IW3HMH version 2.20.0.0
# http://www.log4om.com
# created: 13 September 2022
#++++++++++++++++++++++++++++++++++++

<ADIF_VERS:5>3.1.0 <PROGRAMID:7>Log4OM2 <PROGRAMVERSION:8>2.20.0.0 <eoh>

<CALL:6>SV3AUW <BAND:3>30m <MODE:3>FT8 <QSO_DATE:8>20211230 <TIME_ON:6>183030 <ADDRESS:39>108 Lakonikis St. Kalamata 24133 Greece <A_INDEX:1>7 <ANT_AZ:1>0 <ANT_EL:1>0 <CONT:2>EU <COUNTRY:6>Greece <CQZ:2>20 <DISTANCE:7>2398.14 <DXCC:3>236 <EMAIL:20>sv3auw@hotmail.co.uk <EQSL_QSL_RCVD:1>R <EQSL_QSL_SENT:1>R <FREQ:9>10.137780 <GRIDSQUARE:4>KM17 <ITUZ:2>28 <LOTW_QSL_RCVD:1>R <LOTW_QSL_SENT:1>R <MY_CITY:6>London <MY_COUNTRY:7>England <MY_CQ_ZONE:2>14 <MY_DXCC:3>223 <MY_GRIDSQUARE:6>IO91wo <MY_ITU_ZONE:2>27 <MY_NAME:10>Mike Field <MY_POSTAL_CODE:7>N22 7AZ <MY_RIG:6>IC-705 <MY_STREET:19>4 St Saviours Court <NAME:13>Takis Perreas <OPERATOR:5>M0MDS <OWNER_CALLSIGN:5>M0MDS <STATION_CALLSIGN:5>M0MDS <PROGRAMID:7>LOG4OM2 <PROGRAMVERSION:8>2.20.0.0 <QSL_RCVD:1>R <QSL_RCVD_VIA:1>E <QSL_SENT:1>R <QSL_SENT_VIA:1>E <QSL_VIA:53>No paper QSL pse! Lets keep it electronically simple! <QSO_COMPLETE:1>Y <QSO_DATE_OFF:8>20211230 <QTH:8>Kalamata <RST_RCVD:3>-10 <RST_SENT:3>+01 <SWL:1>N <TIME_OFF:6>183159 <TX_PWR:2>80 <K_INDEX:1>2 <LAT:7>37.0388 <LON:7>22.1208 <MY_LAT:7>51.6042 <MY_LON:6>-0.125 <MY_ANTENNA:5>BTV-6 <QSO_RANDOM:1>Y <SFI:3>111 <EOR>

=====================================================================

[KI5IO]

Mike,

Two things I would do:

Update to the most current version of Log4OM v2.

Update to the most current version of TQSL.

Try your uploads after those two APPs have been updated.

[M0MDS]

I have upgraded TQSL to the latest version.
I am running LOG4OM v2.20.0.0 It doesn't offer me an upgrade.

[M0MDS]

I have manually updated to v2.23.0.0
Still getting same issue. I am assuming the entry has not been marked as sent and LOG4OM keeps trying to upload it.

Can I edit the db somehow to fix it?

[KI5IO]

Mike,

QSL Manager and select LOTW and you can edit the items as you need.

[M0MDS]

When I do that, the item doesn't appear.
I search on the callsign and get other QSO's with the same callsign, but not the one causing the issue.
Probably because I deleted the QSO in order to fix the issue. The deleted QSO is probably still in the Database, but now "hidden"

[M0MDS]

I browsed the sqlite db using DB Browser and confirm that the rogue entry is still in the database, but presumably one of the fields marks it as deleted. I could delete the entry in DB Browser but I don't want to break any indexes etc.

[G4POP]

Export your log to an ADIF file, use the full export then import that ADIF to a new database

[M0MDS]

OK so I exported to ADIF and re-imported to a new database, and all seems fine now.

Thankyou for your support, (and great logger)

Mike
M0MDS