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