Running Achilles on the OMOP MIMIC-IV synthetic dataset , I get a single error (PSQLException: division by zero) during the creation of one temp table (s_tmpach_2004). Problem is, the SQL command causing the error is 1300 lines long, so I’m not sure how to go about debugging.
Frank
February 1, 2023, 3:13pm
2
I’ve opened an issue on the Achilles GitHub here to track this and we will try and take a look soon.
opened 03:13PM - 01 Feb 23 UTC
https://forums.ohdsi.org/t/achilles-division-by-zero-error/18177
Thanks, @Frank ! It could be an issue with how I built the datasets, but I have run into similar errors with a few different builds:
I’m following the Getting Started with Achilles Guide with the MIMIC-IV demo data . However, I get the following error from Achilles.achilles:
Connecting using PostgreSQL driver
Error in read.table(file = file, header = header, sep = sep, quote = quote, :
no lines available in input
Calls: achilles -> getAnalysisDetails -> read.csv -> read.table
In addition: Warning message:
In file(file, "rt") :
file("") only supports open = "w+" and open = "w+b": using the former
Execution halted
I cou…