Yes, I cleared the table yesterday and was able to proceed with testing.thanks for your prompt responses.much appreciated.
D On Aug 3, 2011 10:08 PM, "Piotr Bryk" <[email protected]> wrote: > (this message was sent yesterday, but I had problems with posting to the dev > list) > Hi Dave, > did you upgrade the Metadata Sharing Module (MDS) from 0.8.x version to > 0.9.x? > If yes, it is very likely I've found the cause of this bug. When I'm running > OpenMRS 1.6.x and trunk MDS - both fresh-installed, there is no exception > thrown. But when I'm running OpenMRS 1.6.x and MDS upgraded from 0.8.x to > 0.9.x I'm able to reproduce the exception. > > The bug is caused because of unexpected null-value in > metadatasharing_imported_item MySQL table. There will be an JIRA ticket > created for this issue, but if you want a quick fix you can clear this > table. It can be done by manually typing SQL query, in mysql-administrator > or by setting metadatasharing.database_version global property to 0.7 > (warning: this will delete all zipped packages you have) > > -- > Piotr Bryk > > On Tue, Aug 2, 2011 at 8:44 PM, Dave Thomas <[email protected]> wrote: > >> Sorry, to follow up with this, i put temporary logging into >> HibernatePackageDAO.getImportedItem , and its falling over on loading >> ConceptClass if that helps at all. >> >> Any suggestions? >> >> d >> >> On 8/2/11, Dave Thomas <[email protected]> wrote: >> > Hi. I'm using last night's build of both metadata sharing and 1.6.x, >> > and i'm running into problems importing a simple Concept. >> > >> > To reproduce: create a metadata sharing package with the Concept >> > Height(CM), and then try to reimport it on the same openmrs instance >> > (which shouldn't hurt anything because the export should reflect >> > exactly what's in the database) >> > >> > I'm using serialization Xstream 0.2.5 if it makes a difference. >> > >> > Here's the error: >> > >> > An Internal Error has Occurred >> > org.hibernate.PropertyAccessException >> > >> > Exception occurred inside setter of >> > org.openmrs.module.metadatasharing.ImportedItem.importType >> > >> org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:65) >> > >> org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:337) >> > >> org.hibernate.tuple.entity.PojoEntityTuplizer.setPropertyValues(PojoEntityTuplizer.java:200) >> > >> org.hibernate.persister.entity.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:3566) >> > org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:129) >> > >> org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:854) >> > org.hibernate.loader.Loader.doQuery(Loader.java:729) >> > >> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) >> > org.hibernate.loader.Loader.doList(Loader.java:2220) >> > org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) >> > org.hibernate.loader.Loader.list(Loader.java:2099) >> > org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94) >> > org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569) >> > org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283) >> > org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305) >> > >> org.openmrs.module.metadatasharing.api.db.hibernate.HibernatePackageDAO.getImportedItem(HibernatePackageDAO.java:111) >> > >> org.openmrs.module.metadatasharing.api.impl.PackageServiceImpl.getImportedItem(PackageServiceImpl.java:112) >> > sun.reflect.GeneratedMethodAccessor2114.invoke(Unknown Source) >> > >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >> > java.lang.reflect.Method.invoke(Method.java:597) >> > >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) >> > >> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) >> > >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) >> > >> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) >> > >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) >> > >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) >> > $Proxy4025.getImportedItem(Unknown Source) >> > sun.reflect.GeneratedMethodAccessor2114.invoke(Unknown Source) >> > >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >> > java.lang.reflect.Method.invoke(Method.java:597) >> > >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) >> > >> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) >> > >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) >> > >> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) >> > >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) >> > org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:107) >> > >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) >> > >> org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50) >> > >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) >> > >> org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50) >> > >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) >> > >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) >> > $Proxy4026.getImportedItem(Unknown Source) >> > sun.reflect.GeneratedMethodAccessor2114.invoke(Unknown Source) >> > >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >> > java.lang.reflect.Method.invoke(Method.java:597) >> > >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) >> > >> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) >> > >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) >> > >> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) >> > >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) >> > >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) >> > $Proxy4026.getImportedItem(Unknown Source) >> > >> org.openmrs.module.metadatasharing.wrapper.impl.MetadataImporterImpl.getExistingOrNewImportedItem(MetadataImporterImpl.java:145) >> > >> org.openmrs.module.metadatasharing.wrapper.impl.MetadataImporterImpl.access$000(MetadataImporterImpl.java:51) >> > >> org.openmrs.module.metadatasharing.wrapper.impl.MetadataImporterImpl$1.visitMetadata(MetadataImporterImpl.java:197) >> > >> org.openmrs.module.metadatasharing.wrapper.impl.MetadataImporterImpl$1.visit(MetadataImporterImpl.java:184) >> > >> org.openmrs.module.metadatasharing.visitor.impl.OpenmrsObjectVisitor$1.visit(OpenmrsObjectVisitor.java:91) >> > >> com.thoughtworks.xstream.converters.reflection.PureJavaReflectionProvider.visitSerializableFields(PureJavaReflectionProvider.java:129) >> > >> org.openmrs.module.metadatasharing.visitor.impl.OpenmrsObjectVisitor.visitFields(OpenmrsObjectVisitor.java:78) >> > >> org.openmrs.module.metadatasharing.wrapper.impl.MetadataImporterImpl.resolveRelatedImportedItems(MetadataImporterImpl.java:180) >> > >> org.openmrs.module.metadatasharing.wrapper.impl.MetadataImporterImpl.resolveRelatedItems(MetadataImporterImpl.java:175) >> > >> org.openmrs.module.metadatasharing.web.controller.ImportController.uploadPackagePost(ImportController.java:134) >> > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> > >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >> > >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >> > java.lang.reflect.Method.invoke(Method.java:597) >> > >> org.springframework.web.bind.annotation.support.HandlerMethodInvoker.doInvokeMethod(HandlerMethodInvoker.java:421) >> > >> org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:136) >> > >> org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:326) >> > >> org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:313) >> > >> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) >> > >> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807) >> > >> org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) >> > >> org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511) >> > javax.servlet.http.HttpServlet.service(HttpServlet.java:637) >> > javax.servlet.http.HttpServlet.service(HttpServlet.java:717) >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> > >> org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:76) >> > org.openmrs.module.web.filter.ModuleFilter.doFilter(ModuleFilter.java:58) >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> > >> org.openmrs.web.filter.OpenmrsFilter.doFilterInternal(OpenmrsFilter.java:112) >> > >> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> > >> org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) >> > >> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> > org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:82) >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> > org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:82) >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> > org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:82) >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> > >> org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96) >> > >> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> > >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) >> > >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) >> > >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) >> > >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) >> > >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) >> > >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) >> > >> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) >> > >> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) >> > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) >> > java.lang.Thread.run(Thread.java:662) >> > >> >> _________________________________________ >> >> 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] >> > > _________________________________________ > > 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] _________________________________________ 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]
