I get two distinct entries, the same result as if I try: select concept_id from concept_name where name = 'DERMATOPHYTOSIS';
In one case (HEPATOSPLENOMEGALY), one of the concepts is retired but neither name is voided. In the other cases, no names are voided and none of the connected concepts are voided. So, how do we resolve this? I assume the only way is to rename one of the involved concepts? Jeremy Keiper OpenMRS Core Developer AMPATH / IU-Kenya Support On Wed, Sep 21, 2011 at 2:28 PM, Wyclif Luyima <[email protected]> wrote: > The best way to find the root cause is to go to the concept edit page and > try saving any of those concepts, if they get saved without that error, then > they are fine and implies there is something wrong happening in the module > which causes it to re-export a concept otherwise get rid of the duplicate > names. > > What resultset do you get when you execute the following sql query? > > select c.concept_id from concept c, concept_name cn where > c.concept_id=cn.concept_id and cn.name = 'DERMATOPHYTOSIS'; > > You can test it for all the concepts with issues. > > Wyclif > > 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 >> ------------------------------ >> Click here to >> unsubscribe<[email protected]?body=SIGNOFF%20openmrs-devel-l>from >> OpenMRS Developers' mailing list > > > ------------------------------ > Click here to > unsubscribe<[email protected]?body=SIGNOFF%20openmrs-devel-l>from > OpenMRS Developers' mailing list _________________________________________ 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]
