Activity Digest since 10:24PM for INF 5750 on Piazza

Support - Assistance technique
1

Any idea what the issue could be here with DHIS Live?

···

Cheers,
Knut Staring

2

Caused by: org.postgresql.util.PSQLException: ERROR: column usercreden1_.uid does not exist

Maybe you should try and add that column manually?

···

On Tue, Oct 18, 2016 at 4:17 AM, Knut Staring knutst@ifi.uio.no wrote:

Any idea what the issue could be here with DHIS Live?

---------- Forwarded message ----------
And this is conf/logs/dhis.log:

* INFO 2016-10-17 22:01:09,926 Added root logger using file: /D:/skule/inf5750/dhis-live/conf\logs\dhis.log (Log4JLogConfigInitializer.java [Thread-2])
* WARN 2016-10-17 22:01:10,947 RP discovery / realm validation disabled; (RealmVerifier.java [Thread-2])
* INFO 2016-10-17 22:01:13,701 SMS configuration not found (DefaultSmsConfigurationManager.java [Thread-2])
* INFO 2016-10-17 22:01:13,828 Scheduled task with key: fileResourceCleanupTask and cron: 0 0 2 * * ? (SpringScheduler.java [Thread-2])
* INFO 2016-10-17 22:01:13,829 Scheduled task with key: dataStatisticsTask and cron: 0 0 2 * * ? (SpringScheduler.java [Thread-2])
* INFO 2016-10-17 22:01:13,841 Executing startup routine [1 of 14, runlevel 1]: InitTableAlteror (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO 2016-10-17 22:01:20,688 Executing startup routine [2 of 14, runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO 2016-10-17 22:01:20,739 Executing startup routine [3 of 14, runlevel 3]: DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO 2016-10-17 22:01:20,876 'system-process' update org.hisp.dhis.dataelement.DataElementCategory, name: default, uid: vGs6omsRekv (AuditLogUtil.java [Thread-2])
* WARN 2016-10-17 22:01:21,256 SQL Error: 0, SQLState: 42703 (SqlExceptionHelper.java [Thread-2])
* ERROR 2016-10-17 22:01:21,257 ERROR: column usercreden1_.uid does not exist
Position: 756 (SqlExceptionHelper.java [Thread-2])
* ERROR 2016-10-17 22:01:21,265 org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.getResultSet(AbstractLoadPlanBasedLoader.java:434)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:186)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:121)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:86)
at [org.hibernate.loader.entity.pl](http://org.hibernate.loader.entity.pl)an.AbstractLoadPlanBasedEntityLoader.load(AbstractLoadPlanBasedEntityLoader.java:167)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3991)
at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:508)
at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:478)
at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:219)
at org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:262)
at org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:121)
at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:89)
at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1142)
at org.hibernate.internal.SessionImpl.internalLoad(SessionImpl.java:1025)
at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:632)
at org.hibernate.type.EntityType.resolve(EntityType.java:424)
at org.hibernate.engine.internal.TwoPhaseLoad.doInitializeEntity(TwoPhaseLoad.java:151)
at org.hibernate.engine.internal.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:125)
at [org.hibernate.loader.Loader.in](http://org.hibernate.loader.Loader.in)itializeEntitiesAndCollections(Loader.java:1132)
at [org.hibernate.loader.Loader.pr](http://org.hibernate.loader.Loader.pr)ocessResultSet(Loader.java:992)
at [org.hibernate.loader.Loader.do](http://org.hibernate.loader.Loader.do)Query(Loader.java:930)
at [org.hibernate.loader.Loader.do](http://org.hibernate.loader.Loader.do)QueryAndInitializeNonLazyCollections(Loader.java:336)
at [org.hibernate.loader.Loader.do](http://org.hibernate.loader.Loader.do)List(Loader.java:2610)
at [org.hibernate.loader.Loader.li](http://org.hibernate.loader.Loader.li)stUsingQueryCache(Loader.java:2452)
at [org.hibernate.loader.Loader.li](http://org.hibernate.loader.Loader.li)st(Loader.java:2414)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:109)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1787)
at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:363)
at org.hisp.dhis.hibernate.HibernateGenericStore.getAll(HibernateGenericStore.java:517)
at org.hisp.dhis.dataelement.DefaultDataElementService.getAllDataElements(DefaultDataElementService.java:122)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
at com.sun.proxy.$Proxy78.getAllDataElements(Unknown Source)
at org.hisp.dhis.dataelement.DataElementDefaultDimensionPopulator.executeInTransaction(DataElementDefaultDimensionPopulator.java:110)
at org.hisp.dhis.system.startup.TransactionContextStartupRoutine$1.doInTransaction(TransactionContextStartupRoutine.java:57)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
at org.hisp.dhis.system.startup.TransactionContextStartupRoutine.execute(TransactionContextStartupRoutine.java:52)
at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:113)
at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:70)
at org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:71)
at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:798)
at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:444)
at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:789)
at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:294)
at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1343)
at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1336)
at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:741)
at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:499)
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.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
at org.hisp.dhis.WebAppServer.run(WebAppServer.java:92)
Caused by: org.postgresql.util.PSQLException: ERROR: column usercreden1_.uid does not exist
Position: 756
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:200)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:161)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70)
... 68 more
(StartupListener.java [Thread-2])
* INFO 2016-10-17 22:07:07,345 De-registering jdbc driver: org.h2.Driver@ef53c4 (StartupListener.java [AWT-EventQueue-0])
* INFO 2016-10-17 22:07:07,345 De-registering jdbc driver: com.mysql.jdbc.Driver@100dc55 (StartupListener.java [AWT-EventQueue-0])
* INFO 2016-10-17 22:07:07,345 De-registering jdbc driver: com.mysql.fabric.jdbc.FabricMySQLDriver@1ba76a4 (StartupListener.java [AWT-EventQueue-0])
* INFO 2016-10-17 22:07:07,345 De-registering jdbc driver: org.postgresql.Driver@1d851f8 (StartupListener.java [AWT-EventQueue-0])

Click here to view.

Tell a colleague about Piazza. It’s free, after all.

Thanks,
The Piazza Team

Contact us at team@piazza.com

You’re receiving this email because knutst@ifi.uio.no is enrolled in INF 5750 at The University of Oslo. Sign in to manage your email preferences or un-enroll from this class.
If you already have a Piazza account under another email address, link knutst@ifi.uio.no to that account here.

Cheers,
Knut Staring

–

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–

Morten Olav Hansen

Senior Engineer, DHIS 2

University of Oslo

http://www.dhis2.org

3

Hi,

it could be that someone jumped from dhis version 2.21 to 2.25 in one go on the same db. Try loading 2.23, then 2.25.

Lars

···

On Oct 24, 2016 5:05 AM, “Morten Olav Hansen” morten@dhis2.org wrote:

Maybe you should try and add that column manually?

Caused by: org.postgresql.util.PSQLException: ERROR: column usercreden1_.uid does not exist

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–

Morten Olav Hansen

Senior Engineer, DHIS 2

University of Oslo

http://www.dhis2.org

On Tue, Oct 18, 2016 at 4:17 AM, Knut Staring knutst@ifi.uio.no wrote:

Any idea what the issue could be here with DHIS Live?

---------- Forwarded message ----------
And this is conf/logs/dhis.log:

* INFO 2016-10-17 22:01:09,926 Added root logger using file: /D:/skule/inf5750/dhis-live/conf\logs\dhis.log (Log4JLogConfigInitializer.java [Thread-2])
* WARN 2016-10-17 22:01:10,947 RP discovery / realm validation disabled; (RealmVerifier.java [Thread-2])
* INFO 2016-10-17 22:01:13,701 SMS configuration not found (DefaultSmsConfigurationManager.java [Thread-2])
* INFO 2016-10-17 22:01:13,828 Scheduled task with key: fileResourceCleanupTask and cron: 0 0 2 * * ? (SpringScheduler.java [Thread-2])
* INFO 2016-10-17 22:01:13,829 Scheduled task with key: dataStatisticsTask and cron: 0 0 2 * * ? (SpringScheduler.java [Thread-2])
* INFO 2016-10-17 22:01:13,841 Executing startup routine [1 of 14, runlevel 1]: InitTableAlteror (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO 2016-10-17 22:01:20,688 Executing startup routine [2 of 14, runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO 2016-10-17 22:01:20,739 Executing startup routine [3 of 14, runlevel 3]: DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO 2016-10-17 22:01:20,876 'system-process' update org.hisp.dhis.dataelement.DataElementCategory, name: default, uid: vGs6omsRekv (AuditLogUtil.java [Thread-2])
* WARN 2016-10-17 22:01:21,256 SQL Error: 0, SQLState: 42703 (SqlExceptionHelper.java [Thread-2])
* ERROR 2016-10-17 22:01:21,257 ERROR: column usercreden1_.uid does not exist
Position: 756 (SqlExceptionHelper.java [Thread-2])
* ERROR 2016-10-17 22:01:21,265 org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.getResultSet(AbstractLoadPlanBasedLoader.java:434)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:186)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:121)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:86)
at [org.hibernate.loader.entity.pl](http://org.hibernate.loader.entity.pl)an.AbstractLoadPlanBasedEntityLoader.load(AbstractLoadPlanBasedEntityLoader.java:167)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3991)
at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:508)
at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:478)
at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:219)
at org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:262)
at org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:121)
at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:89)
at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1142)
at org.hibernate.internal.SessionImpl.internalLoad(SessionImpl.java:1025)
at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:632)
at org.hibernate.type.EntityType.resolve(EntityType.java:424)
at org.hibernate.engine.internal.TwoPhaseLoad.doInitializeEntity(TwoPhaseLoad.java:151)
at org.hibernate.engine.internal.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:125)
at [org.hibernate.loader.Loader.in](http://org.hibernate.loader.Loader.in)itializeEntitiesAndCollections(Loader.java:1132)
at [org.hibernate.loader.Loader.pr](http://org.hibernate.loader.Loader.pr)ocessResultSet(Loader.java:992)
at [org.hibernate.loader.Loader.do](http://org.hibernate.loader.Loader.do)Query(Loader.java:930)
at [org.hibernate.loader.Loader.do](http://org.hibernate.loader.Loader.do)QueryAndInitializeNonLazyCollections(Loader.java:336)
at [org.hibernate.loader.Loader.do](http://org.hibernate.loader.Loader.do)List(Loader.java:2610)
at [org.hibernate.loader.Loader.li](http://org.hibernate.loader.Loader.li)stUsingQueryCache(Loader.java:2452)
at [org.hibernate.loader.Loader.li](http://org.hibernate.loader.Loader.li)st(Loader.java:2414)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:109)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1787)
at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:363)
at org.hisp.dhis.hibernate.HibernateGenericStore.getAll(HibernateGenericStore.java:517)
at org.hisp.dhis.dataelement.DefaultDataElementService.getAllDataElements(DefaultDataElementService.java:122)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
at com.sun.proxy.$Proxy78.getAllDataElements(Unknown Source)
at org.hisp.dhis.dataelement.DataElementDefaultDimensionPopulator.executeInTransaction(DataElementDefaultDimensionPopulator.java:110)
at org.hisp.dhis.system.startup.TransactionContextStartupRoutine$1.doInTransaction(TransactionContextStartupRoutine.java:57)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
at org.hisp.dhis.system.startup.TransactionContextStartupRoutine.execute(TransactionContextStartupRoutine.java:52)
at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:113)
at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:70)
at org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:71)
at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:798)
at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:444)
at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:789)
at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:294)
at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1343)
at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1336)
at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:741)
at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:499)
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.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
at org.hisp.dhis.WebAppServer.run(WebAppServer.java:92)
Caused by: org.postgresql.util.PSQLException: ERROR: column usercreden1_.uid does not exist
Position: 756
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:200)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:161)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70)
... 68 more
(StartupListener.java [Thread-2])
* INFO 2016-10-17 22:07:07,345 De-registering jdbc driver: org.h2.Driver@ef53c4 (StartupListener.java [AWT-EventQueue-0])
* INFO 2016-10-17 22:07:07,345 De-registering jdbc driver: com.mysql.jdbc.Driver@100dc55 (StartupListener.java [AWT-EventQueue-0])
* INFO 2016-10-17 22:07:07,345 De-registering jdbc driver: com.mysql.fabric.jdbc.FabricMySQLDriver@1ba76a4 (StartupListener.java [AWT-EventQueue-0])
* INFO 2016-10-17 22:07:07,345 De-registering jdbc driver: org.postgresql.Driver@1d851f8 (StartupListener.java [AWT-EventQueue-0])

Click here to view.

Tell a colleague about Piazza. It’s free, after all.

Thanks,
The Piazza Team

Contact us at team@piazza.com

You’re receiving this email because knutst@ifi.uio.no is enrolled in INF 5750 at The University of Oslo. Sign in to manage your email preferences or un-enroll from this class.
If you already have a Piazza account under another email address, link knutst@ifi.uio.no to that account here.

Cheers,
Knut Staring

–

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

4

Thsnks, was mismatch between .war and demo db version.

···

On Oct 24, 2016 6:35 AM, “Lars Helge Øverland” lars@dhis2.org wrote:

Hi,

it could be that someone jumped from dhis version 2.21 to 2.25 in one go on the same db. Try loading 2.23, then 2.25.

Lars

On Oct 24, 2016 5:05 AM, “Morten Olav Hansen” morten@dhis2.org wrote:

Maybe you should try and add that column manually?

Caused by: org.postgresql.util.PSQLException: ERROR: column usercreden1_.uid does not exist

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–

Morten Olav Hansen

Senior Engineer, DHIS 2

University of Oslo

http://www.dhis2.org

On Tue, Oct 18, 2016 at 4:17 AM, Knut Staring knutst@ifi.uio.no wrote:

Any idea what the issue could be here with DHIS Live?

---------- Forwarded message ----------
And this is conf/logs/dhis.log:

* INFO 2016-10-17 22:01:09,926 Added root logger using file: /D:/skule/inf5750/dhis-live/conf\logs\dhis.log (Log4JLogConfigInitializer.java [Thread-2])
* WARN 2016-10-17 22:01:10,947 RP discovery / realm validation disabled; (RealmVerifier.java [Thread-2])
* INFO 2016-10-17 22:01:13,701 SMS configuration not found (DefaultSmsConfigurationManager.java [Thread-2])
* INFO 2016-10-17 22:01:13,828 Scheduled task with key: fileResourceCleanupTask and cron: 0 0 2 * * ? (SpringScheduler.java [Thread-2])
* INFO 2016-10-17 22:01:13,829 Scheduled task with key: dataStatisticsTask and cron: 0 0 2 * * ? (SpringScheduler.java [Thread-2])
* INFO 2016-10-17 22:01:13,841 Executing startup routine [1 of 14, runlevel 1]: InitTableAlteror (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO 2016-10-17 22:01:20,688 Executing startup routine [2 of 14, runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO 2016-10-17 22:01:20,739 Executing startup routine [3 of 14, runlevel 3]: DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO 2016-10-17 22:01:20,876 'system-process' update org.hisp.dhis.dataelement.DataElementCategory, name: default, uid: vGs6omsRekv (AuditLogUtil.java [Thread-2])
* WARN 2016-10-17 22:01:21,256 SQL Error: 0, SQLState: 42703 (SqlExceptionHelper.java [Thread-2])
* ERROR 2016-10-17 22:01:21,257 ERROR: column usercreden1_.uid does not exist
Position: 756 (SqlExceptionHelper.java [Thread-2])
* ERROR 2016-10-17 22:01:21,265 org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.getResultSet(AbstractLoadPlanBasedLoader.java:434)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:186)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:121)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:86)
at [org.hibernate.loader.entity.pl](http://org.hibernate.loader.entity.pl)an.AbstractLoadPlanBasedEntityLoader.load(AbstractLoadPlanBasedEntityLoader.java:167)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3991)
at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:508)
at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:478)
at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:219)
at org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:262)
at org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:121)
at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:89)
at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1142)
at org.hibernate.internal.SessionImpl.internalLoad(SessionImpl.java:1025)
at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:632)
at org.hibernate.type.EntityType.resolve(EntityType.java:424)
at org.hibernate.engine.internal.TwoPhaseLoad.doInitializeEntity(TwoPhaseLoad.java:151)
at org.hibernate.engine.internal.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:125)
at [org.hibernate.loader.Loader.in](http://org.hibernate.loader.Loader.in)itializeEntitiesAndCollections(Loader.java:1132)
at [org.hibernate.loader.Loader.pr](http://org.hibernate.loader.Loader.pr)ocessResultSet(Loader.java:992)
at [org.hibernate.loader.Loader.do](http://org.hibernate.loader.Loader.do)Query(Loader.java:930)
at [org.hibernate.loader.Loader.do](http://org.hibernate.loader.Loader.do)QueryAndInitializeNonLazyCollections(Loader.java:336)
at [org.hibernate.loader.Loader.do](http://org.hibernate.loader.Loader.do)List(Loader.java:2610)
at [org.hibernate.loader.Loader.li](http://org.hibernate.loader.Loader.li)stUsingQueryCache(Loader.java:2452)
at [org.hibernate.loader.Loader.li](http://org.hibernate.loader.Loader.li)st(Loader.java:2414)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:109)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1787)
at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:363)
at org.hisp.dhis.hibernate.HibernateGenericStore.getAll(HibernateGenericStore.java:517)
at org.hisp.dhis.dataelement.DefaultDataElementService.getAllDataElements(DefaultDataElementService.java:122)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
at com.sun.proxy.$Proxy78.getAllDataElements(Unknown Source)
at org.hisp.dhis.dataelement.DataElementDefaultDimensionPopulator.executeInTransaction(DataElementDefaultDimensionPopulator.java:110)
at org.hisp.dhis.system.startup.TransactionContextStartupRoutine$1.doInTransaction(TransactionContextStartupRoutine.java:57)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
at org.hisp.dhis.system.startup.TransactionContextStartupRoutine.execute(TransactionContextStartupRoutine.java:52)
at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:113)
at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:70)
at org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:71)
at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:798)
at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:444)
at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:789)
at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:294)
at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1343)
at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1336)
at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:741)
at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:499)
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.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
at org.hisp.dhis.WebAppServer.run(WebAppServer.java:92)
Caused by: org.postgresql.util.PSQLException: ERROR: column usercreden1_.uid does not exist
Position: 756
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:200)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:161)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70)
... 68 more
(StartupListener.java [Thread-2])
* INFO 2016-10-17 22:07:07,345 De-registering jdbc driver: org.h2.Driver@ef53c4 (StartupListener.java [AWT-EventQueue-0])
* INFO 2016-10-17 22:07:07,345 De-registering jdbc driver: com.mysql.jdbc.Driver@100dc55 (StartupListener.java [AWT-EventQueue-0])
* INFO 2016-10-17 22:07:07,345 De-registering jdbc driver: com.mysql.fabric.jdbc.FabricMySQLDriver@1ba76a4 (StartupListener.java [AWT-EventQueue-0])
* INFO 2016-10-17 22:07:07,345 De-registering jdbc driver: org.postgresql.Driver@1d851f8 (StartupListener.java [AWT-EventQueue-0])

Click here to view.

Tell a colleague about Piazza. It’s free, after all.

Thanks,
The Piazza Team

Contact us at team@piazza.com

You’re receiving this email because knutst@ifi.uio.no is enrolled in INF 5750 at The University of Oslo. Sign in to manage your email preferences or un-enroll from this class.
If you already have a Piazza account under another email address, link knutst@ifi.uio.no to that account here.

Cheers,
Knut Staring

–

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp