DBSQLITE error

Post Reply
MI0JLC
Novice Class
Posts: 8
Joined: 27 Sep 2020, 07:50

DBSQLITE error

Post by MI0JLC »

Hi, I am getting the following error when I save a contact from JTDX:

18:17:13.357 Error: [DbSqlite][dje_z6NSAYHGMRM2QZXA_ejd] : [SQLITE] InsertUpdateDatabase Command error
[EXCEPTION] constraint failed
UNIQUE constraint failed: Log.qsodate, Log.callsign, Log.band, Log.mode
18:17:13.365 Error: [DbSqlite][SaveQso] : SQLITE SaveQSO exception while saving QSO with QsoId 20230329181712036
[EXCEPTION] constraint failed
UNIQUE constraint failed: Log.qsodate, Log.callsign, Log.band, Log.mode

This is resulting in both the "my QTH" and "QSL Info" windows under the Edit QSO option not being filled in as below, Images attached.
lo_screen1.JPG
lo_screen1.JPG (36.77 KiB) Viewed 323 times
lo_2.JPG
lo_2.JPG (54.1 KiB) Viewed 323 times
I have included below the complete live log from I click save QSO untill it finishes auto upload to qrz and eqsl.
Hope someone can shed some light as this only started to happen in the last few days.
Thanks.
MI0JLC
Novice Class
Posts: 8
Joined: 27 Sep 2020, 07:50

Re: DBSQLITE error

Post by MI0JLC »

18:16:34.943 Info: [dje_zKXQRAHMWQXCG6SSN5C5P8ALTLF8A_ejd] : RemoteControl legacy message received
18:16:35.013 Info: [dje_zMHKFRAFDU5792C44FYSWD_ejd] : [QRZCOM] Search start on AE4S (originally AE4S)
18:16:35.383 Info: * [dje_zMHKFRAFDU5792C44FYSWD_ejd][360 ms] : [QRZCOM] Search finished on AE4S (originally AE4S)
18:16:35.653 Info: * [dje_zENBVEUMRTZDBKN6TUXB3MRRGCN6P5JKEWW_ejd] [AWARDCALLPARSER] : Award Management - Parse callsign started on AE4S
18:16:35.653 Info: * [dje_zENBVEUMRTZDBKN6TUXB3MRRGCN6P5JKEWW_ejd] [AWARDCALLPARSER] : Award Management - Parse callsign terminated on AE4S
18:16:35.833 Info: [dje_zYAFBZUSTPB65UJY3ETQ2Q433UCJA_ejd] : [VOACAP] Calculating VOACAP data for EM70ul
18:16:35.895 Info: * [dje_zYAFBZUSTPB65UJY3ETQ2Q433UCJA_ejd][61 ms] : [VOACAP] VOACAP data calculated for EM70ul
18:17:10.178 Info: [dje_zYEFDG7SLXV6B5UVPTE78WRKFNQJGEPKLKW_ejd] : {b65d59dc-97df-40cd-a43d-8cd6400e1ea8} ADIF received from UDP service
18:17:10.18 Info: [dje_zYEFDG7SLXV6B5UVPTE78WRKFNQJGEPKLKW_ejd] : JTAlert<EOH> <CALL:4>AE4S<QSO_DATE:8>20230329<QSO_DATE_OFF:8>20230329<TIME_ON:6>181630<TIME_OFF:6>181707<FREQ:9>28.182227<FREQ_RX:9>28.182227<BAND:3>10m<BAND_RX:3>10m<MODE:4>MFSK<SUBMODE:3>FT4<DXCC:3>291<COUNTRY:13>United States<CQZ:1>5<ITUZ:1>8<CONT:2>NA<RST_SENT:3>+05<RST_RCVD:3>+00<LOTW_QSL_SENT:1>R<LOTW_QSL_RCVD:1>R<EQSL_QSL_SENT:1>R<EQSL_QSL_RCVD:1>R<GRIDSQUARE:4>EM70<DISTANCE:4>6605<TX_PWR:7>1007300<LAT:11>N030 30.000<LON:11>W085 00.000<COMMENT:25>FT4 Sent: +05 Rcvd: +00<NAME:7>William<QTH:11>Tallahassee<STATE:2>FL<CNTY:7>FL,Leon<PFX:3>AE4<A_INDEX:1>5<K_INDEX:4>1.67<SFI:3>159<MY_GRIDSQUARE:6>IO64xm<MY_CQ_ZONE:1>0<MY_ITU_ZONE:1>0<OPERATOR:6>MI0JLC<STATION_CALLSIGN:6>MI0JLC<QSO_COMPLETE:1>Y <EOR>
18:17:10.185 Info: [dje_zPQSRHEAPNCVN6AJBQ5FZBHSUSMCQ_ejd] : Begin ADIF import
18:17:10.329 Info: * [dje_zGATHJAGKMRVYUZESM6ZL286RZ9UQ_ejd] [AWARDPARSER] : Award Management - Parse qso started on AE4S|29/03/2023 18:16:30|10m|FT4
18:17:11.327 Info: * [dje_zGATHJAGKMRVYUZESM6ZL286RZ9UQ_ejd] [AWARDPARSER - 998 ms] : Award Management - Parse qso terminated on AE4S|29/03/2023 18:16:30|10m|FT4
18:17:11.327 Info: * [dje_zPPF88X7ZEKNG74YYLDNGX_ejd] [AWARDPARSER - 189610 ms] : Award Management - Parse log terminated
18:17:11.327 Info: * [dje_zPQSRHEAPNCVN6AJBQ5FZBHSUSMCQ_ejd][1141 ms] : End of ADIF import
18:17:11.327 Info: [dje_zYEFDG7SLXV6B5UVPTE78WRKFNQJGEPKLKW_ejd] : {b65d59dc-97df-40cd-a43d-8cd6400e1ea8} received 1 QSO
18:17:11.335 Info: [dje_zVRT48CL8A2U23D37GUSF2_ejd] : ############### ADD QSO Callsign: AE4S Date: 29/03/2023 18:16:30 Band: 10m Mode: FT4
18:17:11.355 Info: [dje_zMHKFRAFDU5792C44FYSWD_ejd] : [QRZCOM] Search start on AE4S (originally AE4S)
18:17:11.355 Info: [dje_zMHKFRAFDU5792C44FYSWD_ejd] : [QRZCOM] AE4S FOUND IN CACHE!
18:17:11.355 Info: * [dje_zMHKFRAFDU5792C44FYSWD_ejd][10 ms] : [QRZCOM] Search finished on AE4S (originally AE4S)
18:17:11.371 Info: [dje_zVRT48CL8A2U23D37GUSF2_ejd] : QSO Callsign: AE4S Date: 29/03/2023 18:16:30 Band: 10m Mode: FT4 Saved
18:17:11.371 Info: [AdifManagement] : Begin export single QSO to ADIF string
18:17:11.371 Info: [AdifManagement] : Export QSO to ADIF file completed
18:17:11.749 Info: [dje_zYEFDG7SLXV6B5UVPTE78WRKFNQJGEPKLKW_ejd] : {b65d59dc-97df-40cd-a43d-8cd6400e1ea8} Process completed
18:17:12.035 Info: [dje_zPQSRHEAPNCVN6AJBQ5FZBHSUSMCQ_ejd] : Begin ADIF import
18:17:12.104 Info: * [dje_zGATHJAGKMRVYUZESM6ZL286RZ9UQ_ejd] [AWARDPARSER] : Award Management - Parse qso started on AE4S|29/03/2023 18:16:30|10m|FT4
18:17:13.307 Info: * [dje_zGATHJAGKMRVYUZESM6ZL286RZ9UQ_ejd] [AWARDPARSER - 1202 ms] : Award Management - Parse qso terminated on AE4S|29/03/2023 18:16:30|10m|FT4
18:17:13.307 Info: * [dje_zPPF88X7ZEKNG74YYLDNGX_ejd] [AWARDPARSER] : Award Management - Parse log terminated
18:17:13.307 Info: * [dje_zPQSRHEAPNCVN6AJBQ5FZBHSUSMCQ_ejd][1271 ms] : End of ADIF import
18:17:13.307 Info: [dje_zVRT48CL8A2U23D37GUSF2_ejd] : ############### ADD QSO Callsign: AE4S Date: 29/03/2023 18:16:30 Band: 10m Mode: FT4
18:17:13.325 Info: [dje_zMHKFRAFDU5792C44FYSWD_ejd] : [QRZCOM] Search start on AE4S (originally AE4S)
18:17:13.327 Info: [dje_zMHKFRAFDU5792C44FYSWD_ejd] : [QRZCOM] AE4S FOUND IN CACHE!
18:17:13.355 Info: * [dje_zMHKFRAFDU5792C44FYSWD_ejd][30 ms] : [QRZCOM] Search finished on AE4S (originally AE4S)


18:17:13.357 Error: [DbSqlite][dje_z6NSAYHGMRM2QZXA_ejd] : [SQLITE] InsertUpdateDatabase Command error
[EXCEPTION] constraint failed
UNIQUE constraint failed: Log.qsodate, Log.callsign, Log.band, Log.mode
18:17:13.365 Error: [DbSqlite][SaveQso] : SQLITE SaveQSO exception while saving QSO with QsoId 20230329181712036
[EXCEPTION] constraint failed
UNIQUE constraint failed: Log.qsodate, Log.callsign, Log.band, Log.mode



18:17:14.018 Info: [dje_zLM5KCTUPA4JMB4QDP6YHLJNG4NAQ_ejd] : [DELAYED SEND QSO ASYNC] Aligning QSO process started...
18:17:14.02 Info: [dje_zLM5KCTUPA4JMB4QDP6YHLJNG4NAQ_ejd] : [DELAYED SEND QSO ASYNC] Aligning QSO process completed
18:17:23.542 Info: [dje_zKXQRAHMWQXCG6SSN5C5P8ALTLF8A_ejd] : RemoteControl legacy message received
18:18:14.191 Info: [dje_zLM5KCTUPA4JMB4QDP6YHLJNG4NAQ_ejd] : [DELAYED SEND QSO ASYNC] Aligning QSO process started...
18:18:14.191 Info: [dje_zQH3JQ2NCULW2683ATPGG6VFRVWMGEUY5W2_ejd] : [EQSL UPLOAD] Uploading QSO on EQSL: AE4S|29/03/2023 18:16:30|10m|FT4
18:18:14.191 Info: [AdifManagement] : Begin export single QSO to ADIF string
18:18:14.207 Info: [AdifManagement] : Export QSO to ADIF file completed
18:18:14.729 Info: [dje_zADAZ275FYY6J5BNSX2AVQ_ejd] : [EQSL UPLOAD] Qso updated/added
18:18:14.729 Info: * [dje_zQH3JQ2NCULW2683ATPGG6VFRVWMGEUY5W2_ejd][538 ms] : [EQSL UPLOAD] ###### END ######
18:18:14.745 Info: [dje_z2H4WV9QTUU6P8K3GCN6F9RZF4XWA_ejd] : [QRZCOM UPLOAD] Uploading QSO on QRZ.COM: AE4S|29/03/2023 18:16:30|10m|FT4
18:18:14.752 Info: [AdifManagement] : Begin export single QSO to ADIF string
18:18:14.766 Info: [AdifManagement] : Export QSO to ADIF file completed
18:18:15.146 Info: [dje_z2H4WV9QTUU6P8K3GCN6F9RZF4XWA_ejd] : [QRZCOM UPLOAD] Upload successful: 'LOGID=902540325&RESULT=OK&COUNT=1' for QSO Callsign: AE4S Date: 29/03/2023 18:16:30 Band: 10m Mode: FT4
18:18:15.146 Info: [dje_z2H4WV9QTUU6P8K3GCN6F9RZF4XWA_ejd] : [QRZCOM UPLOAD] upload completed Callsign: AE4S Date: 29/03/2023 18:16:30 Band: 10m Mode: FT4
18:18:15.161 Info: * [dje_z2H4WV9QTUU6P8K3GCN6F9RZF4XWA_ejd][416 ms] : [QRZCOM UPLOAD] ###### END ######
18:18:15.161 Info: [dje_z3CFYABV6WM92PPYN3HNDGHG3BNEGP45AWSE8C6EQ_ejd] : [UPLOAD CLUBLOG QSO] Uploading QSO on CLUBLOG: AE4S|29/03/2023 18:16:30|10m|FT4
18:18:15.183 Info: [AdifManagement] : Begin export single QSO to ADIF string
18:18:15.183 Info: [AdifManagement] : Export QSO to ADIF file completed
18:18:15.183 Info: [dje_z37BXMBCLY4GPD83KQ22JD_ejd] : PostDataAsync: Posting data to https://clublog.org/realtime.php. upload information:
EMAIL=MI0JLC@DENIEDACCESS.CO.UK PASSWORD=********** CALLSIGN=MI0JLC ADIF=<CALL:4>AE4S <BAND:3>10M <MODE:4>MFSK <QSO_DATE:8>20230329 <TIME_ON:6>181630 <ADDRESS:50>422 NORTH RIDE TALLAHASSEE FL, 32303 UNITED STATES <A_INDEX:1>5 <ANT_AZ:1>0 <ANT_EL:1>0 <STATE:2>FL <COMMENT:25>FT4 SENT: +05 RCVD: +00 <CONT:2>NA <COUNTRY:13>UNITED STATES <CNTY:7>FL,LEON <CQZ:1>5 <DISTANCE:7>6605.11 <DXCC:3>291 <EMAIL:22>WFJORDAN@EARTHLINK.NET <EQSL_QSLSDATE:8>20230329 <EQSL_QSL_RCVD:1>R <EQSL_QSL_SENT:1>Y <FREQ:9>28.182227 <GRIDSQUARE:4>EM70 <ITUZ:1>8 <LOTW_QSL_RCVD:1>R <LOTW_QSL_SENT:1>R <SUBMODE:3>FT4 <MY_CITY:7>LISBURN <MY_CNTY:6>ANTRIM <MY_COUNTRY:16>NORTHERN IRELAND <MY_CQ_ZONE:2>14 <MY_DXCC:3>265 <MY_GRIDSQUARE:6>IO64XM <MY_ITU_ZONE:2>27 <MY_NAME:14>STEVE MULLIGAN <MY_POSTAL_CODE:8>BT28 1PZ <MY_RIG:12>ICOM IC-7300 <MY_STREET:11>LISNOE WALK <NAME:16>WILLIAM F JORDAN <OPERATOR:6>MI0JLC <STATION_CALLSIGN:6>MI0JLC <PROGRAMID:7>LOG4OM2 <PROGRAMVERSION:8>2.27.1.0 <QSL_RCVD:1>N <QSL_RCVD_VIA:1>E <QSL_SENT:1>N <QSL_SENT_VIA:1>E <QSL_VIA:23>EQSL, LOTW, QRZ, DIRECT <QSO_COMPLETE:1>Y <QSO_DATE_OFF:8>20230329 <QTH:11>TALLAHASSEE <RST_RCVD:3>+00 <RST_SENT:3>+05 <SWL:1>N <TIME_OFF:6>181707 <TX_PWR:7>1007300 <K_INDEX:4>1.67 <LAT:11>N030 30.000 <LON:11>W085 00.000 <MY_LAT:11>N054 31.249 <MY_LON:11>W006 02.500 <MY_ANTENNA:29>DX COMMANDER CLASSIC VERTICAL <PFX:3>AE4 <QSO_RANDOM:1>Y <SFI:3>159 <QRZCOM_QSO_UPLOAD_DATE:8>20230329 <QRZCOM_QSO_UPLOAD_STATUS:1>Y <EOR> API=2957BF2A3476CDD45D6F526D1FF65AA7DD1750C9
18:18:15.616 Info: [dje_z3CFYABV6WM92PPYN3HNDGHG3BNEGP45AWSE8C6EQ_ejd] : [UPLOAD CLUBLOG QSO] Upload successful: 'OK' message returned for QSO Callsign: AE4S Date: 29/03/2023 18:16:30 Band: 10m Mode: FT4
18:18:15.632 Info: [dje_z3CFYABV6WM92PPYN3HNDGHG3BNEGP45AWSE8C6EQ_ejd] : [UPLOAD CLUBLOG QSO] upload completed Callsign: AE4S Date: 29/03/2023 18:16:30 Band: 10m Mode: FT4
18:18:15.647 Info: * [dje_z3CFYABV6WM92PPYN3HNDGHG3BNEGP45AWSE8C6EQ_ejd][485 ms] : [UPLOAD CLUBLOG QSO] ###### END ######
18:18:15.647 Info: * [dje_zGATHJAGKMRVYUZESM6ZL286RZ9UQ_ejd] [AWARDPARSER] : Award Management - Parse qso started on AE4S|29/03/2023 18:16:30|10m|FT4
18:18:16.893 Info: * [dje_zGATHJAGKMRVYUZESM6ZL286RZ9UQ_ejd] [AWARDPARSER - 1245 ms] : Award Management - Parse qso terminated on AE4S|29/03/2023 18:16:30|10m|FT4
18:18:16.901 Info: [dje_zE62FGK32UCZBX74CVXBLZ_ejd] : QSO Callsign: AE4S Date: 29/03/2023 18:16:30 Band: 10m Mode: FT4 Saved
18:18:16.911 Info: [dje_zLM5KCTUPA4JMB4QDP6YHLJNG4NAQ_ejd] : [DELAYED SEND QSO ASYNC] Aligning QSO process completed
18:18:57.739 Info: [dje_zKXQRAHMWQXCG6SSN5C5P8ALTLF8A_ejd] : RemoteControl legacy message received
18:18:57.809 Info: [dje_zMHKFRAFDU5792C44FYSWD_ejd] : [QRZCOM] Search start on PY3JFS (originally PY3JFS)
18:18:57.831 Info: [dje_zMHKFRAFDU5792C44FYSWD_ejd] : [QRZCOM] PY3JFS FOUND IN CACHE!
18:18:57.834 Info: * [dje_zMHKFRAFDU5792C44FYSWD_ejd][23 ms] : [QRZCOM] Search finished on PY3JFS (originally PY3JFS)
18:18:57.84 Info: [dje_zUAUBTBPVYZ6CVGAL587TXN9YC9HA_ejd] : DownloadImage: Found in cache: C:\Users\steph\AppData\Roaming\Log4OM2\temp\TEMP_PY3JFS.png
18:18:57.959 Info: * [dje_zENBVEUMRTZDBKN6TUXB3MRRGCN6P5JKEWW_ejd] [AWARDCALLPARSER] : Award Management - Parse callsign started on PY3JFS
18:18:57.959 Info: * [dje_zENBVEUMRTZDBKN6TUXB3MRRGCN6P5JKEWW_ejd] [AWARDCALLPARSER] : Award Management - Parse callsign terminated on PY3JFS
18:18:58.139 Info: [dje_zYAFBZUSTPB65UJY3ETQ2Q433UCJA_ejd] : [VOACAP] Calculating VOACAP data for GG30ch
18:18:58.199 Info: * [dje_zYAFBZUSTPB65UJY3ETQ2Q433UCJA_ejd][59 ms] : [VOACAP] VOACAP data calculated for GG30ch
User avatar
G4POP
Log4OM Alpha Team
Posts: 10752
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: DBSQLITE error

Post by G4POP »

Version number

Are you using UDP or ADIF monitor or both

Which external programs are being used

"Unique constraint" means Duplicate
73 Terry G4POP
MI0JLC
Novice Class
Posts: 8
Joined: 27 Sep 2020, 07:50

Re: DBSQLITE error

Post by MI0JLC »

Verion 2.27.1.0
I have my connections like so:
log4om_settings_connections_3.JPG
log4om_settings_connections_3.JPG (110.83 KiB) Viewed 316 times
log4om_settings_connections_2.JPG
log4om_settings_connections_2.JPG (109.42 KiB) Viewed 316 times
log4om_settings_connections_1.JPG
log4om_settings_connections_1.JPG (103.07 KiB) Viewed 316 times
Not sure if I need all 3 set the same, but it was the only way I could get it to work for me. and nope.. I turned the ADIF_monitor off as you said in my last post.
I must say that I am totally lost within this new version and the UDP connections required.
thanks
User avatar
G4POP
Log4OM Alpha Team
Posts: 10752
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: DBSQLITE error

Post by G4POP »

1. Please read this https://forum.log4om.com/viewtopic.php?t=8260 then read it again

2. Use preset buttons at bottom

3. User guide

4. Are you also using adif monitor???
73 Terry G4POP
Post Reply