Re: [Dhis2-devs] Data Set Report is not Downloading

2017-01-27 Thread Calle Hedberg 
Elmarie,

We have cleaned up many of the special characters in the data element and
indicator table fields, but a number remains (in particular full stops and
commas). There might be a few others - it's a lot to go through and a lot
of problems to clean up.

Exactly which special character caused the problem in the case you refer to?

Regards
calle

On 27 January 2017 at 15:39, gerald thomas  wrote:

> Dear Elmarie,
>
> I had done Data Integrity Checks but i don't know which option is
> responsible for dataelements names with special characters. Besides we
> had been doing data cleanup and we fixed most of those issues.
>
> On 1/27/17, Elmarie Claasen  wrote:
> > Gerald,
> >
> > We had the same problem so e toime back. Check that you dont have any
> > special characters in dataelement names.
> >
> > Elmarie
> >
> > On 27 Jan 2017 14:29, "gerald thomas"  wrote:
> >
> >> Dear All,
> >> We had successfully upgraded to version 2.25 but i noticed that we
> >> can't download to excel or PDF our data set reports.
> >>
> >> Please i don't know if it is a bug but it is working on the DHIS2 demo
> >> but not on our production server.
> >>
> >> Thanks in advance for your help.
> >>
> >> --
> >> Regards,
> >>
> >> Gerald
> >>
> >> ___
> >> Mailing list: https://launchpad.net/~dhis2-devs
> >> Post to : dhis2-devs@lists.launchpad.net
> >> Unsubscribe : https://launchpad.net/~dhis2-devs
> >> More help   : https://help.launchpad.net/ListHelp
> >>
> >
> > --
> >
> >
> > *This message and any attachments are subject to a disclaimer published
> at
> > http://www.hisp.org/policies.html#comms_disclaimer
> > .  Please read the
> > disclaimer before opening any attachment or taking any other action in
> > terms of this electronic transmission.  If you cannot access the
> > disclaimer, kindly send an email to disclai...@hisp.org
> >  and a copy will be provided to you. By replying to
> > this e-mail or opening any attachment you agree to be bound by the
> > provisions of the disclaimer.*
> >
>
>
> --
> Regards,
>
> Gerald
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>



-- 

***

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedb...@gmail.com

Skype: calle_hedberg

***
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Tomcat error

2017-01-27 Thread gerald thomas 
Dear All,

What is the meaning of this error:

* ERROR 2017-01-05 12:03:07,593 ERROR: duplicate key value violates
unique constraint "datavalue_pkey"
  Detail: Key (dataelementid, periodid, sourceid,
categoryoptioncomboid, attributeoptioncomboid)=(1973, 2784149, 301,
13, 13) already exists.

Please find the attached copy of catalina.out log file

-- 
Regards,

Gerald


Part of catalina.out
Description: Binary data
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Organisational Units Names

2017-01-27 Thread Lars Helge Øverland 
It will.

On Thu, Jan 26, 2017 at 9:08 PM, Barnabas Akumba 
wrote:

> Hello Lars,
>
> Could you please confirm that the link below will get the latest release:
>
> https://www.dhis2.org/download/releases/2.24/dhis.war
>
> Regards.
>
> On Thu, Jan 26, 2017 at 4:14 PM, Lars Helge Øverland 
> wrote:
>
>> Hi Barnabas,
>>
>> yes it should be okay now. Can you download the latest 2.24 and try again?
>>
>> On Thu, Jan 26, 2017 at 2:12 PM, Barnabas Akumba 
>> wrote:
>>
>>> Hello Lars,
>>>
>>> Any update on this? Have realised that the issue is with both the GIS
>>> and Visualiser App.
>>>
>>> Regards
>>>
>>> On Mon, Jan 23, 2017 at 8:14 PM, Lars Helge Øverland 
>>> wrote:
>>>
 I suspect this is a bug related to GIS and the API syntax for renaming
 properties. Will get back soon.

 Lars


 On Mon, Jan 23, 2017 at 9:01 AM, Barnabas Akumba  wrote:

> Hello Lars,
>
> I've cleared the Server cache and browser cache as recommended but no
> luck.
>
> Regards
>
>
> On Mon, Jan 23, 2017 at 8:39 AM, Lars Helge Øverland 
> wrote:
>
>> Hi Barnabas,
>>
>> you might need to clear the server side nginx cache, then restart
>> nginx. Did you install your DHIS 2 instance using the "server tools"? On
>> linux you can do this with:
>>
>>
>> sudo rm /var/cache/nginx -rf
>> sudo service nginx restart
>>
>>
>>
>> Then clear your browser cache again.
>>
>> regards,
>>
>> Lars
>>
>>
>>
>>
>> On Mon, Jan 23, 2017 at 8:33 AM, Morten Olav Hansen > > wrote:
>>
>>> Ok, so at least the org units themselves have proper names. Maybe
>>> Jan has an idea of why its not working?
>>>
>>> --
>>> Morten Olav Hansen
>>> Senior Engineer, DHIS 2
>>> University of Oslo
>>> http://www.dhis2.org
>>>
>>> On Mon, Jan 23, 2017 at 2:26 PM, Barnabas Akumba <
>>> akumbaba...@gmail.com> wrote:
>>>
 Hello Morten,

 Please find attached output from the api query.

 Regards

 On Mon, Jan 23, 2017 at 8:20 AM, Morten Olav Hansen <
 mor...@dhis2.org> wrote:

> Hi
>
> Could you please also try /api/organisationUnits.json and
> see if they have proper names there?
>
> --
> Morten Olav Hansen
> Senior Engineer, DHIS 2
> University of Oslo
> http://www.dhis2.org
>
> On Mon, Jan 23, 2017 at 2:04 PM, Knut Staring 
> wrote:
>
>> You should probably refresh or do something until you see some
>> red error messages... The network tab may also be of interest
>>
>> On Jan 23, 2017 1:59 PM, "Barnabas Akumba" 
>> wrote:
>>
>>> Hello Knut,
>>>
>>> Please find attached.
>>>
>>> Regards
>>>
>>> On Mon, Jan 23, 2017 at 7:55 AM, Knut Staring 
>>> wrote:
>>>
 You still have not provided us with a screenshot of your chrome
 browser console.

 On Mon, Jan 23, 2017 at 1:53 PM, Barnabas Akumba <
 akumbaba...@gmail.com> wrote:

> Hello Prosper,
>
> The only script specified in the upgrade instruction is "Run
> the database SQL upgrade script
> 
>  once
> before updating the WAR file. It only applies if you have set up 
> program
> rules for your system.". This is to be done during the upgrade 
> from 2.22 to
> 2.23. But as you can see it is optional as we don't have program 
> rules on
> our system.
>
> Regards
>
> On Mon, Jan 23, 2017 at 5:36 AM, Prosper BT  > wrote:
>
>> Hi Barnaba,
>>
>> Am not a server guy but hope you run the required scripts as
>> guided in the upgrade package.
>>
>> Sometimes I ask the server guys to clear nginx cache
>>
>> Regards
>>
>> Prosper Behumbiize, MPH
>> DHIS2 Implementation| HISP Uganda
>> +256 752 751 776 | +256 776 139 139
>> pros...@hispuganda.org  | prosp
>> e...@dhis2.org | Skype: prospertb
>>
>> On Sat, Jan 21, 2017 at 2:16 PM, Barnabas Akumba <
>> akumbaba...@gmail.com> wrote:
>>
>>> Here attached output

Re: [Dhis2-devs] Adding demo data to new server

2017-01-27 Thread Yaw Anokwa 
Hi all,

I finally got a chance to try this out again and it's now working with
Ubuntu 16, OpenJDK 1.8, Tomcat 8, PostgreSQL 9.5, and PostGIS 2.2.
What worked best was using a separate DB for the demo data.

I've posted my config (Vagrant, Ansible) to
https://github.com/nafundi/dhis2-vagrant. Hope it helps someone!

Thanks,

Yaw

On Wed, Jan 18, 2017 at 5:58 PM, Lars Helge Øverland  wrote:
> Hi Yaw,
>
> that error is not something I've seen previously.
>
> Try going to apps > data administration > resource tables and generate them
> manually.
>
> Alternatively try to drop all tables starting wit _ (underscore) manually
> from the database, then try again.
>
> https://play.dhis2.org/demo/dhis-web-maintenance-dataadmin/displayResourceTableForm.action
>
> You can also check out the very latest demo databases from Github:
>
> https://github.com/dhis2/dhis2-demo-db
>
>
> regards,
>
> Lars
>
>
>
>
>
> On Wed, Jan 18, 2017 at 11:50 AM, Knut Staring  wrote:
>>
>> Hi Yaw,
>>
>> Not sure what causes this, just wanted to check with you which version of
>> Postgres you are using since I remember there were some issues with the
>> latest version (9.6)
>>
>>
>>
>> On Wed, Jan 18, 2017 at 9:55 AM, Yaw Anokwa  wrote:
>>>
>>> Thanks Jason for that tip. Seems like the DB isn't very happy.
>>>
>>> The export fails with this:
>>> 2017-01-18 08:53:54Process failed: StatementCallback; bad SQL grammar
>>> [alter table _orgunitstructure_temp rename to _orgunitstructure;];
>>> nested exception is org.postgresql.util.PSQLException: ERROR: relation
>>> "_orgunitstructure" already exists
>>> 2017-01-18 08:53:54Updating resource tables
>>> 2017-01-18 08:53:54Analytics table update process started
>>>
>>> http://dpaste.com/0MCMKSA is the full trace from Tomcat.
>>>
>>> On Wed, Jan 18, 2017 at 3:23 PM, Jason Pickering
>>>  wrote:
>>> > You will need to run analytics
>>> >
>>> > https://docs.dhis2.org/master/en/user/html/ch30.html
>>> >
>>> > Regards,
>>> > Jason
>>> >
>>> >
>>> > On Wed, Jan 18, 2017 at 9:14 AM, Yaw Anokwa 
>>> > wrote:
>>> >>
>>> >> Thanks for your patience, and my apologies! You were correct.
>>> >>
>>> >> I've now confirmed that I'm now connected to the PostgreSQL DB and the
>>> >> login page reads Sierra Leone.
>>> >>
>>> >> How now do I get the various dashboards that are present in the public
>>> >> demo?
>>> >>
>>> >> Yaw
>>> >>
>>> >> On Wed, Jan 18, 2017 at 11:54 AM, Knut Staring 
>>> >> wrote:
>>> >> > I would really double check that db connection. You would see what
>>> >> > you
>>> >> > see
>>> >> > if you were currently connected to the internal in-memory H2 db
>>> >> > rather
>>> >> > than
>>> >> > Postgres. What does your tomcat log say? Did you create DHIS_HOME?
>>> >> >
>>> >> >
>>> >> > On Jan 18, 2017 5:36 AM, "Yaw Anokwa"  wrote:
>>> >> >>
>>> >> >> Hi Knut,
>>> >> >>
>>> >> >> Thanks for the speedy response. I know what DB I'm connected to, so
>>> >> >> that's not the problem. I think maybe my email was not clear, so
>>> >> >> let
>>> >> >> me try again!
>>> >> >>
>>> >> >> I'm on a new server (not a Live install) with DHIS installed. I
>>> >> >> have
>>> >> >> imported the demo data from the DHIS 2 Demo zip file into the DB on
>>> >> >> that new server.
>>> >> >>
>>> >> >> But when I go look at the web interface of said server, it doesn't
>>> >> >> look like what I expect. That is, there is nothing that suggests
>>> >> >> that
>>> >> >> the demo data has been imported. The UI doesn't look like the
>>> >> >> Sierra
>>> >> >> Leone demo server at https://play.dhis2.org/demo.
>>> >> >>
>>> >> >> Yaw
>>> >> >>
>>> >> >> On Wed, Jan 18, 2017 at 10:47 AM, Knut Staring 
>>> >> >> wrote:
>>> >> >> > Hi Yaw,
>>> >> >> > Please click on the gray circle in the upper right corner and
>>> >> >> > select
>>> >> >> > About
>>> >> >> > DHIS2,
>>> >> >> > https://play.dhis2.org/demo/dhis-web-commons-about/about.action.
>>> >> >> >
>>> >> >> > There you can see what db you are connected to. This is set in
>>> >> >> > the
>>> >> >> > conf/dhis.conf file for DHIS Live.
>>> >> >> >
>>> >> >> > Knut
>>> >> >> >
>>> >> >> >
>>> >> >> > On Jan 18, 2017 3:42 AM, "Yaw Anokwa" 
>>> >> >> > wrote:
>>> >> >> >>
>>> >> >> >> Hi all,
>>> >> >> >>
>>> >> >> >> I've setup DHIS 2.25 on my server and I've successfully imported
>>> >> >> >> the
>>> >> >> >> demo data from
>>> >> >> >> https://www.dhis2.org/download/resources/2.25/dhis2-demo.zip
>>> >> >> >> into the DB (see my-db.png).
>>> >> >> >>
>>> >> >> >> But, when I log into my server, it doesn't look like the demo
>>> >> >> >> server
>>> >> >> >> at https://play.dhis2.org/demo/. I've attached screenshots. Am I
>>> >> >> >> missing something?
>>> >> >> >>
>>> >> >> >> Thanks,
>>> >> >> >>
>>> >> >> >> Yaw
>>> >> >> >>
>>> >> >> >> ___
>>> >> >> >>

Re: [Dhis2-devs] Data viz app: OrgUnit tree names not appearing (children API call not passing correctly encoded parameters)

2017-01-27 Thread Blake Hansen 
Dear Alex,

I have also seen and reported this and believe a fix is being worked on 
currently. 

All best,
Blake


-- 




Blake Hansen
Projects Implementation Manager, BAO Systems
+1 202-536-1541 | bhan...@baosystems.com  | 
http://www.baosystems.com  |
Skype: blake.a.hansen |  2900 K Street, Suite 404, Washington D.C. 20007

> On 27 Jan 2017, at 13:34, alexandre.vanobberg...@unibas.ch wrote:
> 
> Hi 
> 
> We updated an instance (2.24 / 23578) to the latest build (2.24 / 8282ca3) 
> and noticed that the org unit tree in the data visualizer app is not 
> displaying names of orgunits. 
> 
> 
> 
> The API call to get them would be: 
> GET 
> /api/organisationUnits/HY7fC5c8lXF.json?fields=children[id,displayName|rename(name),children::isNotEmpty|rename(hasChildren)=false
>  
> 
> response: 
> { 
> 
> "children": [ 
> { 
> "id": "tOixAuufpk1", 
> "hasChildren": true, 
> "name": "One" 
> }, 
> { 
> "id": "r3D8BkVf4PA", 
> "hasChildren": true, 
> "name": "Two" 
> } 
> ] 
> 
> } 
> 
> 
> but it calls instead: 
> GET 
> /api/organisationUnits/HY7fC5c8lXF.json?fields=children%5Bid,displayName%7Crename(name),children::isNotEmpty%7Crename(hasChildren)=false
>  
> 
> response: 
> 
> { 
> 
> "children": [ 
> { 
> "id": "r3D8BkVf4PA" 
> }, 
> { 
> "id": "tOixAuufpk1" 
> } 
> ] 
> 
> } 
> 
> DB is identical / tested in incognito mode, Firefox & Chrome. Do you have any 
> hints on why this happens? 
> 
> Thanks 
> Alex
> 
> --
> This email and any files transmitted with it are confidential and intended 
> solely for the use of the individual or entity to whom they are addressed. If 
> you have received this email in error, please notify us immediately by reply 
> e-mail and delete this message from your system.
> --___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Data viz app: OrgUnit tree names not appearing (children API call not passing correctly encoded parameters)

2017-01-27 Thread alexandre . vanobberghen 
Hi

We updated an instance (2.24 / 23578) to the latest build (2.24 / 8282ca3) 
and noticed that the org unit tree in the data visualizer app is not 
displaying names of orgunits.



The API call to get them would be: 
GET 
/api/organisationUnits/HY7fC5c8lXF.json?fields=children[id,displayName|rename(name),children::isNotEmpty|rename(hasChildren)=false

response:
{

"children": [
{
"id": "tOixAuufpk1",
"hasChildren": true,
"name": "One"
},
{
"id": "r3D8BkVf4PA",
"hasChildren": true,
"name": "Two"
}
]

}


but it calls instead:
GET 
/api/organisationUnits/HY7fC5c8lXF.json?fields=children%5Bid,displayName%7Crename(name),children::isNotEmpty%7Crename(hasChildren)=false

response:

{

"children": [
{
"id": "r3D8BkVf4PA"
},
{
"id": "tOixAuufpk1"
}
]

}

DB is identical / tested in incognito mode, Firefox & Chrome. Do you have 
any hints on why this happens?

Thanks
Alex

--
This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed. 
If you have received this email in error, please notify us immediately by 
reply e-mail and delete this message from your system.
--___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Data Set Report is not Downloading

2017-01-27 Thread Elmarie Claasen 
Gerald,

We had the same problem so e toime back. Check that you dont have any
special characters in dataelement names.

Elmarie

On 27 Jan 2017 14:29, "gerald thomas"  wrote:

> Dear All,
> We had successfully upgraded to version 2.25 but i noticed that we
> can't download to excel or PDF our data set reports.
>
> Please i don't know if it is a bug but it is working on the DHIS2 demo
> but not on our production server.
>
> Thanks in advance for your help.
>
> --
> Regards,
>
> Gerald
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>

-- 


*This message and any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer 
.  Please read the 
disclaimer before opening any attachment or taking any other action in 
terms of this electronic transmission.  If you cannot access the 
disclaimer, kindly send an email to disclai...@hisp.org 
 and a copy will be provided to you. By replying to 
this e-mail or opening any attachment you agree to be bound by the 
provisions of the disclaimer.*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Data Set Report is not Downloading

2017-01-27 Thread gerald thomas 
Dear All,
We had successfully upgraded to version 2.25 but i noticed that we
can't download to excel or PDF our data set reports.

Please i don't know if it is a bug but it is working on the DHIS2 demo
but not on our production server.

Thanks in advance for your help.

-- 
Regards,

Gerald

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp