OHDSI Home | Forums | Wiki | Github

Achilles_result 파일은 어느 순간에 생성이 되는건가요?


(박성준) #1

postgresql로 작업중이고 cdm 5.2버전 아킬레스 1.6.7버전 사용중입니다.
R에서 achilles 명령어를
achilles(connectionDetails, cdmDatabaseSchema = “cdm”,resultsDatabaseSchema=“webapi”, vocabDatabaseSchema = “cdm”,sourceName = “My Cdm”, cdmVersion = “5”, runCostAnalysis = F)
아래와 같이 사용하고 돌렸는데 2200번까지 analysis가 되고 마지막에 이런 에러와 함께 종료가 됩니다.


(Error: Error executing SQL:
org.postgresql.util.PSQLException: ERROR: relation “s_tmpach_8” does not exist
Position: 4411
An error report has been created at /home/ubuntu/errorReportSql.txt
)
Done. Achilles results can now be found in schema webapi
Connecting using PostgreSQL driver
| | 0%에러: Error executing SQL:
org.postgresql.util.PSQLException: ERROR: relation “webapi_hansan.achilles_results” does not exist
An error report has been created at /home/ubuntu/errorReportSql.txt

errorreportsql 파일은 아래와 같습니다.

DBMS:
postgresql

Error:
org.postgresql.util.PSQLException: ERROR: relation “webapi_hansang.achilles_results” does not exist

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

R version:
R version 3.6.3 (2020-02-29)

Platform:
x86_64-pc-linux-gnu

Attached base packages:

  • stats
  • graphics
  • grDevices
  • utils
  • datasets
  • methods
  • base

Other attached packages:

  • Achilles (1.6.7)
  • DatabaseConnector (3.0.0)

조언 부탁드립니다.


t