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 _________________________________________ 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]
