OHDSI Home | Forums | Wiki | Github

Please help - Achilles Drug Era not exported

Developers
#1

Hi, I have had success running Achilles and viewing the results in AchillesWeb with the exception of one set of report - the Drug Era reports. These reports are the only ones that do not get exported to JSON, even though no error is produced and the Achilles tables have data for many of the reports 900 - 920. Also, the drug exposure reports look great. Does anyone know how I can figure out the issue?

Here is some further things I tested or looked at:

  • all of my drug era drug_concept_type ids are 38000181 (Drug era - 0 days persistence window). We think that this makes sense for our ETL for reasons I can explain if needed.

  • the only possibly unusual thing I see is in the _dist reports (e.g., 907) there are some rows with negative values in the P10_VALUE column.

  • in sqlDrugEraTreemap.sql (called from generateDrugEraTreemap when exportToJson is called) I see a join with ACHILLES_results where analysis_id = 900 and ACHILLES_results_dist where analysis_id = 907. I checked and found cases where the join condition should work.

#2

Are you looking at the directory in the export path to confirm there are no files there or do the reports not load in the achilles web interface?

#3

Hi Frank,

I see no json data exported to the drugeras/ folder from exportToJson.

Thanks,
-R

t