I’m currently trying to setup the OGDSI on my local system and using the steps mentioned in the link. But when I use
psql omop --user user -f ohdsi.sql
I am getting the database error
ERROR: relation "results.achilles_analysis" does not exist at character 95
2022-01-18 21:15:11.524 IST [87] STATEMENT: (SELECT
aa1.analysis_name AS attribute_name,
ar1.stratum_1 AS attribute_value
FROM results.ACHILLES_analysis aa1
INNER JOIN
results.achilles_results ar1
ON aa1.analysis_id = ar1.analysis_id
WHERE aa1.analysis_id = 0
UNION
SELECT
aa1.analysis_name AS attribute_name,
cast(ar1.count_value AS VARCHAR) AS attribute_value
FROM results.ACHILLES_analysis aa1
INNER JOIN
results.achilles_results ar1
ON aa1.analysis_id = ar1.analysis_id
WHERE aa1.analysis_id = 1
)
ORDER BY attribute_name DESC
Can anyone tell me where I’m doing this wrong ?