← Back to team overview

dhis2-devs team mailing list archive

Re: [Bug 1487121] Re: tomcat is not displaying dhis on web browser

 

Thank you Lars.Problem solved

On 8/25/15, Lars Helge Øverland <larshelge@xxxxxxxxx> wrote:
> Hi Mohamed,
>
> there is a column which maps to a java boolean field which has a null value
> for en existing row. Try this SQL:
>
> update dataelementcategory set datadimension = false where datadimension is
> null;
>
> Then restart the server.
>
>
> Lars
>
>
> On Tue, Aug 25, 2015 at 4:17 AM, Mohamed Bangura <mbangs87@xxxxxxxxx>
> wrote:
>
>> can someone please help me with this issue?.It's really frustrating
>> because i think that i have done the right thing yet still i am not
>> receiving the desired result.
>>
>> Waiting for your response please,it's urgent.Thanks in advance for your
>> help.
>>
>> --
>> You received this bug notification because you are a member of DHIS 2
>> developers, which is subscribed to DHIS.
>> https://bugs.launchpad.net/bugs/1487121
>>
>> Title:
>>   tomcat is not displaying dhis on web browser
>>
>> Status in DHIS:
>>   New
>>
>> Bug description:
>>   Hello all,
>>
>>   I am trying to install Dhis on ubuntu desktop 14.04.I av installed
>>   tomcat,java and copied the war file to webapps.The tomcat starts well
>>   and deploys the war file.
>>
>>   But when i try to access the dhis from my webbrowser,it gives the
>>   error below
>>
>>   HTTP Status 404 - /dhis
>>
>>   type Status report
>>
>>   message /dhis
>>
>>   description The requested resource is not available.
>>
>>   Apache Tomcat/7.0.42
>>
>>   I have tried it on several browsers,its the same thing.Can someone
>>   please help me ?
>>
>>   This is a snap shot of the catalina.out result of the tomcat
>>
>>   Aug 20, 2015 4:21:00 PM org.apache.coyote.AbstractProtocol init
>>   INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
>>   Aug 20, 2015 4:21:00 PM org.apache.catalina.startup.Catalina load
>>   INFO: Initialization processed in 375 ms
>>   Aug 20, 2015 4:21:01 PM org.apache.catalina.core.StandardService
>> startInternal
>>   INFO: Starting service Catalina
>>   Aug 20, 2015 4:21:01 PM org.apache.catalina.core.StandardEngine
>> startInternal
>>   INFO: Starting Servlet Engine: Apache Tomcat/7.0.42
>>   Aug 20, 2015 4:21:01 PM org.apache.catalina.startup.HostConfig
>> deployWAR
>>   INFO: Deploying web application archive
>> /usr/share/apache-tomcat-7.0.42/webapps/dhis.war
>>   * INFO  2015-08-20 16:21:11,055 System property dhis2.home not set
>> (DefaultLocationManager.java [localhost-startStop-1])
>>   * INFO  2015-08-20 16:21:11,057 Environment variable DHIS2_HOME points
>> to /home/inveneo/DHIS2_HOME/dhis (DefaultLocationManager.java
>> [localhost-startStop-1])
>>   * INFO  2015-08-20 16:21:12,083 Hibernate configuration loaded, using
>> dialect: org.hibernate.dialect.PostgreSQLDialect
>> (DefaultHibernateConfigurationProvider.java [localhost-startStop-1])
>>   * ERROR 2015-08-20 16:21:22,179 HHH000388: Unsuccessful: alter table
>> completedatasetregistration add column attributeoptioncomboid int4 not
>> null
>> (SchemaUpdate.java [localhost-startStop-1])
>>   * ERROR 2015-08-20 16:21:22,181 ERROR: column "attributeoptioncomboid"
>> contains null values (SchemaUpdate.java [localhost-startStop-1])
>>   * ERROR 2015-08-20 16:21:22,185 HHH000388: Unsuccessful: alter table
>> datavalue add column attributeoptioncomboid int4 not null
>> (SchemaUpdate.java [localhost-startStop-1])
>>   * ERROR 2015-08-20 16:21:22,187 ERROR: column "attributeoptioncomboid"
>> contains null values (SchemaUpdate.java [localhost-startStop-1])
>>   * ERROR 2015-08-20 16:21:22,190 HHH000388: Unsuccessful: alter table
>> minmaxdataelement add column minimumvalue int4 not null
>> (SchemaUpdate.java
>> [localhost-startStop-1])
>>   * ERROR 2015-08-20 16:21:22,191 ERROR: column "minimumvalue" contains
>> null values (SchemaUpdate.java [localhost-startStop-1])
>>   * ERROR 2015-08-20 16:21:22,194 HHH000388: Unsuccessful: alter table
>> minmaxdataelement add column maximumvalue int4 not null
>> (SchemaUpdate.java
>> [localhost-startStop-1])
>>   * ERROR 2015-08-20 16:21:22,195 ERROR: column "maximumvalue" contains
>> null values (SchemaUpdate.java [localhost-startStop-1])
>>   * ERROR 2015-08-20 16:21:22,199 HHH000388: Unsuccessful: alter table
>> translation add column translationid int4 not null (SchemaUpdate.java
>> [localhost-startStop-1])
>>   * ERROR 2015-08-20 16:21:22,199 ERROR: column "translationid" contains
>> null values (SchemaUpdate.java [localhost-startStop-1])
>>   * ERROR 2015-08-20 16:21:22,202 HHH000388: Unsuccessful: alter table
>> completedatasetregistration add constraint
>> fk_completedatasetregistration_attributeoptioncomboid foreign key
>> (attributeoptioncomboid) references categoryoptioncombo
>> (SchemaUpdate.java
>> [localhost-startStop-1])
>>   * ERROR 2015-08-20 16:21:22,203 ERROR: column "attributeoptioncomboid"
>> referenced in foreign key constraint does not exist (SchemaUpdate.java
>> [localhost-startStop-1])
>>   * ERROR 2015-08-20 16:21:22,206 HHH000388: Unsuccessful: alter table
>> datavalue add constraint fk_datavalue_attributeoptioncomboid foreign key
>> (attributeoptioncomboid) references categoryoptioncombo
>> (SchemaUpdate.java
>> [localhost-startStop-1])
>>   * ERROR 2015-08-20 16:21:22,208 ERROR: column "attributeoptioncomboid"
>> referenced in foreign key constraint does not exist (SchemaUpdate.java
>> [localhost-startStop-1])
>>   * ERROR 2015-08-20 16:21:22,210 HHH000388: Unsuccessful: alter table
>> programstage add constraint fk_programstage_dataentryform foreign key
>> (dataentryformid) references dataentryform (SchemaUpdate.java
>> [localhost-startStop-1])
>>   * ERROR 2015-08-20 16:21:22,211 ERROR: constraint
>> "fk_programstage_dataentryform" for relation "programstage" already
>> exists
>> (SchemaUpdate.java [localhost-startStop-1])
>>   * ERROR 2015-08-20 16:21:22,215 HHH000388: Unsuccessful: alter table
>> sqlviewusergroupaccesses add constraint FK_ftn43gpevax8by169pld7dl5d
>> foreign key (sqlviewid) references sqlview (SchemaUpdate.java
>> [localhost-startStop-1])
>>   * ERROR 2015-08-20 16:21:22,216 ERROR: constraint
>> "fk_ftn43gpevax8by169pld7dl5d" for relation "sqlviewusergroupaccesses"
>> already exists (SchemaUpdate.java [localhost-startStop-1])
>>   * ERROR 2015-08-20 16:21:22,219 HHH000388: Unsuccessful: alter table
>> validationrulegroupmembers add constraint
>> fk_validationrulegroupmembers_validationrulegroupid foreign key
>> (validationgroupid) references validationrulegroup (SchemaUpdate.java
>> [localhost-startStop-1])
>>   * ERROR 2015-08-20 16:21:22,221 ERROR: constraint
>> "fk_validationrulegroupmembers_validationrulegroupid" for relation
>> "validationrulegroupmembers" already exists (SchemaUpdate.java
>> [localhost-startStop-1])
>>   * ERROR 2015-08-20 16:21:22,224 HHH000388: Unsuccessful: alter table
>> validationrulegroupusergroupaccesses add constraint
>> FK_932w5l8vbyvybhsrwwadjd3cp foreign key (validationrulegroupid)
>> references
>> validationrulegroup (SchemaUpdate.java [localhost-startStop-1])
>>   * ERROR 2015-08-20 16:21:22,225 ERROR: constraint
>> "fk_932w5l8vbyvybhsrwwadjd3cp" for relation
>> "validationrulegroupusergroupaccesses" already exists (SchemaUpdate.java
>> [localhost-startStop-1])
>>   * ERROR 2015-08-20 16:21:22,228 HHH000388: Unsuccessful: alter table
>> validationrulegroupusergroupstoalert add constraint
>> fk_validationrulegroupusergroupstoalert_validationgroupid foreign key
>> (validationgroupid) references validationrulegroup (SchemaUpdate.java
>> [localhost-startStop-1])
>>   * ERROR 2015-08-20 16:21:22,229 ERROR: constraint
>> "fk_validationrulegroupusergroupstoalert_validationgroupid" for relation
>> "validationrulegroupusergroupstoalert" already exists (SchemaUpdate.java
>> [localhost-startStop-1])
>>   * INFO  2015-08-20 16:21:26,000 Found the following message senders:
>> [org.hisp.dhis.message.EmailMessageSender@7c267dd0,
>> org.hisp.dhis.sms.SmsMessageSender@615318b9] (DefaultMessageService.java
>> [localhost-startStop-1])
>>   * INFO  2015-08-20 16:21:31,908 Detected apps: []
>> (DefaultAppManager.java [localhost-startStop-1])
>>   * INFO  2015-08-20 16:21:33,190 Added logger:
>> org.hisp.dhis.resourcetable using file:
>> /home/inveneo/DHIS2_HOME/dhis/logs/dhis-analytics-table.log
>> (Log4JLogConfigInitializer.java [localhost-startStop-1])
>>   * INFO  2015-08-20 16:21:33,191 Added logger:
>> org.hisp.dhis.analytics.table using file:
>> /home/inveneo/DHIS2_HOME/dhis/logs/dhis-analytics-table.log
>> (Log4JLogConfigInitializer.java [localhost-startStop-1])
>>   * INFO  2015-08-20 16:21:33,191 Added logger: org.hisp.dhis.dxf2 using
>> file: /home/inveneo/DHIS2_HOME/dhis/logs/dhis-data-exchange.log
>> (Log4JLogConfigInitializer.java [localhost-startStop-1])
>>   * INFO  2015-08-20 16:21:33,191 Added logger: org.hisp.dhis.dxf2.synch
>> using file: /home/inveneo/DHIS2_HOME/dhis/logs/dhis-data-sync.log
>> (Log4JLogConfigInitializer.java [localhost-startStop-1])
>>   * INFO  2015-08-20 16:21:33,192 Added root logger using file:
>> /home/inveneo/DHIS2_HOME/dhis/logs/dhis.log
>> (Log4JLogConfigInitializer.java
>> [localhost-startStop-1])
>>   * WARN  2015-08-20 16:21:33,724 RP discovery / realm validation
>> disabled;  (RealmVerifier.java [localhost-startStop-1])
>>   * INFO  2015-08-20 16:21:34,751 Executing startup routine [1 of 14,
>> runlevel 1]: InitTableAlteror (DefaultStartupRoutineExecutor.java
>> [localhost-startStop-1])
>>   * INFO  2015-08-20 16:21:34,950 Upgraded program stage data elements
>> (InitTableAlteror.java [localhost-startStop-1])
>>   * INFO  2015-08-20 16:21:34,951 Executing startup routine [2 of 14,
>> runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java
>> [localhost-startStop-1])
>>   * INFO  2015-08-20 16:21:34,969 Executing startup routine [3 of 14,
>> runlevel 2]: DataElementDefaultDimensionPopulator
>> (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
>>   * ERROR 2015-08-20 16:21:34,986 org.hibernate.PropertyAccessException:
>> Null value was assigned to a property of primitive type setter of
>> org.hisp.dhis.common.BaseDimensionalObject.dataDimension
>>         at
>> org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:108)
>>         at
>> org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:710)
>>         at
>> org.hibernate.tuple.entity.PojoEntityTuplizer.setPropertyValues(PojoEntityTuplizer.java:379)
>>         at
>> org.hibernate.persister.entity.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:4522)
>>         at
>> org.hibernate.engine.internal.TwoPhaseLoad.doInitializeEntity(TwoPhaseLoad.java:186)
>>         at
>> org.hibernate.engine.internal.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:137)
>>         at
>> org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:1112)
>>         at org.hibernate.loader.Loader.processResultSet(Loader.java:969)
>>         at org.hibernate.loader.Loader.doQuery(Loader.java:917)
>>         at
>> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348)
>>         at org.hibernate.loader.Loader.doList(Loader.java:2550)
>>         at
>> org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2395)
>>         at org.hibernate.loader.Loader.list(Loader.java:2358)
>>         at
>> org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:124)
>>         at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1623)
>>         at
>> org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:374)
>>         at
>> org.hisp.dhis.common.hibernate.HibernateIdentifiableObjectStore.getAllEqName(HibernateIdentifiableObjectStore.java:180)
>>         at
>> org.hisp.dhis.dataelement.DefaultDataElementCategoryService.getDataElementCategoryByName(DefaultDataElementCategoryService.java:212)
>>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>         at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>>         at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>         at java.lang.reflect.Method.invoke(Method.java:606)
>>         at
>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
>>         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.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
>>         at
>> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
>>         at
>> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
>>         at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
>>         at
>> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
>>         at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
>>         at
>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
>>         at com.sun.proxy.$Proxy38.getDataElementCategoryByName(Unknown
>> Source)
>>         at
>> org.hisp.dhis.dataelement.DataElementDefaultDimensionPopulator.execute(DataElementDefaultDimensionPopulator.java:82)
>>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>         at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>>         at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>         at java.lang.reflect.Method.invoke(Method.java:606)
>>         at
>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
>>         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.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
>>         at
>> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
>>         at
>> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
>>         at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
>>         at
>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
>>         at com.sun.proxy.$Proxy84.execute(Unknown Source)
>>         at
>> org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:119)
>>         at
>> org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:88)
>>         at
>> org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:68)
>>         at
>> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4939)
>>         at
>> org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5434)
>>         at
>> org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
>>         at
>> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
>>         at
>> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
>>         at
>> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
>>         at
>> org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:976)
>>         at
>> org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1653)
>>         at
>> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
>>         at
>> java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
>>         at java.util.concurrent.FutureTask.run(FutureTask.java:166)
>>         at
>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>>         at
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>>         at java.lang.Thread.run(Thread.java:724)
>>   Caused by: java.lang.IllegalArgumentException
>>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>         at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>>         at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>         at java.lang.reflect.Method.invoke(Method.java:606)
>>         at
>> org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:65)
>>         ... 63 more
>>    (StartupListener.java [localhost-startStop-1])
>>   Aug 20, 2015 4:21:34 PM org.apache.catalina.core.StandardContext
>> startInternal
>>   SEVERE: Error listenerStart
>>   Aug 20, 2015 4:21:34 PM org.apache.catalina.core.StandardContext
>> startInternal
>>   SEVERE: Context [/dhis] startup failed due to previous errors
>>   * INFO  2015-08-20 16:21:34,993 De-registering jdbc driver:
>> sun.jdbc.odbc.JdbcOdbcDriver@1629bc56 (StartupListener.java
>> [localhost-startStop-1])
>>   * INFO  2015-08-20 16:21:34,993 De-registering jdbc driver:
>> org.postgresql.Driver@14c944d8 (StartupListener.java
>> [localhost-startStop-1])
>>   Aug 20, 2015 4:21:35 PM org.apache.catalina.loader.WebappClassLoader
>> checkThreadLocalMapForLeaks
>>   SEVERE: The web application [/dhis] created a ThreadLocal with key of
>> type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@726b1eee]) and
>> a value of type
>> [org.springframework.security.core.context.SecurityContextImpl] (value
>> [org.springframework.security.core.context.SecurityContextImpl@ffffffff:
>> Null authentication]) but failed to remove it when the web application
>> was
>> stopped. Threads are going to be renewed over time to try and avoid a
>> probable memory leak.
>>   Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig
>> deployDirectory
>>   INFO: Deploying web application directory
>> /usr/share/apache-tomcat-7.0.42/webapps/ROOT
>>   Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig
>> deployDirectory
>>   INFO: Deploying web application directory
>> /usr/share/apache-tomcat-7.0.42/webapps/host-manager
>>   Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig
>> deployDirectory
>>   INFO: Deploying web application directory
>> /usr/share/apache-tomcat-7.0.42/webapps/examples
>>   Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig
>> deployDirectory
>>   INFO: Deploying web application directory
>> /usr/share/apache-tomcat-7.0.42/webapps/manager
>>   Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig
>> deployDirectory
>>   INFO: Deploying web application directory
>> /usr/share/apache-tomcat-7.0.42/webapps/docs
>>   Aug 20, 2015 4:21:35 PM org.apache.coyote.AbstractProtocol start
>>   INFO: Starting ProtocolHandler ["http-bio-8080"]
>>   Aug 20, 2015 4:21:35 PM org.apache.coyote.AbstractProtocol start
>>   INFO: Starting ProtocolHandler ["ajp-bio-8009"]
>>   Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.Catalina start
>>   INFO: Server startup in 34288 ms
>>
>> To manage notifications about this bug go to:
>> https://bugs.launchpad.net/dhis2/+bug/1487121/+subscriptions
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> http://www.dhis2.org <https://www.dhis2.org>
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1487121
>
> Title:
>   tomcat is not displaying dhis on web browser
>
> Status in DHIS:
>   New
>
> Bug description:
>   Hello all,
>
>   I am trying to install Dhis on ubuntu desktop 14.04.I av installed
>   tomcat,java and copied the war file to webapps.The tomcat starts well
>   and deploys the war file.
>
>   But when i try to access the dhis from my webbrowser,it gives the
>   error below
>
>   HTTP Status 404 - /dhis
>
>   type Status report
>
>   message /dhis
>
>   description The requested resource is not available.
>
>   Apache Tomcat/7.0.42
>
>   I have tried it on several browsers,its the same thing.Can someone
>   please help me ?
>
>   This is a snap shot of the catalina.out result of the tomcat
>
>   Aug 20, 2015 4:21:00 PM org.apache.coyote.AbstractProtocol init
>   INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
>   Aug 20, 2015 4:21:00 PM org.apache.catalina.startup.Catalina load
>   INFO: Initialization processed in 375 ms
>   Aug 20, 2015 4:21:01 PM org.apache.catalina.core.StandardService
> startInternal
>   INFO: Starting service Catalina
>   Aug 20, 2015 4:21:01 PM org.apache.catalina.core.StandardEngine
> startInternal
>   INFO: Starting Servlet Engine: Apache Tomcat/7.0.42
>   Aug 20, 2015 4:21:01 PM org.apache.catalina.startup.HostConfig deployWAR
>   INFO: Deploying web application archive
> /usr/share/apache-tomcat-7.0.42/webapps/dhis.war
>   * INFO  2015-08-20 16:21:11,055 System property dhis2.home not set
> (DefaultLocationManager.java [localhost-startStop-1])
>   * INFO  2015-08-20 16:21:11,057 Environment variable DHIS2_HOME points to
> /home/inveneo/DHIS2_HOME/dhis (DefaultLocationManager.java
> [localhost-startStop-1])
>   * INFO  2015-08-20 16:21:12,083 Hibernate configuration loaded, using
> dialect: org.hibernate.dialect.PostgreSQLDialect
> (DefaultHibernateConfigurationProvider.java [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,179 HHH000388: Unsuccessful: alter table
> completedatasetregistration add column attributeoptioncomboid int4 not null
> (SchemaUpdate.java [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,181 ERROR: column "attributeoptioncomboid"
> contains null values (SchemaUpdate.java [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,185 HHH000388: Unsuccessful: alter table
> datavalue add column attributeoptioncomboid int4 not null (SchemaUpdate.java
> [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,187 ERROR: column "attributeoptioncomboid"
> contains null values (SchemaUpdate.java [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,190 HHH000388: Unsuccessful: alter table
> minmaxdataelement add column minimumvalue int4 not null (SchemaUpdate.java
> [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,191 ERROR: column "minimumvalue" contains null
> values (SchemaUpdate.java [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,194 HHH000388: Unsuccessful: alter table
> minmaxdataelement add column maximumvalue int4 not null (SchemaUpdate.java
> [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,195 ERROR: column "maximumvalue" contains null
> values (SchemaUpdate.java [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,199 HHH000388: Unsuccessful: alter table
> translation add column translationid int4 not null (SchemaUpdate.java
> [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,199 ERROR: column "translationid" contains
> null values (SchemaUpdate.java [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,202 HHH000388: Unsuccessful: alter table
> completedatasetregistration add constraint
> fk_completedatasetregistration_attributeoptioncomboid foreign key
> (attributeoptioncomboid) references categoryoptioncombo (SchemaUpdate.java
> [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,203 ERROR: column "attributeoptioncomboid"
> referenced in foreign key constraint does not exist (SchemaUpdate.java
> [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,206 HHH000388: Unsuccessful: alter table
> datavalue add constraint fk_datavalue_attributeoptioncomboid foreign key
> (attributeoptioncomboid) references categoryoptioncombo (SchemaUpdate.java
> [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,208 ERROR: column "attributeoptioncomboid"
> referenced in foreign key constraint does not exist (SchemaUpdate.java
> [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,210 HHH000388: Unsuccessful: alter table
> programstage add constraint fk_programstage_dataentryform foreign key
> (dataentryformid) references dataentryform (SchemaUpdate.java
> [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,211 ERROR: constraint
> "fk_programstage_dataentryform" for relation "programstage" already exists
> (SchemaUpdate.java [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,215 HHH000388: Unsuccessful: alter table
> sqlviewusergroupaccesses add constraint FK_ftn43gpevax8by169pld7dl5d foreign
> key (sqlviewid) references sqlview (SchemaUpdate.java
> [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,216 ERROR: constraint
> "fk_ftn43gpevax8by169pld7dl5d" for relation "sqlviewusergroupaccesses"
> already exists (SchemaUpdate.java [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,219 HHH000388: Unsuccessful: alter table
> validationrulegroupmembers add constraint
> fk_validationrulegroupmembers_validationrulegroupid foreign key
> (validationgroupid) references validationrulegroup (SchemaUpdate.java
> [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,221 ERROR: constraint
> "fk_validationrulegroupmembers_validationrulegroupid" for relation
> "validationrulegroupmembers" already exists (SchemaUpdate.java
> [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,224 HHH000388: Unsuccessful: alter table
> validationrulegroupusergroupaccesses add constraint
> FK_932w5l8vbyvybhsrwwadjd3cp foreign key (validationrulegroupid) references
> validationrulegroup (SchemaUpdate.java [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,225 ERROR: constraint
> "fk_932w5l8vbyvybhsrwwadjd3cp" for relation
> "validationrulegroupusergroupaccesses" already exists (SchemaUpdate.java
> [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,228 HHH000388: Unsuccessful: alter table
> validationrulegroupusergroupstoalert add constraint
> fk_validationrulegroupusergroupstoalert_validationgroupid foreign key
> (validationgroupid) references validationrulegroup (SchemaUpdate.java
> [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,229 ERROR: constraint
> "fk_validationrulegroupusergroupstoalert_validationgroupid" for relation
> "validationrulegroupusergroupstoalert" already exists (SchemaUpdate.java
> [localhost-startStop-1])
>   * INFO  2015-08-20 16:21:26,000 Found the following message senders:
> [org.hisp.dhis.message.EmailMessageSender@7c267dd0,
> org.hisp.dhis.sms.SmsMessageSender@615318b9] (DefaultMessageService.java
> [localhost-startStop-1])
>   * INFO  2015-08-20 16:21:31,908 Detected apps: [] (DefaultAppManager.java
> [localhost-startStop-1])
>   * INFO  2015-08-20 16:21:33,190 Added logger: org.hisp.dhis.resourcetable
> using file: /home/inveneo/DHIS2_HOME/dhis/logs/dhis-analytics-table.log
> (Log4JLogConfigInitializer.java [localhost-startStop-1])
>   * INFO  2015-08-20 16:21:33,191 Added logger:
> org.hisp.dhis.analytics.table using file:
> /home/inveneo/DHIS2_HOME/dhis/logs/dhis-analytics-table.log
> (Log4JLogConfigInitializer.java [localhost-startStop-1])
>   * INFO  2015-08-20 16:21:33,191 Added logger: org.hisp.dhis.dxf2 using
> file: /home/inveneo/DHIS2_HOME/dhis/logs/dhis-data-exchange.log
> (Log4JLogConfigInitializer.java [localhost-startStop-1])
>   * INFO  2015-08-20 16:21:33,191 Added logger: org.hisp.dhis.dxf2.synch
> using file: /home/inveneo/DHIS2_HOME/dhis/logs/dhis-data-sync.log
> (Log4JLogConfigInitializer.java [localhost-startStop-1])
>   * INFO  2015-08-20 16:21:33,192 Added root logger using file:
> /home/inveneo/DHIS2_HOME/dhis/logs/dhis.log (Log4JLogConfigInitializer.java
> [localhost-startStop-1])
>   * WARN  2015-08-20 16:21:33,724 RP discovery / realm validation disabled;
> (RealmVerifier.java [localhost-startStop-1])
>   * INFO  2015-08-20 16:21:34,751 Executing startup routine [1 of 14,
> runlevel 1]: InitTableAlteror (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>   * INFO  2015-08-20 16:21:34,950 Upgraded program stage data elements
> (InitTableAlteror.java [localhost-startStop-1])
>   * INFO  2015-08-20 16:21:34,951 Executing startup routine [2 of 14,
> runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>   * INFO  2015-08-20 16:21:34,969 Executing startup routine [3 of 14,
> runlevel 2]: DataElementDefaultDimensionPopulator
> (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:34,986 org.hibernate.PropertyAccessException:
> Null value was assigned to a property of primitive type setter of
> org.hisp.dhis.common.BaseDimensionalObject.dataDimension
>   	at
> org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:108)
>   	at
> org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:710)
>   	at
> org.hibernate.tuple.entity.PojoEntityTuplizer.setPropertyValues(PojoEntityTuplizer.java:379)
>   	at
> org.hibernate.persister.entity.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:4522)
>   	at
> org.hibernate.engine.internal.TwoPhaseLoad.doInitializeEntity(TwoPhaseLoad.java:186)
>   	at
> org.hibernate.engine.internal.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:137)
>   	at
> org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:1112)
>   	at org.hibernate.loader.Loader.processResultSet(Loader.java:969)
>   	at org.hibernate.loader.Loader.doQuery(Loader.java:917)
>   	at
> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348)
>   	at org.hibernate.loader.Loader.doList(Loader.java:2550)
>   	at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2395)
>   	at org.hibernate.loader.Loader.list(Loader.java:2358)
>   	at
> org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:124)
>   	at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1623)
>   	at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:374)
>   	at
> org.hisp.dhis.common.hibernate.HibernateIdentifiableObjectStore.getAllEqName(HibernateIdentifiableObjectStore.java:180)
>   	at
> org.hisp.dhis.dataelement.DefaultDataElementCategoryService.getDataElementCategoryByName(DefaultDataElementCategoryService.java:212)
>   	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>   	at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>   	at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>   	at java.lang.reflect.Method.invoke(Method.java:606)
>   	at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
>   	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.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
>   	at
> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
>   	at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
>   	at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
>   	at
> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
>   	at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
>   	at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
>   	at com.sun.proxy.$Proxy38.getDataElementCategoryByName(Unknown Source)
>   	at
> org.hisp.dhis.dataelement.DataElementDefaultDimensionPopulator.execute(DataElementDefaultDimensionPopulator.java:82)
>   	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>   	at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>   	at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>   	at java.lang.reflect.Method.invoke(Method.java:606)
>   	at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
>   	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.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
>   	at
> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
>   	at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
>   	at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
>   	at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
>   	at com.sun.proxy.$Proxy84.execute(Unknown Source)
>   	at
> org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:119)
>   	at
> org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:88)
>   	at
> org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:68)
>   	at
> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4939)
>   	at
> org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5434)
>   	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
>   	at
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
>   	at
> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
>   	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
>   	at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:976)
>   	at
> org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1653)
>   	at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
>   	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
>   	at java.util.concurrent.FutureTask.run(FutureTask.java:166)
>   	at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>   	at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>   	at java.lang.Thread.run(Thread.java:724)
>   Caused by: java.lang.IllegalArgumentException
>   	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>   	at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>   	at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>   	at java.lang.reflect.Method.invoke(Method.java:606)
>   	at
> org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:65)
>   	... 63 more
>    (StartupListener.java [localhost-startStop-1])
>   Aug 20, 2015 4:21:34 PM org.apache.catalina.core.StandardContext
> startInternal
>   SEVERE: Error listenerStart
>   Aug 20, 2015 4:21:34 PM org.apache.catalina.core.StandardContext
> startInternal
>   SEVERE: Context [/dhis] startup failed due to previous errors
>   * INFO  2015-08-20 16:21:34,993 De-registering jdbc driver:
> sun.jdbc.odbc.JdbcOdbcDriver@1629bc56 (StartupListener.java
> [localhost-startStop-1])
>   * INFO  2015-08-20 16:21:34,993 De-registering jdbc driver:
> org.postgresql.Driver@14c944d8 (StartupListener.java
> [localhost-startStop-1])
>   Aug 20, 2015 4:21:35 PM org.apache.catalina.loader.WebappClassLoader
> checkThreadLocalMapForLeaks
>   SEVERE: The web application [/dhis] created a ThreadLocal with key of type
> [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@726b1eee]) and a value
> of type [org.springframework.security.core.context.SecurityContextImpl]
> (value
> [org.springframework.security.core.context.SecurityContextImpl@ffffffff:
> Null authentication]) but failed to remove it when the web application was
> stopped. Threads are going to be renewed over time to try and avoid a
> probable memory leak.
>   Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig
> deployDirectory
>   INFO: Deploying web application directory
> /usr/share/apache-tomcat-7.0.42/webapps/ROOT
>   Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig
> deployDirectory
>   INFO: Deploying web application directory
> /usr/share/apache-tomcat-7.0.42/webapps/host-manager
>   Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig
> deployDirectory
>   INFO: Deploying web application directory
> /usr/share/apache-tomcat-7.0.42/webapps/examples
>   Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig
> deployDirectory
>   INFO: Deploying web application directory
> /usr/share/apache-tomcat-7.0.42/webapps/manager
>   Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig
> deployDirectory
>   INFO: Deploying web application directory
> /usr/share/apache-tomcat-7.0.42/webapps/docs
>   Aug 20, 2015 4:21:35 PM org.apache.coyote.AbstractProtocol start
>   INFO: Starting ProtocolHandler ["http-bio-8080"]
>   Aug 20, 2015 4:21:35 PM org.apache.coyote.AbstractProtocol start
>   INFO: Starting ProtocolHandler ["ajp-bio-8009"]
>   Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.Catalina start
>   INFO: Server startup in 34288 ms
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1487121/+subscriptions
>

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1487121

Title:
  tomcat is not displaying dhis on web browser

Status in DHIS:
  New

Bug description:
  Hello all,

  I am trying to install Dhis on ubuntu desktop 14.04.I av installed
  tomcat,java and copied the war file to webapps.The tomcat starts well
  and deploys the war file.

  But when i try to access the dhis from my webbrowser,it gives the
  error below

  HTTP Status 404 - /dhis

  type Status report

  message /dhis

  description The requested resource is not available.

  Apache Tomcat/7.0.42

  I have tried it on several browsers,its the same thing.Can someone
  please help me ?

  This is a snap shot of the catalina.out result of the tomcat

  Aug 20, 2015 4:21:00 PM org.apache.coyote.AbstractProtocol init
  INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
  Aug 20, 2015 4:21:00 PM org.apache.catalina.startup.Catalina load
  INFO: Initialization processed in 375 ms
  Aug 20, 2015 4:21:01 PM org.apache.catalina.core.StandardService startInternal
  INFO: Starting service Catalina
  Aug 20, 2015 4:21:01 PM org.apache.catalina.core.StandardEngine startInternal
  INFO: Starting Servlet Engine: Apache Tomcat/7.0.42
  Aug 20, 2015 4:21:01 PM org.apache.catalina.startup.HostConfig deployWAR
  INFO: Deploying web application archive /usr/share/apache-tomcat-7.0.42/webapps/dhis.war
  * INFO  2015-08-20 16:21:11,055 System property dhis2.home not set (DefaultLocationManager.java [localhost-startStop-1])
  * INFO  2015-08-20 16:21:11,057 Environment variable DHIS2_HOME points to /home/inveneo/DHIS2_HOME/dhis (DefaultLocationManager.java [localhost-startStop-1])
  * INFO  2015-08-20 16:21:12,083 Hibernate configuration loaded, using dialect: org.hibernate.dialect.PostgreSQLDialect (DefaultHibernateConfigurationProvider.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,179 HHH000388: Unsuccessful: alter table completedatasetregistration add column attributeoptioncomboid int4 not null (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,181 ERROR: column "attributeoptioncomboid" contains null values (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,185 HHH000388: Unsuccessful: alter table datavalue add column attributeoptioncomboid int4 not null (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,187 ERROR: column "attributeoptioncomboid" contains null values (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,190 HHH000388: Unsuccessful: alter table minmaxdataelement add column minimumvalue int4 not null (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,191 ERROR: column "minimumvalue" contains null values (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,194 HHH000388: Unsuccessful: alter table minmaxdataelement add column maximumvalue int4 not null (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,195 ERROR: column "maximumvalue" contains null values (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,199 HHH000388: Unsuccessful: alter table translation add column translationid int4 not null (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,199 ERROR: column "translationid" contains null values (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,202 HHH000388: Unsuccessful: alter table completedatasetregistration add constraint fk_completedatasetregistration_attributeoptioncomboid foreign key (attributeoptioncomboid) references categoryoptioncombo (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,203 ERROR: column "attributeoptioncomboid" referenced in foreign key constraint does not exist (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,206 HHH000388: Unsuccessful: alter table datavalue add constraint fk_datavalue_attributeoptioncomboid foreign key (attributeoptioncomboid) references categoryoptioncombo (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,208 ERROR: column "attributeoptioncomboid" referenced in foreign key constraint does not exist (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,210 HHH000388: Unsuccessful: alter table programstage add constraint fk_programstage_dataentryform foreign key (dataentryformid) references dataentryform (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,211 ERROR: constraint "fk_programstage_dataentryform" for relation "programstage" already exists (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,215 HHH000388: Unsuccessful: alter table sqlviewusergroupaccesses add constraint FK_ftn43gpevax8by169pld7dl5d foreign key (sqlviewid) references sqlview (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,216 ERROR: constraint "fk_ftn43gpevax8by169pld7dl5d" for relation "sqlviewusergroupaccesses" already exists (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,219 HHH000388: Unsuccessful: alter table validationrulegroupmembers add constraint fk_validationrulegroupmembers_validationrulegroupid foreign key (validationgroupid) references validationrulegroup (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,221 ERROR: constraint "fk_validationrulegroupmembers_validationrulegroupid" for relation "validationrulegroupmembers" already exists (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,224 HHH000388: Unsuccessful: alter table validationrulegroupusergroupaccesses add constraint FK_932w5l8vbyvybhsrwwadjd3cp foreign key (validationrulegroupid) references validationrulegroup (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,225 ERROR: constraint "fk_932w5l8vbyvybhsrwwadjd3cp" for relation "validationrulegroupusergroupaccesses" already exists (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,228 HHH000388: Unsuccessful: alter table validationrulegroupusergroupstoalert add constraint fk_validationrulegroupusergroupstoalert_validationgroupid foreign key (validationgroupid) references validationrulegroup (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,229 ERROR: constraint "fk_validationrulegroupusergroupstoalert_validationgroupid" for relation "validationrulegroupusergroupstoalert" already exists (SchemaUpdate.java [localhost-startStop-1])
  * INFO  2015-08-20 16:21:26,000 Found the following message senders: [org.hisp.dhis.message.EmailMessageSender@7c267dd0, org.hisp.dhis.sms.SmsMessageSender@615318b9] (DefaultMessageService.java [localhost-startStop-1])
  * INFO  2015-08-20 16:21:31,908 Detected apps: [] (DefaultAppManager.java [localhost-startStop-1])
  * INFO  2015-08-20 16:21:33,190 Added logger: org.hisp.dhis.resourcetable using file: /home/inveneo/DHIS2_HOME/dhis/logs/dhis-analytics-table.log (Log4JLogConfigInitializer.java [localhost-startStop-1])
  * INFO  2015-08-20 16:21:33,191 Added logger: org.hisp.dhis.analytics.table using file: /home/inveneo/DHIS2_HOME/dhis/logs/dhis-analytics-table.log (Log4JLogConfigInitializer.java [localhost-startStop-1])
  * INFO  2015-08-20 16:21:33,191 Added logger: org.hisp.dhis.dxf2 using file: /home/inveneo/DHIS2_HOME/dhis/logs/dhis-data-exchange.log (Log4JLogConfigInitializer.java [localhost-startStop-1])
  * INFO  2015-08-20 16:21:33,191 Added logger: org.hisp.dhis.dxf2.synch using file: /home/inveneo/DHIS2_HOME/dhis/logs/dhis-data-sync.log (Log4JLogConfigInitializer.java [localhost-startStop-1])
  * INFO  2015-08-20 16:21:33,192 Added root logger using file: /home/inveneo/DHIS2_HOME/dhis/logs/dhis.log (Log4JLogConfigInitializer.java [localhost-startStop-1])
  * WARN  2015-08-20 16:21:33,724 RP discovery / realm validation disabled;  (RealmVerifier.java [localhost-startStop-1])
  * INFO  2015-08-20 16:21:34,751 Executing startup routine [1 of 14, runlevel 1]: InitTableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
  * INFO  2015-08-20 16:21:34,950 Upgraded program stage data elements (InitTableAlteror.java [localhost-startStop-1])
  * INFO  2015-08-20 16:21:34,951 Executing startup routine [2 of 14, runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
  * INFO  2015-08-20 16:21:34,969 Executing startup routine [3 of 14, runlevel 2]: DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:34,986 org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of org.hisp.dhis.common.BaseDimensionalObject.dataDimension
  	at org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:108)
  	at org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:710)
  	at org.hibernate.tuple.entity.PojoEntityTuplizer.setPropertyValues(PojoEntityTuplizer.java:379)
  	at org.hibernate.persister.entity.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:4522)
  	at org.hibernate.engine.internal.TwoPhaseLoad.doInitializeEntity(TwoPhaseLoad.java:186)
  	at org.hibernate.engine.internal.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:137)
  	at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:1112)
  	at org.hibernate.loader.Loader.processResultSet(Loader.java:969)
  	at org.hibernate.loader.Loader.doQuery(Loader.java:917)
  	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348)
  	at org.hibernate.loader.Loader.doList(Loader.java:2550)
  	at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2395)
  	at org.hibernate.loader.Loader.list(Loader.java:2358)
  	at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:124)
  	at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1623)
  	at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:374)
  	at org.hisp.dhis.common.hibernate.HibernateIdentifiableObjectStore.getAllEqName(HibernateIdentifiableObjectStore.java:180)
  	at org.hisp.dhis.dataelement.DefaultDataElementCategoryService.getDataElementCategoryByName(DefaultDataElementCategoryService.java:212)
  	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  	at java.lang.reflect.Method.invoke(Method.java:606)
  	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  	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.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
  	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
  	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
  	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
  	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
  	at com.sun.proxy.$Proxy38.getDataElementCategoryByName(Unknown Source)
  	at org.hisp.dhis.dataelement.DataElementDefaultDimensionPopulator.execute(DataElementDefaultDimensionPopulator.java:82)
  	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  	at java.lang.reflect.Method.invoke(Method.java:606)
  	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  	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.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
  	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
  	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
  	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
  	at com.sun.proxy.$Proxy84.execute(Unknown Source)
  	at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:119)
  	at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:88)
  	at org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:68)
  	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4939)
  	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5434)
  	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
  	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
  	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
  	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
  	at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:976)
  	at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1653)
  	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
  	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
  	at java.util.concurrent.FutureTask.run(FutureTask.java:166)
  	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
  	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
  	at java.lang.Thread.run(Thread.java:724)
  Caused by: java.lang.IllegalArgumentException
  	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  	at java.lang.reflect.Method.invoke(Method.java:606)
  	at org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:65)
  	... 63 more
   (StartupListener.java [localhost-startStop-1])
  Aug 20, 2015 4:21:34 PM org.apache.catalina.core.StandardContext startInternal
  SEVERE: Error listenerStart
  Aug 20, 2015 4:21:34 PM org.apache.catalina.core.StandardContext startInternal
  SEVERE: Context [/dhis] startup failed due to previous errors
  * INFO  2015-08-20 16:21:34,993 De-registering jdbc driver: sun.jdbc.odbc.JdbcOdbcDriver@1629bc56 (StartupListener.java [localhost-startStop-1])
  * INFO  2015-08-20 16:21:34,993 De-registering jdbc driver: org.postgresql.Driver@14c944d8 (StartupListener.java [localhost-startStop-1])
  Aug 20, 2015 4:21:35 PM org.apache.catalina.loader.WebappClassLoader checkThreadLocalMapForLeaks
  SEVERE: The web application [/dhis] created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@726b1eee]) and a value of type [org.springframework.security.core.context.SecurityContextImpl] (value [org.springframework.security.core.context.SecurityContextImpl@ffffffff: Null authentication]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
  Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig deployDirectory
  INFO: Deploying web application directory /usr/share/apache-tomcat-7.0.42/webapps/ROOT
  Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig deployDirectory
  INFO: Deploying web application directory /usr/share/apache-tomcat-7.0.42/webapps/host-manager
  Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig deployDirectory
  INFO: Deploying web application directory /usr/share/apache-tomcat-7.0.42/webapps/examples
  Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig deployDirectory
  INFO: Deploying web application directory /usr/share/apache-tomcat-7.0.42/webapps/manager
  Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.HostConfig deployDirectory
  INFO: Deploying web application directory /usr/share/apache-tomcat-7.0.42/webapps/docs
  Aug 20, 2015 4:21:35 PM org.apache.coyote.AbstractProtocol start
  INFO: Starting ProtocolHandler ["http-bio-8080"]
  Aug 20, 2015 4:21:35 PM org.apache.coyote.AbstractProtocol start
  INFO: Starting ProtocolHandler ["ajp-bio-8009"]
  Aug 20, 2015 4:21:35 PM org.apache.catalina.startup.Catalina start
  INFO: Server startup in 34288 ms

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1487121/+subscriptions


References