I have been trying to run Achilles but despite numerous attempts, it keeps failing after running the analytics. I am using Windows integrated authentication. I can see that a table called ACHILLES_ANALYSIS is created in the database, but there is no achilles_results table. This is the error which I see in the error report file:
DBMS:
sql server
Error:
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object “omop_results.achilles_results” because it does not exist or you do not have permissions.
SQL:
create index idx_ar_aid on omop_results.achilles_results (analysis_id)
R version:
R version 4.4.3 (2025-02-28 ucrt)
Platform:
x86_64-w64-mingw32
Attached base packages:
- stats
- graphics
- grDevices
- utils
- datasets
- methods
- base
Other attached packages:
- Achilles (1.7.2)
- DatabaseConnector (6.4.0)
- here (1.0.1)
- RJDBC (0.2-10)
- DBI (1.2.3)
- rJava (1.0-11)
- remotes (2.5.0)