How to troubleshoot inaccurate completion rate data for online course videos?

Once, while calculating course completion rates on an online education platform, the problem didn't seem big at first: operations noticed a sudden drop in completion rates, but students reported they had finished the videos, yet certificates couldn't be generated. The explanations from the few people on-site all sounded reasonable, but they didn't add up when put together. I first asked everyone…