Issue 43 in snofyre: Error thrown by query specified using inactive concept IDs
sno...@googlecode.com
Owner: jeremy.r...@nhs.net
Labels: Type-Defect Priority-High
New issue 43 by jeremy.r...@nhs.net: Error thrown by query specified using
inactive concept IDs
http://code.google.com/p/snofyre/issues/detail?id=43
What steps will reproduce the problem?
1. Load the attached Query1
2. Generate 100 patients with option ADD_NEW_ALWAYS from it
3. Run Query2
What is the expected output?
A list of either 100 patients, or of no patients.
What do you see instead?
An error
Attachments:
Query1.xml 188 KB
Query2.xml 29.8 KB
srth.log 189 KB
sno...@googlecode.com
Status: Fixed
Comment #1 on issue 43 by jay.k...@biomedicalontologies.com: Error thrown
by query specified using inactive concept IDs
http://code.google.com/p/snofyre/issues/detail?id=43
Bug verified... not quite related to data generation, but to dynamic
traversal of historical relationships that Snofyre does when it encounters
inactive concepts...
[ WARN] 07 Jul 2011 18:52:14
(uk.nhs.cfh.dsp.snomed.dao.impl.SnomedConceptDatabaseDAO:653) -
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown
column 'RELATIONHIPTYPE' in 'where clause'
Fixed issue in syntax above...
Extended Snofyre's dynamic inactive replacement to handle MOVED TO and MAY
BE A statuses... so please verify attached jar works by dropping it and
overwriting the existing jar in Snofyre/bin/lib folder...
Please file a separate issue if the results are not what you expect to
find... :)
Attachments:
uk.nhs.cfh.dsp.snomed.dao-0.8.jar 18.6 KB