dhis2-users team mailing list archive

[Tran Chau <tran.hispvietnam@xxxxxxxxx>]

Dear all,

I tested all these bugs on trunk and 2.14 ( R. 13785 ). They don't occur on
my side. Could you please create an example on demo server and we can see
it ?

Also please give me the versio n + revision you used for testing.

Thank you.

Best regards,
------------------------------------------------
Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@xxxxxxxxx


On Sun, Feb 23, 2014 at 9:23 PM, Prosper BT <ptb3000@xxxxxxxxx> wrote:
>
> Hi Tran
>
> This you see thia reported bug we are facing the same.
>
> Regards
>
> ---------- Forwarded message ----------
> From: "Manaf Abthul" <drmanaf79@xxxxxxxxx>
> Date: Feb 19, 2014 9:28 AM
> Subject: [Dhis2-users] Fwd: Regarding My Project Customization of DHIS2
for Chest clinic
> To: "dhis2" <dhis2-users@xxxxxxxxxxxxxxxxxxx>
> Cc:
>
>
>
> 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 data
>
> 4. 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
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>