OHDSI Home | Forums | Wiki | Github

Error message "create index idx_ar_aid on results.achilles_results (analysis_id)" when executing Achilles

Implementers
#1

Hello,

when running Achilles I receive the following error message:

DBMS:
postgresql

Error:
org.postgresql.util.PSQLException: ERROR: relation “idx_ar_aid” already exists

SQL:
create index idx_ar_aid on results_ibd.achilles_results (analysis_id)

R version:
R version 4.2.1 (2022-06-23)

Platform:
x86_64-pc-linux-gnu

Indeed, the index exists.

How can I solve this issue?

Thank you very much

#2

I cirumvented the problem by simply using a new results schema

t