Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Could not import PCORNET_MED data #57

Open
gkowalski opened this issue Mar 28, 2017 · 4 comments
Open

Could not import PCORNET_MED data #57

gkowalski opened this issue Mar 28, 2017 · 4 comments
Labels
invalid

Comments

@gkowalski
Copy link

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
Copy link
Author

Used the create_oracle_metadata_tables.sql script

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

@gkowalski
Copy link
Author

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
Copy link
Author

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

@jklann
Copy link
Contributor

jklann commented May 23, 2017

Is this issue resolved?

@jklann jklann added the invalid label Jul 17, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
invalid
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@jklann @gkowalski