The Achilles scripts hang on analysis 117

Developers
1

Hello colleagues,

I’m trying to run Achilles on a dataset and have encountered an issue during execution.

Prior to running the analysis, I successfully loaded the Eunomia dataset into the database.

However, for some reason, the analysis cannot be completed — it consistently hangs on the step: “Number of Persons with at least 1 day of observation in each month” (analysis 117)

Could you please advise what I should check or troubleshoot to resolve this? There is no error, just stop calculating

IMG_816BCEC1E66C-1
IMG_816BCEC1E66C-11280×524 176 KB

A bit of context:

  1. eunomia was downloaded using:
ibrary(Eunomia)
eunomiaDetails <- Eunomia::getEunomiaConnectionDetails()
eunomiaConn <- DatabaseConnector::connect(eunomiaDetails)
irisConn <- conn
irisSchema <- "OMOPCDM54"
cdmTables <- DatabaseConnector::getTableNames(eunomiaConn)
for (tableName in cdmTables) {
message("Table: ", tableName)
df <- DatabaseConnector::querySql(eunomiaConn, paste0("SELECT * FROM ", tableName))
DatabaseConnector::insertTable(
    connection = irisConn,
    tableName = paste0(irisSchema, ".", tableName),
    data = df,
    dropTableIfExists = TRUE,
    createTable = TRUE,
    tempTable = FALSE)}
  1. use IRIS data platform, the connection is stable
  2. achilles scripts were run using:
library(Achilles)
achilles(
connectionDetails = connectionDetails,
cdmDatabaseSchema = "OMOPCDM54", 
resultsDatabaseSchema = "OMOPCDM54_RESULTS",
 vocabDatabaseSchema = "OMOPCDM54",
 cdmVersion = "5.4",
 sourceName = "IRIS local test",
 createTable = TRUE,
 smallCellCount = 5 )