dhis2-users team mailing list archive

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

To: "dhis2-users@xxxxxxxxxxxxxxxxxxx" <dhis2-users@xxxxxxxxxxxxxxxxxxx>
From: Knut Staring <knutst@xxxxxxxxxx>
Date: Mon, 17 Oct 2016 23:17:18 +0200
In-reply-to: <1798368795.523863.1476738647925.JavaMail.ec2-user@appserver-01.piazza.com>
Sender: knutst@xxxxxxxxx
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.plan.AbstractLoadPlanBasedEntityLoa
der.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.initializeEntitiesAndCollectio
ns(Loader.java:1132)
    at org.hibernate.loader.Loader.processResultSet(Loader.java:992)
    at org.hibernate.loader.Loader.doQuery(Loader.java:930)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCol
lections(Loader.java:336)
    at org.hibernate.loader.Loader.doList(Loader.java:2610)
    at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2452)
    at org.hibernate.loader.Loader.list(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.DataElementDefaultDimensionPop
ulator.executeInTransaction(DataElementDefaultDimensionPopulator.java:110)
    at org.hisp.dhis.system.startup.TransactionContextStartupRouti
ne$1.doInTransaction(TransactionContextStartupRoutine.java:57)
    at org.springframework.transaction.support.TransactionTemplate.execute(
TransactionTemplate.java:133)
    at org.hisp.dhis.system.startup.TransactionContextStartupRouti
ne.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
<https://piazza.com/class?cid=iueifbq81dva5&nid=isfwaws3kkj5js&token=FLOYmKxzBD7>
to view.

------------------------------

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


Thanks,
The Piazza Team
--
Contact us at team@xxxxxxxxxx

You're receiving this email because knutst@xxxxxxxxxx is enrolled in INF
5750 at The University of Oslo. Sign in <https://piazza.com/login> to
manage your email preferences or un-enroll
<https://piazza.com/remove/FLOYmKxzBD7/isfwaws3kkj5js> from this class.
If you already have a Piazza account under another email address, link
knutst@xxxxxxxxxx to that account here
<https://piazza.com/link_accounts/FLOYmKxzBD7>.



-- 
Cheers,
Knut Staring
Follow ups

Re: Fwd: Activity Digest since 10:24PM for INF 5750 on Piazza
From: Morten Olav Hansen, 2016-10-24