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)
조언 부탁드립니다.