dhis2-users team mailing list archive

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

To: Lars Helge Øverland <lars@xxxxxxxxx>
From: Knut Staring <knutst@xxxxxxxxxx>
Date: Mon, 24 Oct 2016 07:12:08 +0200
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx
In-reply-to: <CAD_DPKzmo=K+PJfHkoQt-LHE_V2gJpaALNdNAfxW5-69i7Khmg@mail.gmail.com>
Sender: knutst@xxxxxxxxx
Thsnks,  was mismatch between .war and demo db version.

On Oct 24, 2016 6:35 AM, "Lars Helge Øverland" <lars@xxxxxxxxx> 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@xxxxxxxxx> wrote:
>
>> Caused by: org.postgresql.util.PSQLException: ERROR: column
>> usercreden1_.uid does not exist
>>
>> Maybe you should try and add that column manually?
>>
>> --
>> 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@xxxxxxxxxx> 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.StandardSQLExceptionConvert
>>> er.convert(StandardSQLExceptionConverter.java:42)
>>>     at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(Sql
>>> ExceptionHelper.java:111)
>>>     at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(Sql
>>> ExceptionHelper.java:97)
>>>     at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extra
>>> ct(ResultSetReturnImpl.java:79)
>>>     at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBase
>>> dLoader.getResultSet(AbstractLoadPlanBasedLoader.java:434)
>>>     at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBase
>>> dLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:186)
>>>     at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBase
>>> dLoader.executeLoad(AbstractLoadPlanBasedLoader.java:121)
>>>     at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBase
>>> dLoader.executeLoad(AbstractLoadPlanBasedLoader.java:86)
>>>     at org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntity
>>> Loader.load(AbstractLoadPlanBasedEntityLoader.java:167)
>>>     at org.hibernate.persister.entity.AbstractEntityPersister.load(
>>> AbstractEntityPersister.java:3991)
>>>     at org.hibernate.event.internal.DefaultLoadEventListener.loadFr
>>> omDatasource(DefaultLoadEventListener.java:508)
>>>     at org.hibernate.event.internal.DefaultLoadEventListener.doLoad
>>> (DefaultLoadEventListener.java:478)
>>>     at org.hibernate.event.internal.DefaultLoadEventListener.load(D
>>> efaultLoadEventListener.java:219)
>>>     at org.hibernate.event.internal.DefaultLoadEventListener.proxyO
>>> rLoad(DefaultLoadEventListener.java:262)
>>>     at org.hibernate.event.internal.DefaultLoadEventListener.doOnLo
>>> ad(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.j
>>> ava:632)
>>>     at org.hibernate.type.EntityType.resolve(EntityType.java:424)
>>>     at org.hibernate.engine.internal.TwoPhaseLoad.doInitializeEntit
>>> y(TwoPhaseLoad.java:151)
>>>     at org.hibernate.engine.internal.TwoPhaseLoad.initializeEntity(
>>> TwoPhaseLoad.java:125)
>>>     at org.hibernate.loader.Loader.initializeEntitiesAndCollections
>>> (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.doQueryAndInitializeNonLazyColle
>>> ctions(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(CriteriaLo
>>> ader.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(Hiberna
>>> teGenericStore.java:517)
>>>     at org.hisp.dhis.dataelement.DefaultDataElementService.getAllDa
>>> taElements(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.invokeJoinpointUsin
>>> gReflection(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.TransactionInter
>>> ceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
>>>     at org.springframework.transaction.interceptor.TransactionAspec
>>> tSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
>>>     at org.springframework.transaction.interceptor.TransactionInter
>>> ceptor.invoke(TransactionInterceptor.java:96)
>>>     at org.springframework.aop.framework.ReflectiveMethodInvocation
>>> .proceed(ReflectiveMethodInvocation.java:179)
>>>     at org.springframework.aop.interceptor.ExposeInvocationIntercep
>>> tor.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.DataElementDefaultDimensionPopulat
>>> or.executeInTransaction(DataElementDefaultDimensionPopulator.java:110)
>>>     at org.hisp.dhis.system.startup.TransactionContextStartupRoutin
>>> e$1.doInTransaction(TransactionContextStartupRoutine.java:57)
>>>     at org.springframework.transaction.support.TransactionTemplate.
>>> execute(TransactionTemplate.java:133)
>>>     at org.hisp.dhis.system.startup.TransactionContextStartupRoutin
>>> e.execute(TransactionContextStartupRoutine.java:52)
>>>     at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.e
>>> xecute(DefaultStartupRoutineExecutor.java:113)
>>>     at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.e
>>> xecute(DefaultStartupRoutineExecutor.java:70)
>>>     at org.hisp.dhis.system.startup.StartupListener.contextInitiali
>>> zed(StartupListener.java:71)
>>>     at org.eclipse.jetty.server.handler.ContextHandler.callContextI
>>> nitialized(ContextHandler.java:798)
>>>     at org.eclipse.jetty.servlet.ServletContextHandler.callContextI
>>> nitialized(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(WebAppCon
>>> text.java:1343)
>>>     at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppCo
>>> ntext.java:1336)
>>>     at org.eclipse.jetty.server.handler.ContextHandler.doStart(Cont
>>> extHandler.java:741)
>>>     at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext
>>> .java:499)
>>>     at org.eclipse.jetty.util.component.AbstractLifeCycle.start(Abs
>>> tractLifeCycle.java:68)
>>>     at org.eclipse.jetty.util.component.ContainerLifeCycle.start(Co
>>> ntainerLifeCycle.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(Abs
>>> tractHandler.java:61)
>>>     at org.eclipse.jetty.server.Server.doStart(Server.java:354)
>>>     at org.eclipse.jetty.util.component.AbstractLifeCycle.start(Abs
>>> tractLifeCycle.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.receiveErrorRespons
>>> e(QueryExecutorImpl.java:2284)
>>>     at org.postgresql.core.v3.QueryExecutorImpl.processResults(Quer
>>> yExecutorImpl.java:2003)
>>>     at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecut
>>> orImpl.java:200)
>>>     at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424)
>>>     at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgP
>>> reparedStatement.java:161)
>>>     at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPrepa
>>> redStatement.java:114)
>>>     at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQu
>>> ery(NewProxyPreparedStatement.java:76)
>>>     at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extra
>>> ct(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
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
References

Fwd: Activity Digest since 10:24PM for INF 5750 on Piazza
From: Knut Staring, 2016-10-17
Re: Fwd: Activity Digest since 10:24PM for INF 5750 on Piazza
From: Morten Olav Hansen, 2016-10-24
Re: Fwd: Activity Digest since 10:24PM for INF 5750 on Piazza
From: Lars Helge Øverland, 2016-10-24