search

chop-dbhi / omop_harvest

OMOP CDMV4 data model with OSIM2 data in Harvest
https://eig.research.chop.edu/omop/
Other
5 stars 3 forks source link

Vocabulary upload error #17

Closed mgkahn closed 9 years ago

mgkahn commented 9 years ago

omop=# \i VocabV4_data_load.psql vocabulary concept relationship concept_synonym source_to_concept_map concept_relationship concept_ancestor drug_strength psql:VocabV4_data_load.psql:16: ERROR: duplicate key value violates unique constraint "drug_strength_pkey" DETAIL: Key (drug_concept_id)=(19042893) already exists. CONTEXT: COPY drug_strength, line 96 drug_approval

gracebrownecodes commented 9 years ago

This is an error I know about, caused by misinterpretation of the drug_strength table and the resulting erroneous addition of a uniqueness constraint. Best-laid plans of mice and men, I guess. Will be resolved by #18, closing.