Thsnks, was mismatch between .war and demo db version. On Oct 24, 2016 6:35 AM, "Lars Helge Ă˜verland" <l...@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" <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