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" <mor...@dhis2.org> 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 <knu...@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.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 t...@piazza.com >> >> You're receiving this email because knu...@ifi.uio.no 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 >> knu...@ifi.uio.no to that account here >> <https://piazza.com/link_accounts/FLOYmKxzBD7>. >> >> >> >> -- >> 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 >> >> > > _______________________________________________ > 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 > >
_______________________________________________ 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
