snomed-database-loader

snomed-database-loader copied to clipboard

[MySQL] ERROR 1064 - while running `snomed_load_mysql` in mysql-loader-with-optimized-views

7

Hi, First of all thanks for the scripts in this repo! I have some problems running the scripts for the [MySQL with optimized views](https://github.com/IHTSDO/snomed-database-loader/tree/master/mysql-loader-with-optimized-views). After successfully running `sudo ./bash/snomed_config_mysql` the...

axelv

NEO4J CYPHER EXECUTION failes

1

CYPHER EXECUTION fails loading the INT release of 20210731; there are 7 DB failures. Any ideas on how to solve these? step:[CYPHER_EXECUTION],result:[FAILED (STATUS 7)],command:[python /Users/arabella/Downloads/SNOMED-CT-Database-master/NEO4J//snomed_g_neo4j_tools.py run_cypher build.cypher --verbose --neopw SCT2107],status/expected:7/0,duration:0:02:47.579488,output:[],error:[],cmd_start:[2022-01-25...

adhave

anydbm is not available in python-3 There is no option for Windows users to fallback to another dbm. Falling back to python-2.7 in Windows with py2neo 3.1.2 breaks the entire...

rolance

Could you please give some idea on how to access SnomedCT_RF2Release_INT_xxxx.zip file

1

tyuanhang

count of RF2 ids: 481176 count of FSNs in RF2: 481176 Total RF2 elements: 481176, NEW: 481176, CHANGE: 0, NO CHANGE: 0 0000_make_concept_csvs : 0:00:10.400222 0001_read_RF2_description : 0:00:04.058203 0002_read_RF2_concept :...

erichills

Issue of "sequence did not exist, primed" in SNOMED_G tool

1

Hello, I am trying SNOMED_G tool, since I don't have a strong IT background and encountered the issue as below: I ran this command: python ./prog/snomed_g_graphdb_build_tools.py db_build --action create --rf2...

aushikun

MySQL Datetime no longer accept '0000-00-00 00:00:00' as default value

2

11:15:15 CREATE TABLE `sct2_concept` ( `id` BIGINT NOT NULL DEFAULT 0, `effectiveTime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `active` TINYINT NOT NULL DEFAULT 0, `moduleId` BIGINT NOT NULL DEFAULT 0,...

philipskokoh

ERROR 1148

4

Need you help! When i executed this query i got; ERROR 1148: The used command is not allowed with this MySQL version. I tried changing Infile settings on client and...

harshsharma09

POSTGRESQL Foreign Keys

8

The POSTGRESQL script creates all the tables and populates them all right, but no foreign keys are created. Is this intended? how can I fix this. Another issue I have...

fariasfrancisco

Postgres loader does not allow different module identifiers (e.g., US1000124)

2

In [the README](https://github.com/IHTSDO/snomed-database-loader/blob/master/PostgreSQL/README.md) it says > Note that the scripted installation will now support loading other Editions. The script asks for a module identifier, which is INT by default, for...

boxydog