Achilles: division by zero error

[Ashlin_Harris]

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 (Frank DeFalco)]

I’ve opened an issue on the Achilles GitHub here to track this and we will try and take a look soon.

Achilles: division by zero error

[Ashlin_Harris]

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:

Error running Achilles on MIMIC IV: "no lines available in input"

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…