SOTA Database upload error for S2S ?

Hi everyone,

so I’ve done a bulk upload of basically all my activations made before 2024-05

after uploading and when planning possible new activations I have noticed a S2S contact that had a wrong date for the summit i chased (“shifted” to the next activation date)
after further looking into it I discoverd that some(how) apparently s2s contacs have wrong dates in the database though beeing shown correctly if i click edit.

as an example - here is one of the (2) dates I have found this error at (already):

Logview (S2S only):

Editview:

Adifmaster of the uploaded adif file:

If I didnt miss anything, the edit view of the uploaded data and the actual file i have in my PC have consistent (and correct) data and only the final/public log has the date-error.

is there anything i am not aware of I could try to solve this problem or should i just delete and upload again? (maybe separating to individuall activations?)

Whilst I have a look, I have disabled your account. I’ll enable it in a few minutes.

sure thing, thanks for looking into it!

The account is active again. Don’t log anything until you get the OK. Please send me the file you uploaded to andy.mm0fmf@gmail.com

1 Like

Roger that, just sent the mail.

Was this an FLE upload by chance?

Looks like it was an ADIF @VK3ARR :wink:

1 Like

Reading was never my strong point.

1 Like

I’ll pass my findings on in the other place.

yep - transcribed my handwriting in an access database, exported as csv and then imported in adifmaster to save as adif

1 Like

Alan, sorry for the delay responding.

We use a pair of servers and a load balancer to split the DB reading and writing. All apps accessing the DB use the servers and the load balance spreads the load. If one server fails, we still have the other and the load balancer only sends work to the working server. What doesn’t work is when one server runs out of disk space. It can’t work properly but appears to be working from the load balancer’s view. Then it’s random which server anything goes to. The log rotation code was broken so one server was out of disk space. If your uploads where handled by this server they would appear to work but would be wrong.

Andrew cleaned up the disk space and apart from an typo error in the ADI file, he could not make it fail. When I tried I split the ADI into 3 CSVs and it worked for me. I was probably hitting the good server.

You need to do 2 things.

  1. Delete the upload you made with the Manage Upload page.
  2. Fix the typo

It says:

<QSO_DATE:8>20240510 <TIME_ON:4>1239 <TIME_OFF:4>1239 <CALL:7>EA2WX/p <FREQ:5>0.000 <BAND:3>20m <MODE:3>SSB <OPERATOR:6>OE5LAE <STATION_CALLSIGN:8>OE5LAE/p <RST_SENT:2>57 <RST_RCVD:2>56 <MY_SOTA_REF:9>OE/ST-398 <SOTA_REF:9>EA/BI-039 <EOR>

and should say:

<QSO_DATE:8>20240510 <TIME_ON:4>1239 <TIME_OFF:4>1239 <CALL:7>EA2WX/p <FREQ:5>0.000 <BAND:3>20m <MODE:3>SSB <OPERATOR:6>OE5LAE <STATION_CALLSIGN:8>OE5LAE/p <RST_SENT:2>57 <RST_RCVD:2>56 <MY_SOTA_REF:9>OE/ST-398 <SOTA_REF:10>EA2/BI-039 <EOR>

That should fix your problems.

1 Like

no worries,I was/am busy studying anyway^^

anyways,Thanks for sorting it!
Just to confirm, i need to:

  • delete the bulk upload
  • correct this one error
  • reupload
  • done (i.e no splitting up of the file etc…)
1 Like

Yes, those 3 items, no need to split.

1 Like

just finished it - works as it is expected to now!

1 Like