Issues in event rankings after deleting session

[Logiqx]

The data integrity within the event rankings has been improving recently with all of the work by @djong1.

However, the British Speed Challenge is now showing some issues for Maciej Bukolt for which I do know the cause. This was caused by Maciej deleting a session that was being used by the event rankings.

The event rankings were previously using a GPX session containing some spurious speeds (e.g. 42 knots 2 sec) which he deleted, after re-posting the FIT file. It would appear the event rankings have not been refreshed for him after the session deletion.

[Logiqx]

This is probably the cause of the only "ghost" rankings as well:

[jhdebruin]

Check, i could do a rebuild, but on request of @djong1 i will keep it open just to check what the root cause....

[Logiqx]

Check, i could do a rebuild, but on request of @djong1 i will keep it open just to check what the root cause....

Agreed. That's for the best.

[djong1]

I have done a fix, but the transformation script had a missing selection and it might now cause some unlinked data, can you give me a help by running your script again for the active events? @Logiqx

[Logiqx]

I've re-run the reports - https://logiqx.github.io/gp3s-query/

It appears to be speed, wing and ice that are showing some data issues.

[djong1]

@jhdebruin can you give me a help, please rebuild these rankings on a per user basis for these events using the admin module. Thanks

[jhdebruin]

Yes, for sure , will do some work tonight 🤙

[jhdebruin]

Done, rebuild on all platforms . @Logiqx could you kick-off https://logiqx.github.io/gp3s-query/ again to see the results ? Thnx

[Logiqx]

Done, rebuild on all platforms . @Logiqx could you kick-off https://logiqx.github.io/gp3s-query/ again to see the results ? Thnx

Done. No errors remaining

[jhdebruin]

Thx for the fast service ... so @djong1 , all yours to close it !

[Logiqx]

I've run the reports again, still fine.