Jan 29 10:48:03 amrsprod1 jsvc.exec[22419]: ERROR - LoggingAdvice.invoke(111) |2010-01-29 10:48:03,565| An error occurred while executing this method. Error message: Error while running sql: SELECT distinct tribe from patient where 1 = 0 . Message: Unknown column 'tribe' in 'field list'#012org.openmrs.api.db.DAOException: Error while running sql: SELECT distinct tribe from patient where 1 = 0 . Message: Unknown column 'tribe' in 'field list'#012#011at org.openmrs.api.db.hibernate.HibernateAdministrationDAO.executeSQL(HibernateAdministrationDAO.java:353)#012#011at org.openmrs.api.impl.AdministrationServiceImpl.executeSQL(AdministrationServiceImpl.java:795)#012#011at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)#012#011at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)#012#011at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)#012#011at java.lang.reflect.Method.invoke(Method.java:616)#012#011at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)#012#011at org.springframework.aop.framew
Jan 29 10:48:03 amrsprod1 jsvc.exec[22419]: ork.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)#012#011at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)#012#011at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)#012#011at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)#012#011at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)#012#011at $Proxy31.executeSQL(Unknown Source)#012#011at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)#012#011at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)#012#011at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)#012#011at java.lang.reflect.Method.invoke(Method.java:616)#012#011at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)#012#011at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(Reflective
Jan 29 10:48:03 amrsprod1 jsvc.exec[22419]: MethodInvocation.java:182)#012#011at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)#012#011at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)#012#011at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)#012#011at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:107)#012#011at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)#012#011at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50)#012#011at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)#012#011at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50)#012#011at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)#012#011at org.springframework.ao
Jan 29 10:48:03 amrsprod1 jsvc.exec[22419]: p.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)#012#011at $Proxy32.executeSQL(Unknown Source)#012#011at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)#012#011at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)#012#011at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)#012#011at java.lang.reflect.Method.invoke(Method.java:616)#012#011at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)#012#011at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)#012#011at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)#012#011at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)#012#011at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)#012#011at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.
Jan 29 10:48:03 amrsprod1 jsvc.exec[22419]: java:204)#012#011at $Proxy32.executeSQL(Unknown Source)#012#011at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)#012#011at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)#012#011at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)#012#011at java.lang.reflect.Method.invoke(Method.java:616)#012#011at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)#012#011at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)#012#011at $Proxy60.executeSQL(Unknown Source)#012#011at org.openmrs.module.tribe.TribeActivator.extractTribeColumn(TribeActivator.java:77)#012#011at org.openmrs.module.tribe.TribeActivator.startup(TribeActivator.java:41)#012#011at org.openmrs.module.ModuleFactory.startModule(ModuleFactory.java:492)#012#011at org.openmrs.module.ModuleFactory.startModules(ModuleFactory.java:187)#012#011at org.openmrs.module.ModuleUtil.startup(ModuleUtil.java:119)#012#011at org.openmrs.api.context.Context.startup(Context.java:743)#012#011at org.openmrs.web.L
Jan 29 10:48:03 amrsprod1 jsvc.exec[22419]: istener.startOpenmrs(Listener.java:182)#012#011at org.openmrs.web.Listener.contextInitialized(Listener.java:142)#012#011at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)#012#011at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)#012#011at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)#012#011at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)#012#011at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)#012#011at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:630)#012#011at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:556)#012#011at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:491)#012#011at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)#012#011at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:314)#012#011at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)#012#011at org.apache.catalina.core.Container
Jan 29 10:48:03 amrsprod1 jsvc.exec[22419]: Base.start(ContainerBase.java:1053)#012#011at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)#012#011at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)#012#011at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)#012#011at org.apache.catalina.core.StandardService.start(StandardService.java:516)#012#011at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)#012#011at org.apache.catalina.startup.Catalina.start(Catalina.java:583)#012#011at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)#012#011at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)#012#011at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)#012#011at java.lang.reflect.Method.invoke(Method.java:616)#012#011at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)#012#011at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)#012#011at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)#012#011at sun.reflect.DelegatingMethodAccessorImpl.i
Jan 29 10:48:03 amrsprod1 jsvc.exec[22419]: nvoke(DelegatingMethodAccessorImpl.java:43)#012#011at java.lang.reflect.Method.invoke(Method.java:616)#012#011at org.apache.commons.daemon.support.DaemonLoader.start(DaemonLoader.java:177)#012Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'tribe' in 'field list'#012#011at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)#012#011at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)#012#011at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)#012#011at java.lang.reflect.Constructor.newInstance(Constructor.java:532)#012#011at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)#012#011at com.mysql.jdbc.Util.getInstance(Util.java:381)#012#011at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)#012#011at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)#012#011at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)#012#011at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)#012#011at com.mysql.jdbc.MysqlIO
Jan 29 10:48:03 amrsprod1 jsvc.exec[22419]: .sendCommand(MysqlIO.java:1951)#012#011at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)#012#011at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)#012#011at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)#012#011at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912)#012#011at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)#012#011at org.openmrs.api.db.hibernate.HibernateAdministrationDAO.executeSQL(HibernateAdministrationDAO.java:337)#012#011... 83 more#012INFO - LoggingAdvice.invoke(127) |2010-01-29 10:48:03,567| Exiting method executeSQL
Jan 29 10:48:03 amrsprod1 jsvc.exec[22419]: INFO - LoggingAdvice.invoke(102) |2010-01-29 10:48:03,577| In method AdministrationService.executeSQL. Arguments: String=SELECT distinct uuid from tribe where 1 = 0, boolean=true,