OHDSI Home | Forums | Wiki | Github

Missing concept about dm+d in new v5 vocab download


(Micheal ) #1

Hello OHDSI,

Last week, I troubleshooted the error with no response query for condition_era myself.

and I got this new error code while importing the constraints.

ERROR: insert or update on table “concept” violates foreign key constraint “fpk_concept_vocabulary”
DETAIL: Key (vocabulary_id)=(dm+d) is not present in table “vocabulary”.
********** Error **********

ERROR: insert or update on table “concept” violates foreign key constraint “fpk_concept_vocabulary”
SQL state: 23503
Detail: Key (vocabulary_id)=(dm+d) is not present in table “vocabulary”.

(dm+d)? Dictionary of medicines and devices ? new vocabulary?
Is that in new V6 vocab downolad? and please provide me how to solve it. Thank you


(Christian Reich) #2

@MichealJeong:

Looks like you downloaded a new vocabulary, and are trying to load the CONCEPT table before loading the VOCABULARY table. And, apparently, you chose “dm+d” when you requested your download.

Not sure you need that. It’s a drug repository in the UK. Are you in the UK?


(Micheal ) #3

Yes, you’re right @Christian_Reich
I chose all the vocabularies included dm+d, and downloaded new one three weeks ago.
and not sure I loaded CONCEPT table before loading the VOCABULARY table.
Ah! I might have to download without choosing dm+d from Athena and reload it.
Thank you
Btw, Is that importhat to load CONCEPT table before loading the VOCABULARY table as step by step?


t