from 1.8 to 1.9RC3 On Wed, Apr 18, 2012 at 12:46 PM, Wyclif Luyima <[email protected]> wrote:
> What versions of OpenMRS are you importing to and from? Can you ensure > that the test database you are importing into data is empty? > > Wyclif > > On Wed, Apr 18, 2012 at 11:07 AM, Matthew Ssemakadde <[email protected] > > wrote: > >> Hi Daniel, Ben and others, >> >> http://pastebin.com/sx7j6B2e >> pestebin link to my production server log >> >> am seeing something similar to the error i keep getting while upgrading >> >> 1. INFO - LoggingAdvice.invoke(109) |2012-04-18 17:46:09,095| In >> method AdministrationService.saveGlobalProperty. Arguments: >> GlobalProperty=property: releasetestinghelper.started value: true, >> 2. INFO - LoggingAdvice.invoke(134) |2012-04-18 17:46:09,095| Exiting >> method saveGlobalProperty >> 3. INFO - LoggingAdvice.invoke(109) |2012-04-18 17:46:09,126| In >> method AdministrationService.saveGlobalProperty. Arguments: >> GlobalProperty=property: releasetestinghelper.mandatory value: false, >> 4. INFO - LoggingAdvice.invoke(134) |2012-04-18 17:46:09,126| Exiting >> method saveGlobalProperty >> 5. INFO - TestingActivator.startup(31) |2012-04-18 17:46:09,165| >> Starting releasetestinghelper Module >> 6. INFO - LoggingAdvice.invoke(109) |2012-04-18 17:46:09,195| In >> method SchedulerService.saveToMemento. Arguments: >> 7. INFO - LoggingAdvice.invoke(134) |2012-04-18 17:46:09,210| Exiting >> method saveToMemento >> 8. INFO - AbstractSessionFactoryBean.destroy(246) |2012-04-18 >> 17:46:09,254| Closing Hibernate SessionFactory >> 9. INFO - LocalSessionFactoryBean.buildSessionFactory(777) >> |2012-04-18 17:46:13,450| Building new Hibernate SessionFactory >> 10. INFO - AbstractUrlHandlerMapping.registerHandler(411) |2012-04-18 >> 17:46:14,361| Mapped URL path [/module/xforms/xformDesigner.form] onto >> handler 'xformDesigner' >> 11. INFO - AbstractUrlHandlerMapping.registerHandler(411) |2012-04-18 >> 17:46:14,363| Mapped URL path [/module/xforms/patientDownload.form] onto >> handler 'patientDownload' >> 12. INFO - AbstractUrlHandlerMapping.registerHandler(411) |2012-04-18 >> 17:46:14,365| Mapped URL path [/module/xforms/xsltUpload.form] onto >> handler >> 'xsltUpload' >> 13. INFO - AbstractUrlHandlerMapping.registerHandler(411) |2012-04-18 >> 17:46:14,389| Mapped URL path [/module/xforms/xformDelete.form] onto >> handler 'xformDelete' >> 14. INFO - AbstractUrlHandlerMapping.registerHandler(411) |2012-04-18 >> 17:46:14,391| Mapped URL path [/module/xforms/formEntry.form] onto handler >> 'formEntry' >> 15. INFO - AbstractUrlHandlerMapping.registerHandler(411) |2012-04-18 >> 17:46:14,393| Mapped URL path [/module/xforms/medicalHistoryFields.form] >> onto handler 'medicalHistoryFields' >> 16. INFO - AbstractUrlHandlerMapping.registerHandler(411) |2012-04-18 >> 17:46:14,395| Mapped URL path [/module/xforms/xformDataUpload.form] onto >> handler 'xformDataUpload' >> 17. INFO - AbstractUrlHandlerMapping.registerHandler(411) |2012-04-18 >> 17:46:14,396| Mapped URL path [/module/xforms/xformUpload.form] onto >> handler 'xformUpload' >> 18. INFO - LoggingAdvice.invoke(109) |2012-04-18 17:46:14,877| In >> method SchedulerService.restoreFromMemento. Arguments: >> OpenmrsMemento=org.openmrs.scheduler.timer.TimerSchedulerMemento@1a8a53, >> >> 19. INFO - TimerSchedulerServiceImpl.scheduleTask(232) |2012-04-18 >> 17:46:14,879| Starting task ... the task will execute for the first time >> at >> Tue Sep 03 20:47:54 PDT 2075 >> 20. INFO - TimerSchedulerServiceImpl.scheduleTask(232) |2012-04-18 >> 17:46:14,881| Starting task ... the task will execute for the first time >> at >> Wed Apr 18 17:46:30 PDT 2012 >> 21. INFO - TimerSchedulerServiceImpl.scheduleTask(238) |2012-04-18 >> 17:46:14,883| Delaying start time by 0 seconds >> 22. INFO - TimerSchedulerServiceImpl.scheduleTask(232) |2012-04-18 >> 17:46:14,885| Starting task ... the task will execute for the first time >> at >> Wed Apr 18 17:50:00 PDT 2012 >> 23. INFO - TimerSchedulerServiceImpl.scheduleTask(232) |2012-04-18 >> 17:46:14,886| Starting task ... the task will execute for the first time >> at >> Wed Apr 18 17:46:30 PDT 2012 >> 24. INFO - TimerSchedulerServiceImpl.scheduleTask(238) |2012-04-18 >> 17:46:14,888| Delaying start time by 0 seconds >> 25. INFO - LoggingAdvice.invoke(134) |2012-04-18 17:46:14,890| >> Exiting method restoreFromMemento >> 26. INFO - LoggingAdvice.invoke(109) |2012-04-18 17:46:14,896| In >> method ReportService.deleteOldReportRequests. Arguments: >> 27. INFO - LoggingAdvice.invoke(134) |2012-04-18 17:46:14,898| >> Exiting method deleteOldReportRequests >> 28. INFO - FrameworkServlet.initServletBean(301) |2012-04-18 >> 17:46:14,916| FrameworkServlet 'openmrs': initialization started >> 29. INFO - FrameworkServlet.initServletBean(320) |2012-04-18 >> 17:46:14,923| FrameworkServlet 'openmrs': initialization completed in 7 ms >> 30. ERROR - CommonsLoggingOutput.error(75) |2012-04-18 17:46:14,948| >> Line=82 The content of element type "dwr" must match >> "(init?,allow?,signatures?)". >> 31. ERROR - CommonsLoggingOutput.error(75) |2012-04-18 17:46:14,949| >> Parameter mismatch parsing signatures section in dwr.xml on line: >> DWRHtmlFormEntryService.checkIfLoggedIn() >> 32. WARN - CommonsLoggingOutput.warn(59) |2012-04-18 17:46:14,969| >> Setting extra type info to overloaded methods may fail with <parameter >> .../> >> 33. INFO - ModuleListController.formBackingObject(261) |2012-04-18 >> 17:46:15,235| Returning 13 modules >> 34. INFO - LoggingAdvice.invoke(109) |2012-04-18 17:49:54,228| In >> method TestingService.generateTestDataSet. Arguments: >> OutputStream=org.apache.catalina.connector.CoyoteOutputStream@1531578, >> >> 35. WARN - HibernateTestingDao.generateTestDataSet(96) |2012-04-18 >> 17:49:54,232| schema: openmrs >> 36. WARN - HibernateTestingDao.generateTestDataSet(107) |2012-04-18 >> 17:49:57,525| tables to dump: [active_list, active_list_allergy, >> active_list_problem, active_list_type, clinical_summary, >> clinical_summary_print_queue, cohort, cohort_member, concept, >> concept_answer, concept_class, concept_complex, concept_datatype, >> concept_description, concept_map, concept_map_type, concept_name, >> concept_name_tag, concept_name_tag_map, concept_numeric, concept_proposal, >> concept_proposal_tag_map, concept_reference_map, concept_reference_source, >> concept_reference_term, concept_reference_term_map, concept_set, >> concept_set_derived, concept_source, concept_state_conversion, >> concept_stop_word, concept_word, dataintegrity_integrity_checks, >> dataintegrity_results, districts, drug, drug_ingredient, drug_order, >> encounter, encounter_provider, encounter_role, encounter_type, field, >> field_answer, field_type, form, form_field, formentry_error, >> formentry_xsn, >> global_property, hello_world_response, hl7_in_archive, hl7_in_error, >> hl7_in_queue, hl7_source, htmlformentry_html_form, jasper_parameters, >> jasper_report, linkagetable, liquibasechangelog, liquibasechangeloglock, >> location, location_attribute, location_attribute_type, location_tag, >> location_tag_map, logic_rule_definition, logic_rule_token, >> logic_rule_token_tag, logic_token_registration, >> logic_token_registration_tag, note, notification_alert, >> notification_alert_recipient, notification_template, obs, order_type, >> orders, patient, patient_identifier, patient_identifier_type, >> patient_program, patient_state, person, person_address, person_attribute, >> person_attribute_type, person_merge_log, person_name, privilege, program, >> program_workflow, program_workflow_state, provider, provider_attribute, >> provider_attribute_type, relationship, relationship_type, report_object, >> report_schema_xml, reporting_report_design, >> reporting_report_design_resource, reporting_report_request, role, >> role_privilege, role_role, scheduler_task_config, >> scheduler_task_config_property, serialized_object, tribe, >> usagestatistics_daily, usagestatistics_encounter, usagestatistics_usage, >> user_property, user_role, users, visit, visit_attribute, >> visit_attribute_type, visit_type, xforms_medical_history_field, >> xforms_person_repeat_attribute, xforms_xform] >> 37. ERROR - LoggingAdvice.invoke(118) |2012-04-18 17:50:25,910| An >> error occurred while executing this method. Error message: >> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table >> 'openmrs.concept_map_type' doesn't exist >> 38. org.openmrs.api.db.DAOException: >> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table >> 'openmrs.concept_map_type' doesn't exist >> 39. at >> >> org.openmrs.module.releasetestinghelper.api.db.hibernate.HibernateTestingDao.generateTestDataSet(HibernateTestingDao.java:229) >> 40. at >> >> org.openmrs.module.releasetestinghelper.api.impl.TestingServiceImpl.generateTestDataSet(TestingServiceImpl.java:47) >> 41. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >> Method) >> 42. at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown >> Source) >> 43. at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) >> 44. at java.lang.reflect.Method.invoke(Unknown Source) >> 45. at >> >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) >> 46. at >> >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196) >> 47. at $Proxy238.generateTestDataSet(Unknown Source) >> 48. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >> Method) >> 49. at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown >> Source) >> 50. at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) >> 51. at java.lang.reflect.Method.invoke(Unknown Source) >> 52. at >> >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) >> 53. at >> >> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) >> 54. at >> >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) >> 55. at >> org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:114) >> 56. at >> >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) >> 57. at >> >> org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50) >> 58. at >> >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) >> 59. at >> >> org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50) >> 60. at >> >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) >> 61. at >> >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) >> 62. at $Proxy239.generateTestDataSet(Unknown Source) >> 63. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >> Method) >> 64. at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown >> Source) >> 65. at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) >> 66. at java.lang.reflect.Method.invoke(Unknown Source) >> 67. at >> >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) >> 68. at >> >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196) >> 69. at $Proxy239.generateTestDataSet(Unknown Source) >> 70. at >> >> org.openmrs.module.releasetestinghelper.web.controller.TestingController.generateTestDataSet(TestingController.java:76) >> 71. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >> Method) >> 72. at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown >> Source) >> 73. at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) >> 74. at java.lang.reflect.Method.invoke(Unknown Source) >> 75. at >> >> org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176) >> 76. at >> >> org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:426) >> 77. at >> >> org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:414) >> 78. at >> >> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790) >> 79. at >> >> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719) >> 80. at >> >> org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644) >> 81. at >> >> org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560) >> 82. at >> javax.servlet.http.HttpServlet.service(HttpServlet.java:637) >> 83. at >> javax.servlet.http.HttpServlet.service(HttpServlet.java:717) >> 84. at >> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) >> 85. at >> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> 86. at >> >> org.openmrs.module.web.filter.ForcePasswordChangeFilter.doFilter(ForcePasswordChangeFilter.java:65) >> 87. at >> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> 88. at >> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> 89. at >> >> org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:76) >> 90. at >> org.openmrs.module.xforms.web.XformsFilter.doFilter(XformsFilter.java:60) >> 91. at >> >> org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:74) >> 92. at >> org.openmrs.module.web.filter.ModuleFilter.doFilter(ModuleFilter.java:58) >> 93. at >> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> 94. at >> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> 95. at >> >> org.openmrs.web.filter.OpenmrsFilter.doFilterInternal(OpenmrsFilter.java:112) >> 96. at >> >> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) >> 97. at >> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> 98. at >> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> 99. at >> >> org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) >> 100. at >> >> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) >> 101. at >> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> 102. at >> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> 103. at >> org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:83) >> 104. at >> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> 105. at >> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> 106. at >> org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:83) >> 107. at >> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> 108. at >> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> 109. at >> org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:83) >> 110. at >> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> 111. at >> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> 112. at >> >> org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) >> 113. at >> >> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) >> 114. at >> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> 115. at >> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> 116. at >> >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) >> 117. at >> >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) >> 118. at >> >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) >> 119. at >> >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) >> 120. at >> >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) >> 121. at >> >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) >> 122. at >> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) >> 123. at >> >> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) >> 124. at >> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) >> 125. at java.lang.Thread.run(Unknown Source) >> 126. Caused by: >> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table >> 'openmrs.concept_map_type' doesn't exist >> 127. at >> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >> 128. at >> sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) >> 129. at >> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) >> 130. at java.lang.reflect.Constructor.newInstance(Unknown >> Source) >> 131. at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) >> 132. at com.mysql.jdbc.Util.getInstance(Util.java:381) >> 133. at >> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) >> 134. at >> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) >> 135. at >> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536) >> 136. at >> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468) >> 137. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957) >> 138. at >> com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107) >> 139. at >> com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642) >> 140. at >> com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2571) >> 141. at >> com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1451) >> 142. at >> >> com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) >> 143. at >> >> org.openmrs.module.releasetestinghelper.api.db.hibernate.HibernateTestingDao.generateTestDataSet(HibernateTestingDao.java:144) >> 144. ... 86 more >> 145. INFO - LoggingAdvice.invoke(134) |2012-04-18 17:50:25,912| >> Exiting method generateTestDataSet >> >> >> >> >> >> Matthew >> Masaka(Ug) >> >> On Sun, Apr 15, 2012 at 1:17 AM, Daniel Kayiwa <[email protected]>wrote: >> >>> >>> Hi Mathew, >>> >>> Can you also pastebin the contents of the tomcat log for your production >>> data server? >>> >>> Am also assuming that your production server has the * >>> &zeroDateTimeBehavior=convertToNull * in its database connection string >>> as per the configuration section on this page: >>> https://wiki.openmrs.org/display/docs/Release+Testing+Helper+Module >>> >>> >>> On Sun, Apr 15, 2012 at 11:18 AM, Matthew Ssemakadde < >>> [email protected]> wrote: >>> >>>> hi all >>>> am trying to test 1.9RC3 using my production data but keep getting this >>>> error >>>> >>>> Error while trying to import test data >>>> >>>> any help >>>> >>>> pestebin link is http://pastebin.com/1zEtrmkT >>>> >>>> >>>> Matthew >>>> Masaka(Ug) >>>> ------------------------------ >>>> Click here to >>>> unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from >>>> OpenMRS Implementers' mailing list >>> >>> >>> >>> >>> -- >>> If we keep uppermost in our minds the unkind and unjust acts of others, >>> we shall find it impossible to love them as Christ has loved us; but if our >>> thoughts dwell upon the wondrous love and pity of Christ for us, the same >>> spirit will flow out to others. >>> ------------------------------ >>> Click here to >>> unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from >>> OpenMRS Implementers' mailing list >> >> >> ------------------------------ >> Click here to >> unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from >> OpenMRS Implementers' mailing list > > > ------------------------------ > Click here to > unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from > OpenMRS Implementers' mailing list > _________________________________________ To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-implement-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l]
