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 <[email protected]> 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( > 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.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 [email protected] > > You're receiving this email because [email protected] 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 > [email protected] to that account here > <https://piazza.com/link_accounts/FLOYmKxzBD7>. > > > > -- > Cheers, > Knut Staring > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
