I successfully managed to clear the liquibase changelogs for the changes that had not been effected in some of the tables and it went well. I now have a bigger problem in that I get the error below. It still remains even after uploading the logic model (both manually and web interface), tried undeploying OpenMRS but still get the same error.
*The following modules are core to OpenMRS but could not be found and/or started:* logic Please upload a new version of each of these modules and restart OpenMRS to continue. Modules can usually be found at http://modules.openmrs.org. org.openmrs.module.OpenmrsCoreModuleException: The following modules are marked as 'core' by OpenMRS but were unable to start: logic v0.5, at org.openmrs.module.ModuleUtil.checkOpenmrsCoreModulesStarted(ModuleUtil.java:781) at org.openmrs.module.ModuleUtil.startup(ModuleUtil.java:135) at org.openmrs.api.context.Context.startup(Context.java:756) at org.openmrs.web.Listener.startOpenmrs(Listener.java:190) at org.openmrs.web.Listener.contextInitialized(Listener.java:146) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546) at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:905) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:525) at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1359) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:297) at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:857) at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:795) at org.apache.catalina.manager.ManagerServlet.check(ManagerServlet.java:1500) at org.apache.catalina.manager.HTMLManagerServlet.doPost(HTMLManagerServlet.java:252) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:679) On Tue, Sep 27, 2011 at 3:00 PM, Maurice Barasa <[email protected]> wrote: > thanks Ben, > > Will let you know how it all goes. > > Regards, > > > On Tue, Sep 27, 2011 at 2:40 PM, Ben Wolfe <[email protected]> wrote: > >> Yep, this is the problem. >> >> Check your liquibasechangelog table. Is there a row with >> id="20090402-1515-38-global_property" ? If you do, then for some reason >> that table got the update and then either you or someone else replaced that >> table with something else. You need to find the cause of that. If it was >> ONLY the global_property table that was replaced with some earlier sql, you >> can simply delete that row in liquibasechangelog and restart openmrs. (also >> 20090402-1516-global_property, 20090402-1519-global_property, >> 200912071501-1) >> >> If there were other tables that were replaced after you updated, then you >> will need to find all changesets that touch those tables and re-run those >> liquibase changesets. >> >> If you don't have that row, then something strange happened. Just restart >> openmrs and see if it asks to run a few changesets. >> >> Ben >> >> >> On Tue, Sep 27, 2011 at 2:16 PM, Maurice Barasa <[email protected]>wrote: >> >>> The uuid column is not present. (I guess this is the problem). >>> What are the options here? >>> >>> >>> >>> >>> On Tue, Sep 27, 2011 at 1:57 PM, Ben Wolfe <[email protected]> wrote: >>> >>>> You didn't answer my uuid question...does it exist? >>>> >>>> Ben >>>> On Sep 27, 2011 1:41 PM, "Maurice Barasa" <[email protected]> wrote: >>>> > was coming from 1.4.6 to 1.6.3. Yes I have the row in global_property >>>> table >>>> > with property="log.level.openmrs" and property_value="info" >>>> > >>>> > Much appreciated. >>>> > >>>> > >>>> > On Tue, Sep 27, 2011 at 12:07 PM, Ben Wolfe <[email protected]> wrote: >>>> > >>>> >> Is there a row in global_property table with >>>> property="log.level.openmrs" >>>> >> and property_value="info" ? >>>> >> Does your global property table have a uuid column? >>>> >> What version were you testing? >>>> >> What version were you coming from? >>>> >> >>>> >> Ben >>>> >> >>>> >> On Tue, Sep 27, 2011 at 11:42 AM, Maurice Barasa <[email protected] >>>> >wrote: >>>> >> >>>> >>> Was upgrading my version of OpenMRS and got stuck in the middle when >>>> I >>>> >>> went back to continue with the upgrade I got this Error. >>>> >>> What would be the cause tried removing the previous OpenMRS folder >>>> in >>>> >>> tomcat and redeploying OpenMRS manually but no change. >>>> >>> There was a previous similar issue posted *here*< >>>> http://openmrs-mailing-list-archives.1560443.n2.nabble.com/OpenMRS-is-not-able-to-start-td4864478.html>but >>>> didn't get to see a solution at the end. >>>> >>>> >>> What would be the solution? >>>> >>> >>>> >>> * >>>> >>> The following error occurred at startup:* >>>> >>> could not load an entity: >>>> [org.openmrs.GlobalProperty#log.level.openmrs] >>>> >>> >>>> >>> org.hibernate.exception.SQLGrammarException: could not load an >>>> entity: [org.openmrs.GlobalProperty#log.level.openmrs] >>>> >>> at >>>> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) >>>> >>> at >>>> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) >>>> >>> at org.hibernate.loader.Loader.loadEntity(Loader.java:1874) >>>> >>> at >>>> org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48) >>>> >>> at >>>> org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42) >>>> >>> at >>>> org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3044) >>>> >>> at >>>> org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395) >>>> >>> at >>>> org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375) >>>> >>> at >>>> org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139) >>>> >>> at >>>> org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195) >>>> >>> at >>>> org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103) >>>> >>> at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878) >>>> >>> at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815) >>>> >>> at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808) >>>> >>> at >>>> org.openmrs.api.db.hibernate.HibernateAdministrationDAO.getGlobalProperty(HibernateAdministrationDAO.java:233) >>>> >>> at >>>> org.openmrs.api.impl.AdministrationServiceImpl.getGlobalProperty(AdministrationServiceImpl.java:636) >>>> >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>>> >>> at >>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >>>> >>> at >>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>>> >>> at java.lang.reflect.Method.invoke(Method.java:616) >>>> >>> at >>>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) >>>> >>> at >>>> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) >>>> >>> at >>>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) >>>> >>> at >>>> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) >>>> >>> at >>>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) >>>> >>> at >>>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) >>>> >>> at $Proxy32.getGlobalProperty(Unknown Source) >>>> >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>>> >>> at >>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >>>> >>> at >>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>>> >>> at java.lang.reflect.Method.invoke(Method.java:616) >>>> >>> at >>>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) >>>> >>> at >>>> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) >>>> >>> at >>>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) >>>> >>> at >>>> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) >>>> >>> at >>>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) >>>> >>> at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:107) >>>> >>> at >>>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) >>>> >>> at >>>> org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50) >>>> >>> at >>>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) >>>> >>> at >>>> org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50) >>>> >>> at >>>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) >>>> >>> at >>>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) >>>> >>> at $Proxy33.getGlobalProperty(Unknown Source) >>>> >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>>> >>> at >>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >>>> >>> at >>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>>> >>> at java.lang.reflect.Method.invoke(Method.java:616) >>>> >>> at >>>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) >>>> >>> at >>>> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) >>>> >>> at >>>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) >>>> >>> at >>>> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) >>>> >>> at >>>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) >>>> >>> at >>>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) >>>> >>> at $Proxy33.getGlobalProperty(Unknown Source) >>>> >>> at org.openmrs.util.OpenmrsUtil.applyLogLevels(OpenmrsUtil.java:468) >>>> >>> at org.openmrs.util.OpenmrsUtil.startup(OpenmrsUtil.java:457) >>>> >>> at org.openmrs.api.context.Context.startup(Context.java:753) >>>> >>> at org.openmrs.web.Listener.startOpenmrs(Listener.java:190) >>>> >>> at org.openmrs.web.Listener.contextInitialized(Listener.java:146) >>>> >>> at >>>> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135) >>>> >>> at >>>> org.apache.catalina.core.StandardContext.start(StandardContext.java:4630) >>>> >>> at >>>> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791) >>>> >>> at >>>> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771) >>>> >>> at >>>> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546) >>>> >>> at >>>> org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637) >>>> >>> at >>>> org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563) >>>> >>> at >>>> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498) >>>> >>> at >>>> org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277) >>>> >>> at >>>> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321) >>>> >>> at >>>> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) >>>> >>> at >>>> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) >>>> >>> at >>>> org.apache.catalina.core.StandardHost.start(StandardHost.java:785) >>>> >>> at >>>> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) >>>> >>> at >>>> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445) >>>> >>> at >>>> org.apache.catalina.core.StandardService.start(StandardService.java:519) >>>> >>> at >>>> org.apache.catalina.core.StandardServer.start(StandardServer.java:710) >>>> >>> at org.apache.catalina.startup.Catalina.start(Catalina.java:581) >>>> >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>>> >>> at >>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >>>> >>> at >>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>>> >>> at java.lang.reflect.Method.invoke(Method.java:616) >>>> >>> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) >>>> >>> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) >>>> >>> Caused by: >>>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column >>>> 'globalprop0_.uuid' in 'field list' >>>> >>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native >>>> Method) >>>> >>> at >>>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) >>>> >>> at >>>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) >>>> >>> at java.lang.reflect.Constructor.newInstance(Constructor.java:532) >>>> >>> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) >>>> >>> at com.mysql.jdbc.Util.getInstance(Util.java:381) >>>> >>> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) >>>> >>> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) >>>> >>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515) >>>> >>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447) >>>> >>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) >>>> >>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) >>>> >>> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554) >>>> >>> at >>>> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761) >>>> >>> at >>>> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912) >>>> >>> at >>>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) >>>> >>> at >>>> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) >>>> >>> at org.hibernate.loader.Loader.getResultSet(Loader.java:1787) >>>> >>> at org.hibernate.loader.Loader.doQuery(Loader.java:674) >>>> >>> at >>>> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) >>>> >>> at org.hibernate.loader.Loader.loadEntity(Loader.java:1860) >>>> >>> ... 81 more >>>> >>> >>>> >>> >>>> >>> ------------------------------ >>>> >>> 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 >>>> >>>> > >>>> > >>>> > >>>> > >>>> > -- >>>> > *Maurice Barasa* >>>> > __________________________ >>>> > Skype:mouriceb >>>> > Yahoo messenger:baramori >>>> > Cell: +254722853117 >>>> > >>>> > _________________________________________ >>>> > >>>> > 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] >>>> ------------------------------ >>>> Click here to >>>> unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from >>>> OpenMRS Implementers' mailing list >>>> >>> >>> >>> >>> -- >>> *Maurice Barasa* >>> __________________________ >>> Skype:mouriceb >>> Yahoo messenger:baramori >>> Cell: +254722853117 >>> >>> ------------------------------ >>> 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 >> > > > > -- > *Maurice Barasa* > __________________________ > Skype:mouriceb > Yahoo messenger:baramori > Cell: +254722853117 > > -- *Maurice Barasa* __________________________ Skype:mouriceb Yahoo messenger:baramori Cell: +254722853117 _________________________________________ 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]
