dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Okay thanks.

On Wed, Feb 11, 2015 at 9:22 AM, Sandesh Sukumar Doolipeta <
sandeshd@xxxxxxxxxxxxxxxx> 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 <dan@xxxxxxxxxxxx> 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 <larshelge@xxxxxxxxx>
>> 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 <
>> sandeshd@xxxxxxxxxxxxxxxx> 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*
>>> Emailsandeshd@xxxxxxxxxxxxxxxx
>>> Telephone9686062727
>>> [image: ThoughtWorks] <http://www.thoughtworks.com/>
>>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>>
>
>
> --
> *Sandesh Doolipeta**Application Developer*
> Emailsandeshd@xxxxxxxxxxxxxxxx
> Telephone9686062727
> [image: ThoughtWorks] <http://www.thoughtworks.com/>
>