OHDSI Home | Forums | Wiki | Github

Achilles error on 'Analysis 2201'


(강민규) #1

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


(Vojtech Huser) #2

I am confused. Are you saying you don’t have write access to a result schema.
Achilles requires it.


t