[Dhis2-users] Datasets NOT Available
Dear Members, I just upgraded from DHIS2.28 to 2.29 to 2.30 following all the rules. My users cannot do data entry now because datasets are not available. When I give them full authority they are able to see datasets. The only error I see in the log is "Cannot get users with disjoint roles as user does not have any user roles (DefaultUserService.java [localhost-startStop-1])". What I'm I missing? [image: image.png] Name: Kabango Malewezi skype: kabango.malewezi catalina.out Description: Binary data ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] Dhis2.30 Failing to start
Thanks for the advice it worked out. It was indeed memory. I did not allocate enough memory to Java. Kabango On Thu, Aug 23, 2018 at 4:46 PM Kabango Malewezi wrote: > Dear Members, > My DHIS2.30 is failing to start. This is a clean install not an upgrade. > Please look at the enclosed log and assist. > I installed 2.28 on the same server with no problems. I know this is not a > new error to most of you. > > The error is: Error creating bean with name > 'org.hisp.dhis.schema.PropertyIntrospectorService': Unsatisfied dependency > expressed through field 'sessionFactory'; nested exception is > org.springframework.beans.factory.BeanCreationException: Error creating > bean with name 'sessionFactory' defined in URL > [jar:file:/home/dhis/tomcat-dhis/webapps/dhis/WEB-INF/lib/dhis-support-hibernate-2.30.jar!/META-INF/dhis/beans.xml]: > Invocation of init method failed; nested exception is > java.lang.OutOfMemoryError: GC overhead limit exceeded > at > org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:749) > at > org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1201) > > See enclosed file for a complete log. > > Thank you in advance. > > -- > > > Name: Kabango Malewezi > > > Jhpiego, City Center, Lilongwe, Malawi > > Mobile: +265 (0) 88 4 245 431 > > skype: kabango.malewezi > -- Name: Kabango Malewezi Jhpiego, City Center, Lilongwe, Malawi Mobile: +265 (0) 88 4 245 431 skype: kabango.malewezi ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] Dhis2.30 Failing to start
Thanks, I'll look into it. On Thu, Aug 23, 2018 at 5:04 PM Bob Jolliffe wrote: > No, looks like the problem is out of memory. > > You need to tweak your memory settings somehow/somewhere. Where > exactly depends on how much RAM you have free on the machine and what > other processes might be running and using memory and how you have > setup tomcat. > > Possibly you need to increase the size of Xmx (heap space) in your > java options. Or you might need to remove or scale back something > else which is running on your machine. > > On 23 August 2018 at 15:50, Knut Staring wrote: > > Hi there, > > > > It may not be related to this at all, but have you made sure to install > the > > PostGIS extension, required from 2.30? > > > > > https://github.com/dhis2/dhis2-releases/blob/master/releases/2.30/README.md > > > > On Thu, Aug 23, 2018 at 4:46 PM Kabango Malewezi > > wrote: > >> > >> Dear Members, > >> My DHIS2.30 is failing to start. This is a clean install not an upgrade. > >> Please look at the enclosed log and assist. > >> I installed 2.28 on the same server with no problems. I know this is > not a > >> new error to most of you. > >> > >> The error is: Error creating bean with name > >> 'org.hisp.dhis.schema.PropertyIntrospectorService': Unsatisfied > dependency > >> expressed through field 'sessionFactory'; nested exception is > >> org.springframework.beans.factory.BeanCreationException: Error creating > bean > >> with name 'sessionFactory' defined in URL > >> > [jar:file:/home/dhis/tomcat-dhis/webapps/dhis/WEB-INF/lib/dhis-support-hibernate-2.30.jar!/META-INF/dhis/beans.xml]: > >> Invocation of init method failed; nested exception is > >> java.lang.OutOfMemoryError: GC overhead limit exceeded > >> at > >> > org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:749) > >> at > >> > org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189) > >> at > >> > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1201) > >> > >> See enclosed file for a complete log. > >> > >> Thank you in advance. > >> > >> -- > >> > >> > >> Name: Kabango Malewezi > >> > >> > >> Jhpiego, City Center, Lilongwe, Malawi > >> > >> Mobile: +265 (0) 88 4 245 431 > >> > >> skype: kabango.malewezi > >> > >> ___ > >> Mailing list: https://launchpad.net/~dhis2-users > >> Post to : dhis2-users@lists.launchpad.net > >> Unsubscribe : https://launchpad.net/~dhis2-users > >> More help : https://help.launchpad.net/ListHelp > > > > > > > > -- > > Knut Staring > > > > Department of Information, Evidence and Research > > World Health Organization, Geneva, Switzerland > > Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522 > > Skype: knutstar > > > > ___ > > Mailing list: https://launchpad.net/~dhis2-users > > Post to : dhis2-users@lists.launchpad.net > > Unsubscribe : https://launchpad.net/~dhis2-users > > More help : https://help.launchpad.net/ListHelp > > > -- Name: Kabango Malewezi Jhpiego, City Center, Lilongwe, Malawi Mobile: +265 (0) 88 4 245 431 skype: kabango.malewezi ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] Dhis2.30 Failing to start
Dear Members, My DHIS2.30 is failing to start. This is a clean install not an upgrade. Please look at the enclosed log and assist. I installed 2.28 on the same server with no problems. I know this is not a new error to most of you. The error is: Error creating bean with name 'org.hisp.dhis.schema.PropertyIntrospectorService': Unsatisfied dependency expressed through field 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in URL [jar:file:/home/dhis/tomcat-dhis/webapps/dhis/WEB-INF/lib/dhis-support-hibernate-2.30.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is java.lang.OutOfMemoryError: GC overhead limit exceeded at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:749) at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1201) See enclosed file for a complete log. Thank you in advance. -- Name: Kabango Malewezi Jhpiego, City Center, Lilongwe, Malawi Mobile: +265 (0) 88 4 245 431 skype: kabango.malewezi localhost.2018-08-23.log Description: Binary data ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] GIS in DHIS
Dear Team, I'm looking for documentation on how to setup GIS in DHIS. Please help! Kabango Malewezi | Database Specialist SSDI Services 2nd Floor, Pamodzi House, City Center, P.O Box 1091, Lilongwe, Malawi Tel: +265 (01) 776 412/3/4 | fax: +265 (01) 776 410 | Mobile: +265 (0) 88 4 245 431 kmalew...@jhpiego.net mailto:kmalew...@jhpiego.net | www.jhpiego.orghttp://www.jhpiego.org/ Skype: kabango.malewezi | Twitter: kabangoM ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] Reporting Rate Summary
Hie All, When I run the Reporting Rate Summary I get something like the one below. The problem is that there are 9 facilities in Chitipa but I get 10 on Target. Also in Karonga there are 19 facilities but target is 20 o Target. Can someone explain to me what is going on. [X] Kabango Malewezi | Database Specialist SSDI Services 2nd Floor, Pamodzi House, City Center, P.O Box 1091, Lilongwe, Malawi Tel: +265 (01) 776 412/3/4 | fax: +265 (01) 776 410 | Mobile: +265 (0) 88 4 245 431 kmalew...@jhpiego.net mailto:kmalew...@jhpiego.net | www.jhpiego.orghttp://www.jhpiego.org/ Skype: kabango.malewezi | Twitter: kabangoM ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] Reporting Rate Summary
Thanks a lot Olav, I did exactly that. It's now fixed. Kabango Malewezi | Database Specialist SSDI Services 2nd Floor, Pamodzi House, City Center, P.O Box 1091, Lilongwe, Malawi Tel: +265 (01) 776 412/3/4 | fax: +265 (01) 776 410 | Mobile: +265 (0) 88 4 245 431 kmalew...@jhpiego.net | www.jhpiego.org Skype: kabango.malewezi | Twitter: kabangoM From: Olav Poppe [olav.po...@me.com] Sent: Tuesday, January 22, 2013 1:23 PM To: Kabango Malewezi Subject: Re: [Dhis2-users] Reporting Rate Summary Hi, most likely, the dataset is assign to the org unit above the facilities in addition to the facilities themselves. Thus the target becomes 9 facilities + 1 district = 10. Olav 22. jan. 2013 kl. 12:16 skrev Kabango Malewezi kmalew...@jhpiego.net: Hie All, When I run the Reporting Rate Summary I get something like the one below. The problem is that there are 9 facilities in Chitipa but I get 10 on Target. Also in Karonga there are 19 facilities but target is 20 o Target. Can someone explain to me what is going on. [X] Kabango Malewezi | Database Specialist SSDI Services 2nd Floor, Pamodzi House, City Center, P.O Box 1091, Lilongwe, Malawi Tel: +265 (01) 776 412/3/4 | fax: +265 (01) 776 410 | Mobile: +265 (0) 88 4 245 431 kmalew...@jhpiego.net mailto:kmalew...@jhpiego.net | www.jhpiego.orghttp://www.jhpiego.org/ Skype: kabango.malewezi | Twitter: kabangoM ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] Java Help
Dear Team, I'm trying to setup DHIS2 online. I did the test before and it worked fine. Now on production server I've a problem with Java. I've installed openjdk java (NOT Sun Java I used before) and it's working fine. The problem is the setenv.sh file.(See below) I don't know what path to put for java. Anything I put brings an error in catalina.out e.g /usr/local/apache-tomcat-7.0.30/bin/catalina.sh: 1: eval: /usr/lib/jvm/java-6-sun/bin/java: not found What path should I put on the first line. Openjdk dava is a default installation. Here is the /usr/local/apache-tomcat-7.0.30/bin/setenv.sh export JAVA_HOME=/usr/lib/jvm/java-6-sun export JAVA_OPTS=”-Xmx600m -XX:MaxPermSize=1000m” export DHIS2_HOME=/home/your-user-name/dhis2/DHIS2_HOME Kabango Malewezi SSDI Services 2nd Floor, Pamodzi House, City Center, P.O Box 1091, Lilongwe, Malawi Tel: +265 (01) 776 412/3/4 | fax: +265 (01) 776 410 | Mobile: +265 (0) 88 4 245 431 kmalew...@jhpiego.net mailto:kmalew...@jhpiego.net | www.jhpiego.orghttp://www.jhpiego.org/ Skype: kabango.malewezi | Twitter: kabangoM ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] Custom Combo Box
Thanks. That helps. Kabango Malewezi | Database Specialist SSDI Services 2nd Floor, Pamodzi House, City Center, P.O Box 1091, Lilongwe, Malawi Tel: +265 (01) 776 412/3/4 | fax: +265 (01) 776 410 | Mobile: +265 (0) 88 4 245 431 kmalew...@jhpiego.net | www.jhpiego.org Skype: kabango.malewezi | Twitter: kabangoM From: Lars Helge Øverland [larshe...@gmail.com] Sent: Monday, July 30, 2012 12:26 PM To: Kabango Malewezi Cc: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] Custom Combo Box At the moment the only option would be to write your own html to produce a drop-down in a custom data entry form. regards, Lars On Fri, Jul 27, 2012 at 2:20 PM, Kabango Malewezi kmalew...@jhpiego.net wrote: So there's no solution at the moment for my problem? ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] Datamart
Thank you so very much. Will try it.
Kabango Malewezi | Database Specialist
SSDI Services
2nd Floor, Pamodzi House, City Center, P.O Box 1091, Lilongwe, Malawi
Tel: +265 (01) 776 412/3/4 | fax: +265 (01) 776 410 | Mobile: +265 (0) 88 4 245
431
kmalew...@jhpiego.net | www.jhpiego.org
Skype: kabango.malewezi | Twitter: kabangoM
From: Jason Pickering [jason.p.picker...@gmail.com]
Sent: Wednesday, July 25, 2012 8:12 PM
To: Kabango Malewezi
Cc: Ola Hodne Titlestad; olati...@gmail.com; dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Datamart
Hi there. Apologies for the late response.
Here is the way we do it. First, the view in MyDatamart.
DROP VIEW IF EXISTS vw_ou4_pivotsource_rapid_weekly_inds_des;
CREATE VIEW vw_ou4_pivotsource_rapid_weekly_inds_des as
SELECT dv.organisationunitid,
ou2.name as province,
ou3.name as district,
ou4.name as facility,
de.name as dataelementname,
inds.indicator_type as datatype,
p.startdate as begin_date,
p.enddate as end_date,
strftime('%m',p.startdate) as month,
substr(dv.period,1,4) as year,
substr(dv.period,6,8) + 1 as week,
dv.factor,
dv.numeratorvalue,
dv.denominatorvalue,
dv.numeratorvalue*dv.factor AS numxfactor,
CASE dv.numeratorvalue WHEN 0 THEN 1 ELSE 0 END as is_zero,
1 as return_order
FROM aggregatedindicatorvalue dv
INNER JOIN _orgunitstructure ous
ON dv.organisationunitid = ous.organisationunitid
INNER JOIN organisationunit ou2 on ous.idlevel2 = ou2.organisationunitid
INNER JOIN organisationunit ou3 on ous.idlevel3 = ou3.organisationunitid
INNER JOIN organisationunit ou4 on ous.idlevel4 = ou4.organisationunitid
INNER JOIN _indicatorgroupsetstructure inds on inds.indicatorid = dv.indicatorid
INNER JOIN indicator de on dv.indicatorid = de.indicatorid
INNER JOIN period p on dv.period = p.period
WHERE dv.organisationunitid in (SELECT DISTINCT idlevel4 from
_orgunitstructure where idlevel4 IS NOT NULL)
and dv.periodtype = 'W' and inds.indicator_type = 'Indicators'
UNION
SELECT dv.organisationunitid,
ou2.name as province,
ou3.name as district,
ou4.name as facility,
de.name as dataelementname,
'Raw data' as datatype,
p.startdate as begin_date,
p.enddate as end_date,
strftime('%m',p.startdate) as month,
substr(dv.period,1,4) as year,
substr(dv.period,6,8) + 1 as week,
NULL as factor,
dv.value as numeratorvalue,
NULL as denominatorvalue,
NULL AS numxfactor,
CASE dv.value when 0 THEN 1 ELSE 0 END as is_zero,
2 as return_order
FROM aggregateddatavalue dv
INNER JOIN _orgunitstructure ous
ON dv.organisationunitid = ous.organisationunitid
INNER JOIN organisationunit ou2 on ous.idlevel2 = ou2.organisationunitid
INNER JOIN organisationunit ou3 on ous.idlevel3 = ou3.organisationunitid
INNER JOIN organisationunit ou4 on ous.idlevel4 = ou4.organisationunitid
INNER JOIN dataelement de on dv.dataelementid = de.dataelementid
INNER JOIN period p on dv.period = p.period
WHERE dv.organisationunitid in (SELECT DISTINCT idlevel4 from
_orgunitstructure where idlevel4 IS NOT NULL)
and dv.periodtype = 'W'
UNION
SELECT dv.organisationunitid,
ou2.name as province,
ou3.name as district,
ou4.name as facility,
de.name as dataelementname,
inds.indicator_type as datatype,
p.startdate as begin_date,
p.enddate as end_date,
strftime('%m',p.startdate) as month,
substr(dv.period,1,4) as year,
substr(dv.period,6,8) + 1 as week,
NULL as factor,
dv.numeratorvalue,
NULL as denominatorvalue,
NULL AS numxfactor,
CASE dv.numeratorvalue when 0 THEN 1 ELSE 0 END as is_zero,
3 as return_order
FROM aggregatedindicatorvalue dv
INNER JOIN _orgunitstructure ous
ON dv.organisationunitid = ous.organisationunitid
INNER JOIN organisationunit ou2 on ous.idlevel2 = ou2.organisationunitid
INNER JOIN organisationunit ou3 on ous.idlevel3 = ou3.organisationunitid
INNER JOIN organisationunit ou4 on ous.idlevel4 = ou4.organisationunitid
INNER JOIN _indicatorgroupsetstructure inds on inds.indicatorid = dv.indicatorid
INNER JOIN indicator de on dv.indicatorid = de.indicatorid
INNER JOIN period p on dv.period = p.period
WHERE dv.organisationunitid in (SELECT DISTINCT idlevel4 from
_orgunitstructure where idlevel4 IS NOT NULL)
and dv.periodtype = 'W' and inds.indicator_type = 'Calculated data elements'
ORDER BY return_order;
Note that I create three separate views for indicators, data elements
and CDEs and union them together into a consolidated view. I use an
indicator group to distinguish between indicators and calculated data
elements.
Finally, the value field is defined in Excel as
=IF(denominatorvalue,numxfactor/denominatorvalue,numeratorvalue)
So, if there is a denominator value, then use a formula appropriate
for indicators, otherwise, just use the numerator value.
Hope this is helpful. The SQL is quite specific for our purposes, but
the approach could probably be adopted rather easily.
Comments/feedback welcome.
Best regards,
Jason
On Sat, Jul 21, 2012 at 12:00 PM, Kabango Malewezi
kmalew...@jhpiego.net wrote:
I get it I'll just
[Dhis2-users] Custom Combo Box
Dear Members I'm trying to have an element which will have a drop down list of months i.e Jan, Feb, Mar etc. I've used Option Set and attached it to the element BUT the drop down is not coming. What I'm I missing? I'm using Ver. 2.7 Kabango Malewezi | Database Specialist SSDI Services 2nd Floor, Pamodzi House, City Center, P.O Box 1091, Lilongwe, Malawi Tel: +265 (01) 776 412/3/4 | fax: +265 (01) 776 410 | Mobile: +265 (0) 88 4 245 431 kmalew...@jhpiego.net mailto:kmalew...@jhpiego.net%C2%A0 | www.jhpiego.orghttp://www.jhpiego.org/ Skype: kabango.malewezi | Twitter: kabangoM ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] Custom Combo Box
So there's no solution at the moment for my problem? Kabango Malewezi | Database Specialist SSDI Services 2nd Floor, Pamodzi House, City Center, P.O Box 1091, Lilongwe, Malawi Tel: +265 (01) 776 412/3/4 | fax: +265 (01) 776 410 | Mobile: +265 (0) 88 4 245 431 kmalew...@jhpiego.net | www.jhpiego.org Skype: kabango.malewezi | Twitter: kabangoM From: Lars Helge Øverland [larshe...@gmail.com] Sent: Friday, July 27, 2012 1:00 PM To: Kabango Malewezi Cc: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] Custom Combo Box Hello, the option sets will render only in data entry in person / tracker module, not in the aggregate data forms at the moment. We will implement this soon. Lars On Fri, Jul 27, 2012 at 12:20 PM, Kabango Malewezi kmalew...@jhpiego.net wrote: Dear Members I'm trying to have an element which will have a drop down list of months i.e Jan, Feb, Mar etc. I've used Option Set and attached it to the element BUT the drop down is not coming. What I'm I missing? I'm using Ver. 2.7 Kabango Malewezi | Database Specialist SSDI Services 2nd Floor, Pamodzi House, City Center, P.O Box 1091, Lilongwe, Malawi Tel: +265 (01) 776 412/3/4 | fax: +265 (01) 776 410 | Mobile: +265 (0) 88 4 245 431 kmalew...@jhpiego.net mailto:kmalew...@jhpiego.net%C2%A0 | www.jhpiego.orghttp://www.jhpiego.org/ Skype: kabango.malewezi | Twitter: kabangoM ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] Datamart
Noted. Sent from my BlackBerry® smartphone -Original Message- From: Bob Jolliffe bobjolli...@gmail.com Date: Fri, 20 Jul 2012 18:43:13 To: Ola Hodne Titlestadol...@ifi.uio.no Cc: Kabango Malewezikmalew...@jhpiego.net; dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] Datamart I guess another workaround might be to create simple naive indicators (ie denominator=1) but this could easily lead to indicator proliferation. On 20 July 2012 18:39, Ola Hodne Titlestad ol...@ifi.uio.no wrote: Jason, How do you handle the values in this view? Indicator values should be set up as a calculated field to let excel aggregate numerators and denominators separately for percentage values. If not the values for higher levels will be wrong. Or are you using only one orgunit level in this view? I guess it is possible to use two separate value fields for data elements and indicators in the same pivot table? Sounds confusing, but for a very specific/static table maybe but then I would recommend standard reports. Ola --- On Jul 20, 2012 7:24 PM, Kabango Malewezi kmalew...@jhpiego.net wrote: Hi Kabango, That is not possible. You can do it with report tables and standard reports. Ola --- On Jul 20, 2012 10:49 AM, Kabango Malewezi kmalew...@jhpiego.net wrote: Gentle People, I'd like to have Elements and indicators in one excel pivot table. How do I do that? The available views I have have either Pivot_Indicator or Pivot_Routinedata. Kabango Malewezi SSDI Services 2nd Floor, Pamodzi House, City Center, P.O Box 1091, Lilongwe, Malawi Tel: +265 (01) 776 412/3/4 | fax: +265 (01) 776 410 | Mobile: +265 (0) 88 4 245 431 kmalew...@jhpiego.net mailto:kmalew...@jhpiego.net | www.jhpiego.orghttp://www.jhpiego.org/ Skype: kabango.malewezi | Twitter: kabangoM ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] Custom Combo
Gentle People! How do I create a custom combo box? I want a combo box which show only months of the year i.e Jan, Feb etc. Thank you for your usual help. Kabango Malewezi | Database Specialist SSDI Services 2nd Floor, Pamodzi House, City Center, P.O Box 1091, Lilongwe, Malawi Tel: +265 (01) 776 412/3/4 | fax: +265 (01) 776 410 | Mobile: +265 (0) 88 4 245 431 kmalew...@jhpiego.net mailto:kmalew...@jhpiego.net | www.jhpiego.orghttp://www.jhpiego.org/ Skype: kabango.malewezi | Twitter: kabangoM ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] Datamart Problem
Dear Users
I'm new to DHIS and I have a problem.
After I run datamart, login, and download Metadata I cannot update Aggregate
data. Enclosed is the log file.
Kabango Malewezi | Database Specialist
SSDI Services
2nd Floor, Pamodzi House, City Center, P.O Box 1091, Lilongwe, Malawi
Tel: +265 (01) 776 412/3/4 | fax: +265 (01) 776 410 | Mobile: +265 (0) 88 4 245
431
kmalew...@jhpiego.net mailto:kmalew...@jhpiego.net |
www.jhpiego.orghttp://www.jhpiego.org/
Skype: kabango.malewezi | Twitter: kabangoM
making tmpdir
[Wed Jun 27 16:28:22 +0200 2012] [main] [debug] 'tmpdir:
C:/Users/KMALEW~1/AppData/Local/Temp/mydatamart_1988'
[Wed Jun 27 16:28:48 +0200 2012] [main] [debug] 'dhis(status) =
C:/Temp/Test.dmart open'
[Wed Jun 27 16:28:48 +0200 2012] [main] [debug] 'New datamart created at
C:/Temp/Test.dmart'
[Wed Jun 27 16:28:48 +0200 2012] [main] [debug] 'dhis(status) = No orgunit data
- you need to download metadata'
[Wed Jun 27 16:29:03 +0200 2012] [main] [debug] 'dhis(status) = Logging in to
http://localhost:8082'
[Wed Jun 27 16:29:03 +0200 2012] [dhisweb] [debug] '{Using sock1212 for
localhost:8082} {}'
[Wed Jun 27 16:29:03 +0200 2012] [main] [debug] 'Persisting url'
[Wed Jun 27 16:29:03 +0200 2012] [main] [debug] 'Persisting username'
[Wed Jun 27 16:29:03 +0200 2012] [dhisweb] [debug] '{Closing socket sock1212
(no connection info)}'
[Wed Jun 27 16:29:03 +0200 2012] [dhisweb] [debug] 'in loginCallback'
[Wed Jun 27 16:29:03 +0200 2012] [dhisweb] [debug] 'login success'
[Wed Jun 27 16:29:03 +0200 2012] [main] [debug] 'login status: LSUCCESS'
[Wed Jun 27 16:29:03 +0200 2012] [main] [debug] 'dhis(status) = Logged in'
[Wed Jun 27 16:29:07 +0200 2012] [dhisweb] [debug] 'fetching metadata'
[Wed Jun 27 16:29:07 +0200 2012] [dhisweb] [debug] '{Using sock1228 for
localhost:8082} {}'
finally
[Wed Jun 27 16:29:07 +0200 2012] [main] [debug] 'dhis(status) = Downloading
metadata'
[Wed Jun 27 16:29:07 +0200 2012] [main] [debug] 'Metadata download success'
[Wed Jun 27 16:29:07 +0200 2012] [main] [debug] 'extracting zip'
[Wed Jun 27 16:29:07 +0200 2012] [main] [debug] 'transforming metadata'
[Wed Jun 27 16:29:07 +0200 2012] [main] [debug] 'dhis(status) = Transforming
metadata'
[Wed Jun 27 16:29:07 +0200 2012] [dhisweb] [debug] '{Closing socket sock1228
(no connection info)}'
[Wed Jun 27 16:29:07 +0200 2012] [dhisweb] [debug] 'Metadata download done:
HTTP/1.1 200 OK'
[Wed Jun 27 16:29:12 +0200 2012] [main] [debug] 'transform: Done'
[Wed Jun 27 16:29:12 +0200 2012] [main] [debug] 'Transform metadata done'
[Wed Jun 27 16:29:12 +0200 2012] [main] [debug] 'dhis(status) = Importing
metadata'
[Wed Jun 27 16:29:12 +0200 2012] [main] [debug] 'dhis(status) = Generating
views'
[Wed Jun 27 16:29:13 +0200 2012] [main] [debug] 'dhis(status) = Metadata import
done'
[Wed Jun 27 16:29:15 +0200 2012] [main] [debug] 'Persisting myorgunit'
[Wed Jun 27 16:29:15 +0200 2012] [main] [debug] 'Persisting myorgunitid'
[Wed Jun 27 16:29:15 +0200 2012] [main] [debug] 'Persisting parentorgunit'
[Wed Jun 27 16:29:15 +0200 2012] [main] [debug] 'Persisting parentorgunitid'
[Wed Jun 27 16:29:18 +0200 2012] [main] [debug] 'Persisting myorgunit'
[Wed Jun 27 16:29:18 +0200 2012] [main] [debug] 'Persisting myorgunitid'
[Wed Jun 27 16:29:18 +0200 2012] [main] [debug] 'Persisting parentorgunit'
[Wed Jun 27 16:29:18 +0200 2012] [main] [debug] 'Persisting parentorgunitid'
[Wed Jun 27 16:29:20 +0200 2012] [main] [debug] 'Persisting myorgunit'
[Wed Jun 27 16:29:20 +0200 2012] [main] [debug] 'Persisting myorgunitid'
[Wed Jun 27 16:29:20 +0200 2012] [main] [debug] 'Persisting parentorgunit'
[Wed Jun 27 16:29:20 +0200 2012] [main] [debug] 'Persisting parentorgunitid'
[Wed Jun 27 16:29:23 +0200 2012] [main] [debug] 'Persisting myorgunit'
[Wed Jun 27 16:29:23 +0200 2012] [main] [debug] 'Persisting myorgunitid'
[Wed Jun 27 16:29:23 +0200 2012] [main] [debug] 'Persisting parentorgunit'
[Wed Jun 27 16:29:23 +0200 2012] [main] [debug] 'Persisting parentorgunitid'
[Wed Jun 27 16:29:26 +0200 2012] [main] [debug] 'level and orgunit are set. ok
to download'
[Wed Jun 27 16:29:26 +0200 2012] [main] [debug] 'level select from
.win.display.ou.level is 4'
[Wed Jun 27 16:29:26 +0200 2012] [main] [debug] 'Persisting level'
[Wed Jun 27 16:29:30 +0200 2012] [main] [debug] 'last: 197912 ; current: 201206'
179 4 1 297 174 179 {} {} {} {}
[Wed Jun 27 16:29:38 +0200 2012] [main] [debug] 'Download periods 20120101
20120628'
[Wed Jun 27 16:29:38 +0200 2012] [main] [debug] 'dhis(status) = Downloading
aggregate data'
delete old values
[Wed Jun 27 16:29:38 +0200 2012] [main] [debug] 'Downloading for monthly
datavalue'
[Wed Jun 27 16:29:38 +0200 2012] [dhisweb] [debug] 'fetching monthly DataValues
with : JSESSIONID=2k70yo4s50oc1kade1bwqbs8x'
[Wed Jun 27 16:29:38 +0200 2012] [dhisweb] [debug] 'http params:
dataSourceLevel=4dataSourceRoot=179startDate=20120101endDate=20120628'
[Wed Jun 27 16:29:38 +0200 2012] [dhisweb] [debug] '{Using sock764 for
localhost:8082
