I am a Data Intern with the Colorado State University School of Veterinary Medicine. We have been working on wrangling our veterinary EHR data into the OMOP CDM. While trying to implement Achilles, we ran into an issue where it would not populate the tables in our Postgres database. It seems to be running most (if not all) of the analyses without issue, but it fails at the 50% mark in the “merging scratch Achilles tables” step.
Here is a screenshot:
While trying to resolve this problem, my team discovered this GitHub issue discussing the topic. However, the resolution proposed by the original author still seems vague to us. We are unsure why our default collations would be uncooperative with Achilles like the GitHub issue mentioned - our database is almost completely vanilla Postgres and OMOP. We are hoping somebody on these forums could provide any clues for us. We would appreciate it very much!