Re: [Dhis2-users] Fwd: Activity Digest since 10:24PM for INF 5750 on Piazza
Thsnks, was mismatch between .war and demo db version. On Oct 24, 2016 6:35 AM, "Lars Helge Øverland" 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" 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 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.engin
Re: [Dhis2-users] Fwd: Activity Digest since 10:24PM for INF 5750 on Piazza
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" 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 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.ja
Re: [Dhis2-users] Fwd: Activity Digest since 10:24PM for INF 5750 on Piazza
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 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
[Dhis2-users] Fwd: Activity Digest since 10:24PM for INF 5750 on Piazza
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. getAllDataEleme
