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