LOTW download problem

General discussions about Log4OM features
Locked
F6OBT
Novice Class
Posts: 4
Joined: 14 Mar 2019, 21:56

LOTW download problem

Post by F6OBT »

hi

I have a problem for download the qsl from LOTW.
So the upload is ok, no problem
on the picture we can see that I have only 3 lines and after I have a pop up: Operation Completed.
but the download doen't work.
I have a Password LOTW without special character, just a password with letter and number, it's work fine when I log to LOTW ARRL, no problem.
pb_lotw.png
pb_lotw.png (54.62 KiB) Viewed 6009 times
thanks for help

olivier
User avatar
IW3HMH
Site Admin
Posts: 2925
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: LOTW download problem

Post by IW3HMH »

Actual filter downloads QSO confirmations received since March 5 2019.
If nobody sent you a LOTW confirmation in that time you will not receive anything.
Try moving the date a month or two in the past, and you'll probably see some (dupe) QSL.
If you need to refresh your whole LOTW archive simply set the date back in 1900
Daniele Pistollato - IW3HMH
F6OBT
Novice Class
Posts: 4
Joined: 14 Mar 2019, 21:56

Re: LOTW download problem

Post by F6OBT »

Thanks you for the answer,

I have change the date (01 january 2017), but nothing change , doen't work, only 3 lines...

I have not understand how I must do for "need to refresh your whole LOTW archive simply set the date back in 1900"
I must change the date back in tsql.exe progrom or directly to LOTW ARRL website?
thanks you

olivier
User avatar
G4POP
Log4OM Alpha Team
Posts: 10749
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: LOTW download problem

Post by G4POP »

No dont touch TQSL it is NOT used for the download just the upload

In Log4OM help set trace mode - Help/Debug mode-Log Level/trace

Then WITHOUT RESTARTING LOG4OM try another download

Now in Help/Show Log check to see what answers are coming back from LOTW

As you can see from the image below it is working OK here so its not LOTW down or a Log4OM issue, so its something simple at your end

Untitled.jpg
Untitled.jpg (98.54 KiB) Viewed 6000 times
73 Terry G4POP
F6OBT
Novice Class
Posts: 4
Joined: 14 Mar 2019, 21:56

Re: LOTW download problem

Post by F6OBT »

thanks Terry,

ok, I have do,
please find the result below:
I don't understand the ERROR at the end line
(I have replaced my real password by XXXXX in this log for secured)

2019-03-15 12:15:10.8307 INFO: LogWriter: #################################################################################################################
2019-03-15 12:15:10.8776 INFO: LogWriter: ########################################## PROGRAM STARTED ######################################################
2019-03-15 12:15:10.8776 INFO: LogWriter: #################################################################################################################
2019-03-15 12:15:10.8776 INFO: Log4OMMainWindow: ############## USER IS ADMINISTRATOR ##############
2019-03-15 12:15:10.8776 INFO: Log4OMMainWindow: Program started
2019-03-15 12:15:10.8776 INFO: Log4OMMainWindow: Log4OM folder set: C:\Users\Lenovo_PC\AppData\Roaming\LogOM\
2019-03-15 12:15:10.8776 INFO: Log4OMMainWindow: Log4OM backup folder set: C:\Users\Lenovo_PC\AppData\Roaming\LogOM\Backup\
2019-03-15 12:15:10.8776 INFO: Log4OMMainWindow: Log4OM hamlib folder set: C:\Users\Lenovo_PC\AppData\Roaming\LogOM\hamlib\
2019-03-15 12:15:10.8776 INFO: Log4OMMainWindow: Log4OM version: 1.30.0.0
2019-03-15 12:15:10.8932 INFO: FileManagement: CONFIG begin load
2019-03-15 12:15:10.9244 INFO: FileManagement: CONFIG load completed
2019-03-15 12:15:10.9244 INFO: Log4OMMainWindow: Executing preload auto-start sequence
2019-03-15 12:15:10.9244 INFO: Log4OMMainWindow: Preload auto-start sequence completed
2019-03-15 12:15:11.0182 INFO: SharedFunctionsManagement: INTERNET CONNECTION ACTIVE
2019-03-15 12:15:11.0182 INFO: FileManagement: File Management begin load localization
2019-03-15 12:15:11.0965 INFO: FileManagement: File Management localization loaded
2019-03-15 12:15:11.0965 INFO: Log4OMMainWindow: BAND LIST load start
2019-03-15 12:15:11.1276 INFO: Log4OMMainWindow: BAND LIST load completed
2019-03-15 12:15:11.1276 INFO: Log4OMMainWindow: CONTEST load start
2019-03-15 12:15:11.1276 INFO: Log4OMMainWindow: CONTEST load completed
2019-03-15 12:15:11.1276 INFO: Log4OMMainWindow: MODES load start
2019-03-15 12:15:11.1588 INFO: RSTUserControl: Loading RSTMode.csv file
2019-03-15 12:15:11.3151 INFO: Log4OMMainWindow: MODES load completed
2019-03-15 12:15:11.3151 INFO: Log4OMMainWindow: SATELLITES load started
2019-03-15 12:15:11.3307 INFO: Log4OMMainWindow: SATELLITES load completed
2019-03-15 12:15:11.3307 INFO: Log4OMMainWindow: Loading Awards list
2019-03-15 12:15:11.3307 INFO: FileManagement: AWARD LIST begin load
2019-03-15 12:15:11.3777 INFO: FileManagement: AWARD LIST load completed
2019-03-15 12:15:11.3777 INFO: Log4OMMainWindow: Awards list loaded
2019-03-15 12:15:11.3933 INFO: Log4OMMainWindow: Loading activations list
2019-03-15 12:15:11.4090 INFO: ActivationManagement: GetActivationList started
2019-03-15 12:15:11.6434 INFO: ActivationManagement: GetActivationList completed
2019-03-15 12:15:11.6434 INFO: Log4OMMainWindow: Activations list loaded
2019-03-15 12:15:11.6434 INFO: FileManagement: COUNTRY begin load countries
2019-03-15 12:15:11.7214 INFO: FileManagement: COUNTRY load completed: 402
2019-03-15 12:15:11.7370 INFO: FileManagement: IOTA begin load database
2019-03-15 12:15:11.7527 INFO: SolarDataManagement: GEOMAGNETIC DATA (DGD) downloading from ftp://ftp.swpc.noaa.gov/pub/latest/DGD.txt
2019-03-15 12:15:11.7527 INFO: SolarDataManagement: GEOMAG data begin download
2019-03-15 12:15:12.0184 INFO: FileManagement: IOTA load database completed: 1178
2019-03-15 12:15:12.0496 INFO: FileManagement: Begin loading SotaDatabase
2019-03-15 12:15:12.0496 INFO: FileManagement: begin load text file C:\Users\Lenovo_PC\AppData\Roaming\LogOM\summitslist.csv
2019-03-15 12:15:12.2839 INFO: FileManagement: Text file load completed
2019-03-15 12:15:12.2839 INFO: FileManagement: SOTA Summits List (Date=14/04/2016)
2019-03-15 12:15:12.2839 INFO: FileManagement: SummitCode,AssociationName,RegionName,SummitName,AltM,AltFt,GridRef1,GridRef2,Longitude,Latitude,Points,BonusPoints,ValidFrom,ValidTo,ActivationCount,ActivationDate,ActivationCall
2019-03-15 12:15:13.5183 INFO: SolarDataManagement: GEOMAG download completed
2019-03-15 12:15:13.5183 INFO: SolarDataManagement: GEOMAGNETIC DATA (DGD) load from file completed
2019-03-15 12:15:13.5339 INFO: SolarDataManagement: GEOMAGNETIC DATA (DSD) downloading from ftp://ftp.swpc.noaa.gov/pub/latest/DSD.txt
2019-03-15 12:15:13.5339 INFO: SolarDataManagement: GEOMAG data begin download
2019-03-15 12:15:13.9874 INFO: SolarDataManagement: GEOMAG download completed
2019-03-15 12:15:13.9874 INFO: SolarDataManagement: GEOMAGNETIC DATA (DSD) load from file completed
2019-03-15 12:15:14.0028 INFO: SolarDataManagement: GEOMAGNETIC DATA (Predicted) downloading from ftp://ftp.swpc.noaa.gov/pub/latest/Predict.txt
2019-03-15 12:15:14.0028 INFO: SolarDataManagement: GEOMAG data begin download
2019-03-15 12:15:14.4718 INFO: SolarDataManagement: GEOMAG download completed
2019-03-15 12:15:14.4718 INFO: SolarDataManagement: GEOMAGNETIC DATA (Predicted) load from file completed
2019-03-15 12:15:15.0184 INFO: FileManagement: begin load text file C:\Users\Lenovo_PC\AppData\Roaming\LogOM\SotaAssociations.csv
2019-03-15 12:15:15.0184 INFO: FileManagement: Text file load completed
2019-03-15 12:15:15.9092 INFO: FileManagement: SotaDatabase loaded
2019-03-15 12:15:15.9092 INFO: FileManagement: TUNE REMINDERS load start
2019-03-15 12:15:15.9716 INFO: FileManagement: TUNE REMINDERS load completed
2019-03-15 12:15:15.9716 INFO: FileManagement: Clublog begin load database
2019-03-15 12:15:16.7997 INFO: FileManagement: Clublog load database completed
2019-03-15 12:15:16.8153 INFO: FileManagement: SCL begin load unique callsign
2019-03-15 12:15:16.9560 INFO: FileManagement: SCL load completed: 4457
2019-03-15 12:15:16.9560 INFO: FileManagement: begin load RANKING
2019-03-15 12:15:16.9872 INFO: FileManagement: RANKING load completed
2019-03-15 12:15:16.9872 INFO: FileManagement: begin load RegExpFilters
2019-03-15 12:15:17.0029 INFO: FileManagement: RegExpFilters load completed Cluster
2019-03-15 12:15:17.0029 INFO: FileManagement: LOTW begin load from file C:\Users\Lenovo_PC\AppData\Roaming\LogOM\lotw.txt
2019-03-15 12:15:17.4561 INFO: Log4OMMainWindow: LOTW load from file completed
2019-03-15 12:15:17.4561 INFO: FileManagement: Non Standard callsign begin load from file C:\Users\Lenovo_PC\AppData\Roaming\LogOM\NonStandardCallsign.txt
2019-03-15 12:15:17.4561 INFO: Log4OMMainWindow: Non Standard callsign load from file completed
2019-03-15 12:15:17.4561 INFO: FileManagement: VIEW CONFIGURATION begin load for SmallQSO
2019-03-15 12:15:17.4561 INFO: FileManagement: VIEW CONFIGURATION load completed
2019-03-15 12:15:17.4561 INFO: FileManagement: VIEW CONFIGURATION begin load for SmallQSO
2019-03-15 12:15:17.4716 INFO: FileManagement: VIEW CONFIGURATION load completed
2019-03-15 12:15:17.5341 INFO: FileManagement: BAND PLAN begin load database for region 1 / 227
2019-03-15 12:15:17.5341 INFO: FileManagement: Bandplan loading file: C:\Users\Lenovo_PC\AppData\Roaming\LogOM\bandplan_r1.xml
2019-03-15 12:15:17.5654 INFO: FileManagement: BAND PLAN load database completed
2019-03-15 12:15:17.6591 INFO: WCFManagement: RunServices starting with path
2019-03-15 12:15:17.7373 INFO: WCFManagement: Opening
2019-03-15 12:15:18.8937 INFO: WCFManagement: Opened
2019-03-15 12:15:18.9093 INFO: WCFManagement: RunServices STARTED
2019-03-15 12:15:19.0029 INFO: TCPServer: Closing TCP Connection [RESET LISTENING SOCKET]...
2019-03-15 12:15:19.0342 INFO: TCPServer: Listening on port 8081
2019-03-15 12:15:19.0342 INFO: TCPServer: Executing C:\Program Files (x86)\IW3HMH\Log4OM\Log4OmCommunicator.exe TCPPORT:8081 HRDLOGUSER: HRDLOGUPCODE:
2019-03-15 12:15:19.2061 INFO: Log4OMMainWindow: Executing preload auto-start sequence
2019-03-15 12:15:19.2061 INFO: Log4OMMainWindow: Preload auto-start sequence completed
2019-03-15 12:15:19.4248 INFO: Log4OMMainWindow: Connecting to database...
2019-03-15 12:15:19.4248 INFO: DatabaseManagement: *** Connecting to Database SqlLite ***
2019-03-15 12:15:19.4405 INFO: DatabaseManagement: SQLITE Begin Connection Validation
2019-03-15 12:15:19.4717 INFO: DatabaseManagement: SQLITE Connection Valid
2019-03-15 12:15:19.4717 INFO: DatabaseManagement: *** Connected to database D:\Applications\radio\LOG_F6OBT_LOG4OM\F6OBT.SQLite ***
2019-03-15 12:15:19.5186 INFO: SQLiteDatabaseManagement: Recalculating statistics...
2019-03-15 12:15:19.5967 INFO: #=qLBNkl5SqPEllWKaKEUITv3E3T$K26iXuYfk9He3DnWw=: Statistics recalculated and refreshed
2019-03-15 12:15:19.6280 INFO: Log4OMMainWindow: Database connected
2019-03-15 12:15:19.6280 INFO: SQLiteDatabaseManagement: Recalculating statistics...
2019-03-15 12:15:19.6592 INFO: Log4OMMainWindow: Statistics recalculated and refreshed
2019-03-15 12:15:31.6975 INFO: Log4OMMainWindow: *********************************************************
2019-03-15 12:15:31.6975 INFO: Log4OMMainWindow: *********** LOGGING LEVEL: TRACE MODE *******************
2019-03-15 12:15:31.7131 INFO: Log4OMMainWindow: *********************************************************
2019-03-15 12:15:34.5884 INFO: Log4OMMainWindow: *Calling POST OFFICE FORM*
2019-03-15 12:15:34.7602 INFO: FileManagement: VIEW CONFIGURATION begin load for QSL
2019-03-15 12:15:34.7602 DEBUG: FileManagement: VIEW CONFIGURATION user file not found
2019-03-15 12:15:34.7602 INFO: FileManagement: VIEW CONFIGURATION load completed
2019-03-15 12:15:36.5571 INFO: FileManagement: VIEW CONFIGURATION begin load for LOTW
2019-03-15 12:15:36.5727 DEBUG: FileManagement: VIEW CONFIGURATION user file not found
2019-03-15 12:15:36.5727 INFO: FileManagement: VIEW CONFIGURATION load completed
2019-03-15 12:15:46.9638 INFO: LotwManagement: begin receive log
2019-03-15 12:15:46.9795 DEBUG: LotwManagement: Url https://LoTW.arrl.org/lotwuser/lotwrepo ... 2017-12-01
2019-03-15 12:15:49.0774 ERROR: *** LotwManagement: Receive log error ******* [Function: #=q3KBoQiW0fHK46nxjqkWWYZc8tMv_ADDakBlAC59373s=] System.Net.WebException: La demande a été abandonnée : Impossible de créer un canal sécurisé SSL/TLS.
à System.Net.HttpWebRequest.GetResponse()
à LogOM.BL.LotwManagement.#=q3KBoQiW0fHK46nxjqkWWYZc8tMv_ADDakBlAC59373s=(Object #=q6wgjuQ4sROB2hfJeybdnPA==, DoWorkEventArgs #=qFelwoMpj_PMvY29gULNXWA==)
2019-03-15 12:15:51.3989 DEBUG: Log4OMDataGrid: Initializing grid Log4OM Post Office
User avatar
G4POP
Log4OM Alpha Team
Posts: 10749
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: LOTW download problem

Post by G4POP »

This is your problem you are using an old version of Log4OM
2019-03-15 12:15:10.8776 INFO: Log4OMMainWindow: Log4OM version: 1.30.0.0
LOTW changed the security some time back which meant we had to change the LOTW support in Log4OM, this was done some time back but the version you are using has the old security codeing. PLEASE REGULARLY UPGRADE TO AVOID THIS KIND OF ISSUE.

download and install version 1.36 and you should be good to go - dont forget to install to 'RUN AS AN ADMINISTRATOR
73 Terry G4POP
F6OBT
Novice Class
Posts: 4
Joined: 14 Mar 2019, 21:56

Re: LOTW download problem

Post by F6OBT »

GOOD WORK Terry!!!!

it's work....

thanks you so much

olivier
User avatar
G4POP
Log4OM Alpha Team
Posts: 10749
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: LOTW download problem

Post by G4POP »

Pleased to help Oliver

Another satisfied customer :D
73 Terry G4POP
Locked