Look in your logs above that error message and see the other error reported. Or better yet, clear your logs, then restart openmrs and attach the output here so we can see the whole output.
Ben On Wed, Sep 28, 2011 at 3:18 PM, Maurice Barasa <[email protected]> wrote: > 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 > > ------------------------------ > 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]
