search

ARCH-commons / arch-ontology

ARCH i2b2 PCORnet Ontology
Other
14 stars 13 forks source link

Could not import PCORNET_MED data #57

Open gkowalski opened 7 years ago

gkowalski commented 7 years ago

Could not import PCORNET_MED data ( scilhs-ontology/Ontology/pcornet_med.txt ) into the default table within Oracle :

09:18:34 [ Row: 551, File lines: 551-551 ] ORA-12899: value too large for column "FMLH_SHRINE_ONT"."PCORNET_MED"."PCORI_CUI" (actual: 11, maximum: 8)

gkowalski commented 7 years ago

Used the create_oracle_metadata_tables.sql script

ALTER TABLE "FMLH_SHRINE_ONT"."PCORNET_MED" MODIFY ("PCORI_CUI" VARCHAR2(11))

gkowalski commented 7 years ago

12:08:54 [ Row: 34483, File lines: 34483-34483 ] ORA-12899: value too large for column "FMLH_SHRINE_ONT"."PCORNET_MED"."PCORI_CUI" (actual: 12, maximum: 11)

gkowalski commented 7 years ago

ALTER TABLE "FMLH_SHRINE_ONT"."PCORNET_MED" MODIFY ("PCORI_CUI" VARCHAR2(12))

jklann commented 7 years ago

Is this issue resolved?