As part of my process for performing Totara upgrades, I export two site-wide course completion reports: one before the upgrade and one after, as a cusory check to see if any data was changed or lost during the upgrade. 99% of the time, after comparing the reports, they're identical. However, I've carried out this same step during a recent upgrade test and for some reason the post-upgrade report is missing mutliple course completions from multiple users.
I'm not sure how this is possible. There were no errors reported during this (CLI) MySQL database collation and upgrade (Totara 12.35 > 12.49), but clearly something has changed or been removed.
I'd appreciate any suggestions for further testing or things to look into. My knowledge of the inner workings of Totara is limited, so I'm at a bit of a loss for ideas now.
Thanks