Also, in the resulting list of duplicate names, I found three of the above. However, I did not find HEPATOSPLENOMEGALY. I did, however, find duplicates of one of the synonyms of it: HSM.
Jeremy Keiper OpenMRS Core Developer AMPATH / IU-Kenya Support On Wed, Sep 21, 2011 at 2:26 PM, Jeremy Keiper <[email protected]> wrote: > I just ran the following query and found 37 duplicated unique names (that > have not been voided) for concepts that have not been retired: > > select count(cn.concept_id) as total, cn.name, cn.locale from concept_name > cn inner join concept c on c.concept_id=cn.concept_id where c.retired=0 and > cn.voided=0 group by name, locale having total > 1 order by total desc; > > Is this possibly what is causing my problems with Metadata Sharing Module, > and therefore the API? By the way, I'm running 1.8.2. > > Jeremy Keiper > OpenMRS Core Developer > AMPATH / IU-Kenya Support > > > On Wed, Sep 21, 2011 at 1:52 PM, Jeremy Keiper <[email protected]> wrote: > >> When creating an export package in Metadata Sharing Module from a >> selection of eight forms, I get the following error: >> >> Concept [a898a552-1350-11df-a1f1-0026b9348838] 'DERMATOPHYTOSIS' is a >> duplicate name in locale 'en' >> Concept [a89565ea-1350-11df-a1f1-0026b9348838] 'DECREASED SENSATION' is a >> duplicate name in locale 'en' >> Concept [a8a37202-1350-11df-a1f1-0026b9348838] 'HEPATOSPLENOMEGALY' is a >> duplicate name in locale 'en' >> Concept [a890c21a-1350-11df-a1f1-0026b9348838] 'SULFADOXINE AND >> PYRIMETHAMINE' is a duplicate name in locale 'en' >> >> >> When we first saw this error, we investigated the forms and determined >> that three of the related concepts were incorrectly referenced in forms and >> that two concepts referencing HSM did not have preferred names. We made >> these changes, but are still getting these errors. Is there an API >> restriction that is causing this validation problem? Is there something I >> can do in SQL to test conditions that will cause this problem, so I can >> rectify them? >> >> Jeremy Keiper >> OpenMRS Core Developer >> AMPATH / IU-Kenya Support >> > > _________________________________________ To unsubscribe from OpenMRS Developers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-devel-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-devel-l]
