Rafal was right - we were missing the drug in the database after a previous SQL import of concepts... which is why SQL dumps are not a great way to move concepts around and why we really appreciate the work you guys are doing on MDS
On 1 March 2012 20:48, Dave Thomas <[email protected]> wrote: > Why wouldn't the drug just be added to the metadata sharing package when > referenced by answer_drug? > > I don't see why you'd ever want to import/export a concept with an > answer_drug where you wouldn't want the package to include the drug. > > (rolling up sleeves to look at metadatasharing code) > > d > > > On Thu, Mar 1, 2012 at 4:35 AM, Rafal Korytkowski <[email protected]>wrote: > >> It's possible that you may have imported it. Normally MySQL dumps are >> imported with foreign_key_checks=OFF. >> >> I'd assume this drug is in the concept_answer table so execute this query: >> >> select * from concept_answer where answer_drug = 142; >> >> -Rafal >> >> >> On 1 March 2012 13:10, Rowan Seymour <[email protected]> wrote: >> >>> There is no drug 142. Am looking in the database to see where we could >>> have a FK constraint violation. It's InnoDB tables >>> with foreign_key_checks=ON so I don't see how it's possible. What do you >>> think is referencing that drug? >>> >>> I'll create a ticket for the other exception. >>> >>> Thanks >>> >>> >>> On 1 March 2012 13:15, Rafal Korytkowski <[email protected]> wrote: >>> >>>> Hi, >>>> >>>> The export fails since you've got a FK constraint violation in your db: >>>> *No row with the given identifier exists: [org.openmrs.Drug#142]. *Make >>>> sure that a drug with id 142 exists or don't reference it in your concepts. >>>> >>>> Regarding the import it's trying to save concepts in the wrong order. >>>> Can you please create a ticket and attach your package if it's possible or >>>> else I'll ask you to help me inspect the xml further. >>>> >>>> -Rafal >>>> >>>> On 1 March 2012 11:29, Rowan Seymour <[email protected]> wrote: >>>> >>>>> Another exception - this time trying to export all concepts from the >>>>> same server: >>>>> >>>>> *Caused by: org.openmrs.module.metadatasharing.task.TaskException: >>>>> Export failed* >>>>> * at >>>>> org.openmrs.module.metadatasharing.task.impl.ExportPackageTask.execute(ExportPackageTask.java:125) >>>>> * >>>>> * at >>>>> org.openmrs.module.metadatasharing.api.impl.MetadataSharingServiceImpl.executeTask(MetadataSharingServiceImpl.java:198) >>>>> * >>>>> * ...* >>>>> *Caused by: org.hibernate.ObjectNotFoundException: No row with the >>>>> given identifier exists: [org.openmrs.Drug#142]* >>>>> * at >>>>> org.hibernate.impl.SessionFactoryImpl$1.handleEntityNotFound(SessionFactoryImpl.java:377) >>>>> * >>>>> * at >>>>> org.hibernate.proxy.AbstractLazyInitializer.checkTargetState(AbstractLazyInitializer.java:79) >>>>> * >>>>> * at >>>>> org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:68) >>>>> * >>>>> * at >>>>> org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:111) >>>>> * >>>>> * at >>>>> org.openmrs.module.metadatasharing.visitor.impl.OpenmrsObjectVisitor$1.visit(OpenmrsObjectVisitor.java:89) >>>>> * >>>>> * at >>>>> com.thoughtworks.xstream.converters.reflection.PureJavaReflectionProvider.visitSerializableFields(PureJavaReflectionProvider.java:129) >>>>> * >>>>> * at >>>>> org.openmrs.module.metadatasharing.visitor.impl.OpenmrsObjectVisitor.visitFields(OpenmrsObjectVisitor.java:83) >>>>> * >>>>> * at >>>>> org.openmrs.module.metadatasharing.task.impl.ExportPackageTask.resolveRelatedItems(ExportPackageTask.java:176) >>>>> * >>>>> * at >>>>> org.openmrs.module.metadatasharing.task.impl.ExportPackageTask.access$2(ExportPackageTask.java:175) >>>>> * >>>>> * at >>>>> org.openmrs.module.metadatasharing.task.impl.ExportPackageTask$1.visitMetadata(ExportPackageTask.java:202) >>>>> * >>>>> * at >>>>> org.openmrs.module.metadatasharing.task.impl.ExportPackageTask$1.visit(ExportPackageTask.java:184) >>>>> * >>>>> * at >>>>> org.openmrs.module.metadatasharing.visitor.impl.OpenmrsObjectVisitor$1.visit(OpenmrsObjectVisitor.java:96) >>>>> * >>>>> * at >>>>> com.thoughtworks.xstream.converters.reflection.PureJavaReflectionProvider.visitSerializableFields(PureJavaReflectionProvider.java:129) >>>>> * >>>>> * at >>>>> org.openmrs.module.metadatasharing.visitor.impl.OpenmrsObjectVisitor.visitFields(OpenmrsObjectVisitor.java:83) >>>>> * >>>>> * at >>>>> org.openmrs.module.metadatasharing.task.impl.ExportPackageTask.resolveRelatedItems(ExportPackageTask.java:176) >>>>> * >>>>> * at >>>>> org.openmrs.module.metadatasharing.task.impl.ExportPackageTask.exportSubpackage(ExportPackageTask.java:148) >>>>> * >>>>> * at >>>>> org.openmrs.module.metadatasharing.task.impl.ExportPackageTask.execute(ExportPackageTask.java:98) >>>>> * >>>>> * ... 44 more* >>>>> >>>>> >>>>> It also outputted about 15MB to my catalina.out log, most of which >>>>> appears to be repetition of this warning: >>>>> >>>>> *WARN - StringLocaleConverter.getDecimalFormat(281) |2012-03-01 >>>>> 11:54:50,961| No pattern provided, using default.* >>>>> >>>>> >>>>> On 1 March 2012 12:13, Rowan Seymour <[email protected]> wrote: >>>>> >>>>>> Am trying to import a package with MDS 1.0.2 and getting the >>>>>> exception below. The package was also made with 1.0.2 >>>>>> * >>>>>> * >>>>>> *Caused by: org.openmrs.module.metadatasharing.task.TaskException: >>>>>> Import failed* >>>>>> *...* >>>>>> *Caused by: org.openmrs.api.db.DAOException: Error saving >>>>>> org.openmrs.Concept [e44dae58-fec8-4567-bd44-e989232af0e7]* >>>>>> *...* >>>>>> *Caused by: org.openmrs.api.APIException: Cannot save 7073. Failed >>>>>> with the following exception:* >>>>>> *java.lang.reflect.InvocationTargetException* >>>>>> * >>>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>>>>> at >>>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >>>>>> at >>>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >>>>>> at java.lang.reflect.Method.invoke(Method.java:597) >>>>>> at >>>>>> org.openmrs.module.metadatasharing.reflection.OpenmrsClassScanner.invokeServiceSaveItem(OpenmrsClassScanner.java:254) >>>>>> at >>>>>> org.openmrs.module.metadatasharing.reflection.OpenmrsClassScanner.serviceSaveItem(OpenmrsClassScanner.java:174) >>>>>> at >>>>>> org.openmrs.module.metadatasharing.handler.impl.OpenmrsObjectHandler.saveItem(OpenmrsObjectHandler.java:107) >>>>>> at >>>>>> org.openmrs.module.metadatasharing.handler.impl.OpenmrsObjectHandler.saveItem(OpenmrsObjectHandler.java:1) >>>>>> at >>>>>> org.openmrs.module.metadatasharing.handler.Handler.saveItem(Handler.java:38) >>>>>> at >>>>>> org.openmrs.module.metadatasharing.task.impl.ImportPackageTask.saveItem(ImportPackageTask.java:284) >>>>>> at >>>>>> org.openmrs.module.metadatasharing.task.impl.ImportPackageTask.saveItem(ImportPackageTask.java:278) >>>>>> at >>>>>> org.openmrs.module.metadatasharing.task.impl.ImportPackageTask.saveItem(ImportPackageTask.java:278) >>>>>> at >>>>>> org.openmrs.module.metadatasharing.task.impl.ImportPackageTask.saveItem(ImportPackageTask.java:278) >>>>>> at >>>>>> org.openmrs.module.metadatasharing.task.impl.ImportPackageTask.saveItem(ImportPackageTask.java:278) >>>>>> at >>>>>> org.openmrs.module.metadatasharing.task.impl.ImportPackageTask.importItems(ImportPackageTask.java:199) >>>>>> at >>>>>> org.openmrs.module.metadatasharing.task.impl.ImportPackageTask.execute(ImportPackageTask.java:85) >>>>>> at >>>>>> org.openmrs.module.metadatasharing.api.impl.MetadataSharingServiceImpl.executeTask(MetadataSharingServiceImpl.java:198) >>>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>>>>> * >>>>>> *...* >>>>>> *Caused by: org.hibernate.PropertyValueException: not-null property >>>>>> references a null or transient value: >>>>>> org.openmrs.ConceptAnswer.answerConcept* >>>>>> * >>>>>> at >>>>>> org.hibernate.engine.Nullability.checkNullability(Nullability.java:72) >>>>>> at >>>>>> org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:290) >>>>>> * >>>>>> >>>>>> I assume "*Cannot save 7073*" refers to the item with id=7073 which >>>>>> would be this ConceptMap in the metadata.xml: >>>>>> >>>>>> <org.openmrs.ConceptMap id="*7073*" >>>>>> uuid="75591ABBBBBBBBBBBBBBBBBBBBBBBBBBBBBB"> >>>>>> <conceptMapId>13,329</conceptMapId> >>>>>> <concept reference="7046"/> >>>>>> <source reference="671"/> >>>>>> <sourceCode>283025007</sourceCode> >>>>>> <comment>Map Type: 1</comment> >>>>>> <creator/> >>>>>> <dateCreated id="7074">2010-04-25 >>>>>> 11:29:41</dateCreated> >>>>>> </org.openmrs.ConceptMap> >>>>>> >>>>>> And the concept with that UUID is: >>>>>> >>>>>> <org.openmrs.ConceptAnswer id="10576" >>>>>> uuid="575e736e-347a-4487-aced-10c7cdd9ec5f"> >>>>>> <conceptAnswerId>6,850</conceptAnswerId> >>>>>> <concept reference="5900"/> >>>>>> <answerConcept id="10577" >>>>>> resolves-to="org.openmrs.Concept" uuid="* >>>>>> e44dae58-fec8-4567-bd44-e989232af0e7*"> >>>>>> <conceptId>7,181</conceptId> >>>>>> <retired>false</retired> >>>>>> <datatype reference="37"/> >>>>>> <conceptClass reference="897"/> >>>>>> <set>false</set> >>>>>> <version>1</version> >>>>>> <creator/> >>>>>> <dateCreated id="10579">2011-12-15 >>>>>> 04:22:46</dateCreated> >>>>>> <changedBy/> >>>>>> <dateChanged id="10580">2012-01-16 >>>>>> 20:03:00</dateChanged> >>>>>> <names class="set" id="10581"> >>>>>> <org.openmrs.ConceptName id="10582" >>>>>> uuid="435c4cb9-5527-491c-87c6-43c3bd64c2e5"> >>>>>> <conceptNameId>14,688</conceptNameId> >>>>>> <concept reference="10577"/> >>>>>> <name>Obstructed Labor, Antepartum</name> >>>>>> <locale id="10583">en</locale> >>>>>> <creator/> >>>>>> <dateCreated id="10584">2011-12-15 >>>>>> 04:22:46</dateCreated> >>>>>> <voided>false</voided> >>>>>> <tags class="set" id="10585"> >>>>>> <org.openmrs.ConceptNameTag reference="28"/> >>>>>> </tags> >>>>>> </org.openmrs.ConceptName> >>>>>> </names> >>>>>> <answers class="set" id="10586"/> >>>>>> <conceptSets class="set" id="10587"/> >>>>>> <descriptions class="set" id="10588"/> >>>>>> <conceptMappings class="set" id="10589"> >>>>>> <org.openmrs.ConceptMap id="10590" >>>>>> uuid="12e8f7ab-c801-4c4e-9ba0-d5a516a8ac81"> >>>>>> <conceptMapId>13,442</conceptMapId> >>>>>> <concept reference="10577"/> >>>>>> <source reference="1428"/> >>>>>> <sourceCode>O66.9</sourceCode> >>>>>> <creator/> >>>>>> <dateCreated id="10591">2011-12-15 >>>>>> 04:22:46</dateCreated> >>>>>> </org.openmrs.ConceptMap> >>>>>> <org.openmrs.ConceptMap id="10592" >>>>>> uuid="06e77deb-29b4-423b-bfb3-51f7670dae71"> >>>>>> <conceptMapId>14,034</conceptMapId> >>>>>> <concept reference="10577"/> >>>>>> <source reference="76"/> >>>>>> <sourceCode>7181</sourceCode> >>>>>> <creator/> >>>>>> <dateCreated id="10593">2012-01-16 >>>>>> 20:03:00</dateCreated> >>>>>> </org.openmrs.ConceptMap> >>>>>> <org.openmrs.ConceptMap id="10594" >>>>>> uuid="0332cfca-4aa4-46a9-9b76-6fa45c9ba336"> >>>>>> <conceptMapId>13,441</conceptMapId> >>>>>> <concept reference="10577"/> >>>>>> <source reference="71"/> >>>>>> <sourceCode>7558</sourceCode> >>>>>> <creator/> >>>>>> <dateCreated id="10595">2011-12-15 >>>>>> 09:20:01</dateCreated> >>>>>> </org.openmrs.ConceptMap> >>>>>> </conceptMappings> >>>>>> <compatibleCache id="10596"> >>>>>> <entry> >>>>>> <locale reference="92"/> >>>>>> <vector id="10597"> >>>>>> <org.openmrs.ConceptName reference="10582"/> >>>>>> </vector> >>>>>> </entry> >>>>>> </compatibleCache> >>>>>> </answerConcept> >>>>>> <creator/> >>>>>> <dateCreated id="10598">2011-12-15 >>>>>> 04:23:05</dateCreated> >>>>>> </org.openmrs.ConceptAnswer> >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> *Rowan Seymour* >>>>> tel: +250 783835665 >>>>> http://twitter.com/rowanseymour >>>>> >>>>> ------------------------------ >>>>> 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 >>> >>> >>> >>> >>> -- >>> *Rowan Seymour* >>> tel: +250 783835665 >>> http://twitter.com/rowanseymour >>> >>> ------------------------------ >>> 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 >> > > ------------------------------ > Click here to > unsubscribe<[email protected]?body=SIGNOFF%20openmrs-devel-l>from > OpenMRS Developers' mailing list > -- *Rowan Seymour* tel: +250 783835665 http://twitter.com/rowanseymour _________________________________________ 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]
