Hi, (apologies if this is a duplicate post – not sure if my first post sent correctly)
I am working with a an installation of cTAKES 4.0.0.1 (not the rest API). I have successfully added custom ICD10 and Read Code dictionaries by following the guidance in this video: https://www.youtube.com/watch?v=4aOnafv-NQs These appear to work as expected (analysed text is now annotated with ICD10 codes). I am now trying to add DSM-5 as an additional custom dictionary, following the same process. The UMLS steps with Metamorphosys complete as expected, but we get the following error using the cTAKES dictionary creator: 31 Mar 2023 20:45:02 INFO MrConsoParser - File Lines: 1345 Concepts: 702 Texts: 708 31 Mar 2023 20:45:02 INFO DictionaryBuilder - Performing Poor man's WSD ... 31 Mar 2023 20:45:02 INFO DictionaryBuilder - Concepts: 702 Texts: 707 31 Mar 2023 20:45:02 INFO DictionaryBuilder - Done Parsing Concepts 31 Mar 2023 20:45:02 INFO JdbcUtil - Connecting to jdbc:hsqldb:file:/usr/local/apache-ctakes-4.0.0.1/resources/org/apache/ctakes/dictionary/lookup/fast/dsm5/dsm5 as SA 31 Mar 2023 20:45:03 INFO ENGINE - Checkpoint start 31 Mar 2023 20:45:03 INFO ENGINE - checkpointClose start 31 Mar 2023 20:45:03 INFO ENGINE - checkpointClose synched 31 Mar 2023 20:45:03 INFO ENGINE - checkpointClose script done 31 Mar 2023 20:45:03 INFO ENGINE - checkpointClose end 31 Mar 2023 20:45:03 INFO ENGINE - Checkpoint end - txts: 1 31 Mar 2023 20:45:03 ERROR RareWordDbWriter - user lacks privilege or object not found: DSM in statement [insert into dsm_5 (CUI,DSM-5) values (?,?)] I definitely have write permissions to the fast resources folder ((i) running with sudo, ii) same process with ICD10 works without issues) and wondered if this is a syntax error caused by the hyphen character in DSM-5 as the error is saying “DSM” not found in statement. Any ideas on how to resolve this? After trying to add DSM-5, it then no longer possible to add further custom dictionaries (attempting to add DSM-5 seems to fundamentally break something). Trying to add another copy of ICD10 (previously added successfully) then fails with this error: 31 Mar 2023 22:24:29 INFO JdbcUtil - Connecting to jdbc:hsqldb:file:/usr/local/apache-ctakes-4.0.0.1/resources/org/apache/ctakes/dictionary/lookup/fast/icd10/icd10 as SA 31 Mar 2023 22:24:29 ERROR HsqlUtil - object name already exists: CUI_TERMS in statement [CREATE MEMORY TABLE CUI_TERMS(CUI BIGINT,RINDEX INTEGER,TCOUNT INTEGER,TEXT VARCHAR(255),RWORD VARCHAR(48))] BW Kamilla
