Okay thanks. On Wed, Feb 11, 2015 at 9:22 AM, Sandesh Sukumar Doolipeta < [email protected]> wrote:
> Hi lars & dan , > > Looks like this was happening only on my machine. It was not > reproducible in other machines. > > On Tue, Feb 10, 2015 at 9:59 PM, Dan Cocos <[email protected]> wrote: > >> Could it be that in hibernate.properties >> hibernate.hbm2ddl.auto = update >> is set to something else? >> >> On Feb 10, 2015, at 10:54 AM, Lars Helge Øverland <[email protected]> >> wrote: >> >> Hi Sandesh, >> >> I have never seen this error and cannot reproduce locally with latest >> trunk. Anyone seen this? Could it be an accident on your side? >> >> Try to add the uid column manually with >> >> ALTER TABLE dashboard ADD COLUMN uid character varying(11); >> >> then restart dhis - should populate the uids. >> >> Lars >> >> >> On Tue, Feb 10, 2015 at 8:13 AM, Sandesh Sukumar Doolipeta < >> [email protected]> wrote: >> >>> Hi, >>> >>> There is an error when DHIS (rev 18213) starts up. "uid" column is >>> missing from "dashboard" table. >>> >>> Below is postgres screenshot. >>> >>> <image.png> >>> >>> Here's the stack trace. >>> >>> ERROR 2015-02-10 12:27:59,062 Problem updating: dashboard, id column: >>> dashboardid (IdentityPopulator.java [main]) >>> org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad >>> SQL grammar [SELECT * from dashboard WHERE uid IS NULL]; nested exception >>> is org.postgresql.util.PSQLException: ERROR: column "uid" does not exist >>> Position: 31 >>> at >>> org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:99) >>> at >>> org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) >>> at >>> org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) >>> at >>> org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) >>> at >>> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416) >>> at >>> org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471) >>> at >>> org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526) >>> at >>> org.hisp.dhis.common.IdentityPopulator.execute(IdentityPopulator.java:86) >>> at >>> org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:119) >>> at >>> org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:88) >>> at >>> org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:68) >>> at >>> org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:800) >>> at >>> org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:444) >>> at >>> org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:791) >>> at >>> org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:294) >>> at >>> org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1349) >>> at >>> org.eclipse.jetty.maven.plugin.JettyWebAppContext.startWebapp(JettyWebAppContext.java:296) >>> at >>> org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1342) >>> at >>> org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:741) >>> at >>> org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:505) >>> at >>> org.eclipse.jetty.maven.plugin.JettyWebAppContext.doStart(JettyWebAppContext.java:365) >>> at >>> org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) >>> at >>> org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:132) >>> at >>> org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:114) >>> at >>> org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:61) >>> at >>> org.eclipse.jetty.server.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:163) >>> at >>> org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) >>> at >>> org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:132) >>> at >>> org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:114) >>> at >>> org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:61) >>> at >>> org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) >>> at >>> org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:132) >>> at org.eclipse.jetty.server.Server.start(Server.java:387) >>> at >>> org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:114) >>> at >>> org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:61) >>> at org.eclipse.jetty.server.Server.doStart(Server.java:354) >>> at >>> org.eclipse.jetty.maven.plugin.JettyServer.doStart(JettyServer.java:73) >>> at >>> org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) >>> at >>> org.eclipse.jetty.maven.plugin.AbstractJettyMojo.startJetty(AbstractJettyMojo.java:534) >>> at >>> org.eclipse.jetty.maven.plugin.AbstractJettyMojo.execute(AbstractJettyMojo.java:357) >>> at >>> org.eclipse.jetty.maven.plugin.JettyRunWarMojo.execute(JettyRunWarMojo.java:64) >>> at >>> org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:133) >>> at >>> org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:208) >>> at >>> org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153) >>> at >>> org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145) >>> at >>> org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:108) >>> at >>> org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:76) >>> at >>> org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build(SingleThreadedBuilder.java:51) >>> at >>> org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:116) >>> at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:361) >>> at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:155) >>> at org.apache.maven.cli.MavenCli.execute(MavenCli.java:584) >>> at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:213) >>> at org.apache.maven.cli.MavenCli.main(MavenCli.java:157) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>> at java.lang.reflect.Method.invoke(Method.java:483) >>> at >>> org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289) >>> at >>> org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229) >>> at >>> org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:415) >>> at >>> org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356) >>> Caused by: org.postgresql.util.PSQLException: ERROR: column "uid" does >>> not exist >>> Position: 31 >>> at >>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) >>> at >>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) >>> at >>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) >>> at >>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) >>> at >>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405) >>> at >>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:285) >>> at >>> com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) >>> at >>> org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455) >>> at >>> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405) >>> ... 57 more >>> >>> -- >>> *Sandesh Doolipeta**Application Developer* >>> [email protected] >>> Telephone9686062727 >>> [image: ThoughtWorks] <http://www.thoughtworks.com/> >>> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> >> > > > -- > *Sandesh Doolipeta**Application Developer* > [email protected] > Telephone9686062727 > [image: ThoughtWorks] <http://www.thoughtworks.com/> >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
