dhis2-users team mailing list archive

[Manaf Abthul <drmanaf79@xxxxxxxxx>]

Hi,

I am Manaf from Sri Lanka, doing a research on customization of dhis2 for
the Respiratory clinic specially in tracker based aggregation.
Now I am facing problems as follow.






*1. Aggregation query builder---> Test condition is not working, whether
the query is correct or not. 2. Once adding a person in to one programme
under one org unit, it is there for the Programme stage and other data
entry. but after search that person not in the programme but in the org
unit(means out of the programe). 3. Manual Person Aggregation showing No
data4. When we look at catalina.out there are error message.*

Feb 10, 2014 9:46:39 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal
performance in production environments was not found on the
java.library.path:
/usr/java/packages/lib/i386:/usr/lib/i386-linux-gnu/jni:/lib/i386-linux-gnu:/usr/lib/i386-linux-gnu:/usr/lib/jni:/lib:/usr/lib
Feb 10, 2014 9:46:40 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8080"]
Feb 10, 2014 9:46:40 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
Feb 10, 2014 9:46:40 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 509 ms
Feb 10, 2014 9:46:40 PM org.apache.catalina.core.StandardService
startInternal
INFO: Starting service Catalina
Feb 10, 2014 9:46:40 PM org.apache.catalina.core.StandardEngine
startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.50
Feb 10, 2014 9:46:40 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive /opt/tomcat/webapps/dhis.war
* INFO  2014-02-10 21:46:52,589 System property dhis2.home not set
(DefaultLocationManager.java [localhost-startStop-1])
* INFO  2014-02-10 21:46:52,591 Environment variable DHIS2_HOME points to
/opt/Dhis_Home (DefaultLocationManager.java [localhost-startStop-1])
* INFO  2014-02-10 21:46:53,787 Hibernate configuration loaded, using
dialect: org.hibernate.dialect.MySQLDialect
(DefaultHibernateConfigurationProvider.java [localhost-startStop-1])
* ERROR 2014-02-10 21:47:00,683 HHH000388: Unsuccessful: alter table
dataelementcategoryoption add index fk_dataelementcategory_conceptid
(conceptid), add constraint fk_dataelementcategory_conceptid foreign key
(conceptid) references concept (conceptid) (SchemaUpdate.java
[localhost-startStop-1])
* ERROR 2014-02-10 21:47:00,684 Can't create table 'asth.#sql-3f0_513'
(errno: 121) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-02-10 21:47:00,792 HHH000388: Unsuccessful: alter table
indicator add index fk_indicator_userid (userid), add constraint
fk_indicator_userid foreign key (userid) references userinfo (userinfoid)
(SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-02-10 21:47:00,795 Can't create table 'asth.#sql-3f0_513'
(errno: 121) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-02-10 21:47:00,894 HHH000388: Unsuccessful: alter table
indicator add index fk_indicator_legendset (legendsetid), add constraint
fk_indicator_legendset foreign key (legendsetid) references maplegendset
(maplegendsetid) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-02-10 21:47:00,896 Can't create table 'asth.#sql-3f0_513'
(errno: 121) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-02-10 21:47:00,995 HHH000388: Unsuccessful: alter table
interpretationcomment add index fk_interpretation_userid (userid), add
constraint fk_interpretation_userid foreign key (userid) references
userinfo (userinfoid) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-02-10 21:47:00,998 Can't create table 'asth.#sql-3f0_513'
(errno: 121) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-02-10 21:47:01,108 HHH000388: Unsuccessful: alter table
orgunitgroup add index fk_indicator_userid (userid), add constraint
fk_indicator_userid foreign key (userid) references userinfo (userinfoid)
(SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-02-10 21:47:01,110 Can't create table 'asth.#sql-3f0_513'
(errno: 121) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-02-10 21:47:01,209 HHH000388: Unsuccessful: alter table report
add index fk_report_relativeperiodsid (relativeperiodsid), add constraint
fk_report_relativeperiodsid foreign key (relativeperiodsid) references
relativeperiods (relativeperiodsid) (SchemaUpdate.java
[localhost-startStop-1])
* ERROR 2014-02-10 21:47:01,210 Can't create table 'asth.#sql-3f0_513'
(errno: 121) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-02-10 21:47:01,311 HHH000388: Unsuccessful: alter table
reporttable add index fk_report_relativeperiodsid (relativeperiodsid), add
constraint fk_report_relativeperiodsid foreign key (relativeperiodsid)
references relativeperiods (relativeperiodsid) (SchemaUpdate.java
[localhost-startStop-1])
* ERROR 2014-02-10 21:47:01,315 Can't create table 'asth.#sql-3f0_513'
(errno: 121) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-02-10 21:47:01,433 HHH000388: Unsuccessful: alter table
usergroupmembers add index fk_usergroup_userid (userid), add constraint
fk_usergroup_userid foreign key (userid) references userinfo (userinfoid)
(SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-02-10 21:47:01,434 Can't create table 'asth.#sql-3f0_513'
(errno: 121) (SchemaUpdate.java [localhost-startStop-1])
* INFO  2014-02-10 21:47:06,463 Found the following message senders:
[org.hisp.dhis.message.EmailMessageSender@fb20b,
org.hisp.dhis.sms.SmsMessageSender@71ff98] (DefaultMessageService.java
[localhost-startStop-1])
* INFO  2014-02-10 21:47:10,865 Detected apps: [] (DefaultAppManager.java
[localhost-startStop-1])
* INFO  2014-02-10 21:47:14,010 Executing startup routine [1 of 11,
runlevel 1]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java
[localhost-startStop-1])
* INFO  2014-02-10 21:47:14,050 Executing startup routine [2 of 11,
runlevel 1]: DataElementDefaultDimensionPopulator
(DefaultStartupRoutineExecutor.java [localhost-startStop-1])
* INFO  2014-02-10 21:47:14,265 Linked default category with default
concept (DataElementDefaultDimensionPopulator.java [localhost-startStop-1])
* INFO  2014-02-10 21:47:14,446 Executing startup routine [3 of 11,
runlevel 2]: TableAlteror (DefaultStartupRoutineExecutor.java
[localhost-startStop-1])
* INFO  2014-02-10 21:47:19,867 Tables updated (TableAlteror.java
[localhost-startStop-1])
* INFO  2014-02-10 21:47:19,869 Executing startup routine [4 of 11,
runlevel 3]: IdentityPopulator (DefaultStartupRoutineExecutor.java
[localhost-startStop-1])
* INFO  2014-02-10 21:47:21,348 Executing startup routine [5 of 11,
runlevel 3]: TableCreator (DefaultStartupRoutineExecutor.java
[localhost-startStop-1])
* INFO  2014-02-10 21:47:21,356 Executing startup routine [6 of 11,
runlevel 4]: PatientTableAlteror (DefaultStartupRoutineExecutor.java
[localhost-startStop-1])
* INFO  2014-02-10 21:47:22,843 Updated case aggregate query build formulas
which have gender criteria (TableAlteror.java [localhost-startStop-1])
* INFO  2014-02-10 21:47:22,972 Inserted data into program_attributes
table. (TableAlteror.java [localhost-startStop-1])
* INFO  2014-02-10 21:47:22,984 Inserted data into program_identifiertypes
table. (TableAlteror.java [localhost-startStop-1])
* INFO  2014-02-10 21:47:22,996 Dropped program_patientattributes table.
(TableAlteror.java [localhost-startStop-1])
* INFO  2014-02-10 21:47:23,008 Dropped program_patientidentifiertypes
table. (TableAlteror.java [localhost-startStop-1])
* INFO  2014-02-10 21:47:23,013 Executing startup routine [7 of 11,
runlevel 4]: MapViewUpgrader (DefaultStartupRoutineExecutor.java
[localhost-startStop-1])
* INFO  2014-02-10 21:47:23,176 Executing startup routine [8 of 11,
runlevel 5]: DataEntryFormUpgrader (DefaultStartupRoutineExecutor.java
[localhost-startStop-1])
* INFO  2014-02-10 21:47:23,180 Upgraded custom case entry form identifiers
(DataEntryFormUpgrader.java [localhost-startStop-1])
* INFO  2014-02-10 21:47:23,183 Executing startup routine [9 of 11,
runlevel 6]: ExpressionUpgrader (DefaultStartupRoutineExecutor.java
[localhost-startStop-1])
* INFO  2014-02-10 21:47:23,204 Executing startup routine [10 of 11,
runlevel 7]: ConfigurationPopulator (DefaultStartupRoutineExecutor.java
[localhost-startStop-1])
* INFO  2014-02-10 21:47:23,209 Executing startup routine [11 of 11,
runlevel 7]: I18nLocalePopulator (DefaultStartupRoutineExecutor.java
[localhost-startStop-1])
* INFO  2014-02-10 21:47:23,226 All startup routines done
(DefaultStartupRoutineExecutor.java [localhost-startStop-1])
* WARN  2014-02-10 21:47:26,629 Did not find any ViewResolvers to delegate
to; please configure them using the 'viewResolvers' property on the
ContentNegotiatingViewResolver (ContentNegotiatingViewResolver.java
[localhost-startStop-1])
Feb 10, 2014 9:47:29 PM org.apache.catalina.startup.HostConfig
deployDirectory
INFO: Deploying web application directory /opt/tomcat/webapps/examples
Feb 10, 2014 9:47:30 PM org.apache.catalina.startup.HostConfig
deployDirectory
INFO: Deploying web application directory /opt/tomcat/webapps/manager
Feb 10, 2014 9:47:30 PM org.apache.catalina.startup.HostConfig
deployDirectory
INFO: Deploying web application directory /opt/tomcat/webapps/docs
Feb 10, 2014 9:47:30 PM org.apache.catalina.startup.HostConfig
deployDirectory
INFO: Deploying web application directory /opt/tomcat/webapps/host-manager
Feb 10, 2014 9:47:30 PM org.apache.catalina.startup.HostConfig
deployDirectory
INFO: Deploying web application directory /opt/tomcat/webapps/ROOT
Feb 10, 2014 9:47:30 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8080"]
Feb 10, 2014 9:47:30 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-bio-8009"]
Feb 10, 2014 9:47:30 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 50197 ms

*To over come this problem, HOW TO FIX?*

Please be kind enough to help me to solve this problem.

Note:
I am using Ubuntu which was installed when you were here. I did not do any
changes. others are working well except mentioned above.

I tried this example also, seen in dhis2 document,

*26.2.1.8.2. Sample of person aggregation*
E.g. Find the number of the children vaccinated BCG by defining a linking
rule between the data elements of aggregate
dataset named Number of children - BCG and the data element of a program
stage named BCG dose given.
1. From Maintenance menu, go to Data Element and Indicators option and
click on it. Select Data Element option
to define two new data elements -
     1) Define a new data element named Number of children - BCG with
Aggregate option for Domain Type.
     2) Define a new data element named BCG dose give date with Patient
option for Domain Type.
2. From Maintenance menu, go to Datasets option and click on it. Select
Dataset option to create a new dataset named
BCG Report and add Number of children - BCG data element into the dataset.
3. From Maintenance menu, go to Persons and Programs option and click on
it. Select Program option to create a
program named Child Health Program with a stage named Birth Details and add
the BCG dose given data element
into this stage.
4. Create a new aggregation query builder named Number of children - BCG
Builder to linking between the data
elements.
5. From Services menu, go to Individual Records option and click on it.
Select Person option below Registration
header in the left menu to register three persons named Micheal, Alice and
Tom in Ngelehun CHC and enroll them
into Child Health Program.
    1) For Micheal, open the Birth Details stage into Child Health Program.
Enter value for BCG dose give date data
element as "2012-01-18".
    2) For Alice, open the Birth Details stage into Child Health Program.
Enter value for BCG dose give date data
element as "2012-01-18".
    3) For Tom, no enter any data value for Birth Details stage.





Thank you

Manaf