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