Not sure if this has been sorted out before. Apologies if it has.
I did some searching for the error patterns in Github repo and here.
High level I’m not sure what is causing the error when running Achilles::exportToAres().
We use Snowflake as a backing cloud data store.
I’ve put all the context, R code, and information in this Github issue Snowflake error on Achilles::exportToAres - "Error in aggregate.data.frame(as.data.frame(x), ...) : no rows to aggregate" · Issue #775 · OHDSI/Achilles · GitHub
Posting here in case someone recognizes the error and has context they can lend to help me be able to get past the error and export the data properly for Ares web server to load/display.
Thanks in advance
Heidi Schmidt
hschmidt@mgb.org
Error:
Error in aggregate.data.frame(as.data.frame(x), …) : **
** no rows to aggregate
The traceback:
traceback()
5: stop(“no rows to aggregate”)
4: aggregate.data.frame(as.data.frame(x), …)
3: aggregate.default(totalRecordsData$records, by = list(domain = totalRecordsData$domain),
FUN = sum)
2: aggregate(totalRecordsData$records, by = list(domain = totalRecordsData$domain),
FUN = sum)
1: Achilles::exportToAres(connectionDetails = connectionDetails,
cdmDatabaseSchema = cdmDatabaseSchema, resultsDatabaseSchema = cdmDatabaseSchema,
vocabDatabaseSchema = cdmDatabaseSchema, outputPath = aresDataRoot)