I was able to solve this problem by following this post ERROR: relation "results.achilles_results" does not exist - #4 by liyang
I also realised that running DataQualityDashboard before Achilles helps a lot because DQD gives a more detailed error report than Achilles. Use the error logs to correct mistakes made when transforming the source data to the OMOP CDM.