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