Dear,
I’m trying to install atlas and Achilles by using demo data ‘synpuf5pct’.
However, I received error to run achilles on Rstudio and I cannot create acilles.results table on result schema…
Please help me… ㅠㅠ
From Mingyu Kang
*** my R code
connectionDetails<- createConnectionDetails(
dbms=“postgresql”,
server=“localhost/OHDSI”,
user=“ohdsi_admin_user”,
password=‘admin1’,
port=“5432”)
achilles(connectionDetails,
cdmDatabaseSchema = “synpuf5”,
resultsDatabaseSchema=“webapi”,
vocabDatabaseSchema = “synpuf5”,
numThreads = 1,
sourceName = “Synpuf_5pct”,
cdmVersion = “5”,
runHeel = TRUE)
**error message
Executing SQL took 0.00645 secs
[Main Analysis] [COMPLETE] 2201 (0.025464 secs)
Merging scratch Achilles tables
|================================ | 50%Error: Error executing SQL:
org.postgresql.util.PSQLException: ERROR: relation “s_tmpach_424” does not exist
Position: 30395
An error report has been created at C:/Windows/system32/errorReport.txt
*errorReport.txt file
DBMS:
postgresql
Error:
org.postgresql.util.PSQLException: ERROR: relation “s_tmpach_424” does not exist
Position: 30395
SQL:
–HINT DISTRIBUTE_ON_KEY(analysis_id)
…
s_tmpach_424 union all select 2000424 as analysis_id, 'ERROR: check log files' as stratum_1, NULL as stratum_2, NULL as stratum_3, NULL as stratum_4, NULL as stratum_5, 6 as count_value
union all