[Dhis2-devs] [Bug 1230084] Re: Indicators returns zero values after import..DHIS2 live version

2013-09-24 Thread Mathayo Mihayo
Also i have run the analytics..and the data elements retrieve the aggregated value as usual but the problem comes when i try to retrieve indicator values -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/b

[Dhis2-devs] [Bug 1230084] [NEW] Indicators returns zero values after import..DHIS2 live version

2013-09-24 Thread Mathayo Mihayo
Public bug reported: Hello! DHIS2 developers,am facing an issue when trying to generate a report based on defined indicators where by the dhis2 return zero value in the server but in my local machine it returns the required values..what could be the problem? mind you that i have imported the meta

[Dhis2-devs] Về: SMS Command Single Event

2013-09-24 Thread ngo long
Hi Snorre , It's seem to me that you're using the dhis-api to get the list of ProgramStageDataElement . Why don't you just use the normal program service to get the Program object and from that you can easily get the ProgramStageDataElement list. Long   Ngo Th

[Dhis2-devs] Update/ Reassign Organization Unit in Dataset, User, Person And Program- program BUGs

2013-09-24 Thread Uddin Fatema
Dear All, We are using dhis2 Version:2.12 Build revision:11301 We have one problem with Organization Unite reassign update to Dataset, User, person and programs - program. Step 1: When i edit Dataset that time the organization unite list not coming showing Progess sign for long time but list is

[Dhis2-devs] SMS Command Single Event

2013-09-24 Thread Snorre Olimstad
Hi. I'm working on registration of single events through SMS, but I struck a problem and hope somebody can help me. In 2.12 you can create a SMS command connected to a dataset, then edit the command and create codes that is tied to the data elements. Single event is not connected to data sets,

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 12230: (GIS) Multiple orgunit selection modes + Data set completeness + Relative periods.

2013-09-24 Thread noreply
Merge authors: Jan Henrik Øverland (janhenrik-overland) revno: 12230 [merge] committer: Jan Henrik Overland branch nick: dhis2 timestamp: Tue 2013-09-24 18:47:51 +0200 message: (GIS) Multiple orgunit selection modes + Data set comple

Re: [Dhis2-devs] Metadata api and groups/groupsets

2013-09-24 Thread Bob Jolliffe
Jason has just suggested posting the orgunit directly to the orgUnit resource endpoint (together with its groups). That should work. Perhaps there is a viewClass option I can use on the metaData option which achieves the same result. I'll check ... On 24 September 2013 17:22, Bob Jolliffe wro

[Dhis2-devs] Metadata api and groups/groupsets

2013-09-24 Thread Bob Jolliffe
I've been grappling with a problem exporting and importing orgunit metadata which I'd like to share some thoughts on. Two dhis2 instances (in Rwanda) have slightly different sets of orgunits. So we are trying to rationalize and combine them - in most cases a union of the two with some shuffling a

Re: [Dhis2-devs] Upgrade from 2.10 to 2.12 failing

2013-09-24 Thread Lars Helge Øverland
> > > > Although again a little off-topic to the original post, the reason why > this happened is still not 100% clear to me, but seems to be have been > introduced with a script which I wrote to convert datasets to data element > groups (so that they could be used in MyDatamart). I have previously

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 12229: Minor fix

2013-09-24 Thread noreply
revno: 12229 committer: Lars Helge Øverland branch nick: dhis2 timestamp: Tue 2013-09-24 17:35:46 +0200 message: Minor fix modified: dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-patient/src/main/webapp/dhis-web-maintena

Re: [Dhis2-devs] Upgrade from 2.10 to 2.12 failing

2013-09-24 Thread Jason Pickering
Hi Lars, Yes, I think this makes sense. Having a mechanism to sort through the fatal versus non-fatal errors would be good, but in this case, it seems to be pretty difficult, as you are only getting an SQL exception. There are lots of these and errors, but only this one proved to be fatal. Althou

[Dhis2-devs] Important Bugs in Individual records.

2013-09-24 Thread helder yesid castrillon cobo
Hi, Since the last week I reported in Dhis2-users about some problems that it has been happening with individual records in version 2.12, revision 11296 /11306 (tested in Firefox, chrome and internet explorer). But like I have not received response then I am reporting the bugs again. 1) When D

Re: [Dhis2-devs] Upgrade from 2.10 to 2.12 failing

2013-09-24 Thread Lars Helge Øverland
Hi Jason, sorry for late reply. Like you figured out, changing the log level is the best approach here. We emit a debug-level log message when this fails - reason it simply that it is hard to distinguish between failures caused by the constraint to already be in place (which is normal after the fi

Re: [Dhis2-devs] Upgrade from 2.10 to 2.12 failing

2013-09-24 Thread Jason Pickering
As it turns out, there were somehow (which I have no clue how this happened) duplicated UIDs in the dataelementgroup table. This caused at error only visible when changing the logging level to debug, which gave a clue. * DEBUG 2013-09-24 14:54:18,868 Testing a Connection in response to an Except

Re: [Dhis2-devs] [Bug 1229106] Re: v2.12 Data Entry form data does not print

2013-09-24 Thread Lars Helge Øverland
That is correct. So if you need textual data we will have to make an option in the system here - printing data entry forms with and without data values. Feel free to write a blueprint (request for functionality): https://blueprints.launchpad.net/dhis2 regards, Lars On Mon, Sep 23, 2013 at 1:3

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 12228: Mapviews, putting data on rows

2013-09-24 Thread noreply
revno: 12228 committer: Lars Helge Øverland branch nick: dhis2 timestamp: Tue 2013-09-24 15:41:13 +0200 message: Mapviews, putting data on rows modified: dhis-2/dhis-api/src/main/java/org/hisp/dhis/mapping/MapView.java -- lp:dhis2

Re: [Dhis2-devs] Upgrade from 2.10 to 2.12 failing

2013-09-24 Thread Jason Pickering
Hi Gerald, Although this is off the topic of this post, you can change the password of any user in a Postgresql database by executing sudo -u postgres psql -c "ALTER USER WITH password '';" in case you have forgotten it. Just replace and with their appropriate values. You will obviously ne

Re: [Dhis2-devs] Upgrade from 2.10 to 2.12 failing

2013-09-24 Thread Jason Pickering
Hi Knut, Yeah, I tried this as well, with the same result. I tried going from 2.10 to 2.12. Rolled back to the original database (2.10) , and tried to go from 2.10 to 2.11 and then 2.12. 2.11 manages to start, but with a lot of errors like... Failed to upgrade expression: ([26.13]*1)+([27.13]*1

Re: [Dhis2-devs] Upgrade from 2.10 to 2.12 failing

2013-09-24 Thread Knut Staring
Hi Jason, are you sure you don't need to do 2.11 first? Den 24. sep. 2013 19:01 skrev "Jason Pickering" følgende: > Hi Gerald, > > I have done all of this already. Sorry, my procedure was not really > detailed enough (kill Tomcat, remove WAR, remove directory in webapps, > download WAR, restart

Re: [Dhis2-devs] Upgrade from 2.10 to 2.12 failing

2013-09-24 Thread Gerald Thomas
Gomez, This had been a question I posted before but I didn't get response. Now when I am trying to backup my database using that command; it is asking me for a password for the dhis account. The dhis password which I am expecting to be on the hibernate file is not working. Any help with that???

Re: [Dhis2-devs] Upgrade from 2.10 to 2.12 failing

2013-09-24 Thread Gomez Phiri
I see, all the best then. Date: Tue, 24 Sep 2013 13:56:11 +0200 Subject: Re: [Dhis2-devs] Upgrade from 2.10 to 2.12 failing From: jason.p.picker...@gmail.com To: gomezph...@hotmail.com CC: dhis2-devs@lists.launchpad.net Hi Gomez,Thanks, as I mentioned before. This is something related to this p

Re: [Dhis2-devs] Upgrade from 2.10 to 2.12 failing

2013-09-24 Thread Jason Pickering
Hi Gomez, Thanks, as I mentioned before. This is something related to this particular database. This has been an issue in the past with some database, but may not be a general problem. I was seeking advice from the developers about what the potential metadata issue could be, as the logs are not v

Re: [Dhis2-devs] Upgrade from 2.10 to 2.12 failing

2013-09-24 Thread Gomez Phiri
OOoops! I forgot the most important part, replacing the war file. It should be step 2 😊 From: gomezph...@hotmail.com To: jason.p.picker...@gmail.com; dhis2-devs@lists.launchpad.net Date: Tue, 24 Sep 2013 13:51:57 +0200 Subject: Re: [Dhis2-devs] Upgrade from 2.10 to 2.12 failing Hi Jason, I jus

Re: [Dhis2-devs] Upgrade from 2.10 to 2.12 failing

2013-09-24 Thread Gomez Phiri
Hi Jason, I just upgraded our demo server from 2.10 to 2.12 today. This is what I did to avoid all the troubles. Steps service tomcat stopback up database "pg_dump dhis2 -U dhis | gzip > db.gz" Our database is large so I had to compress it with gzip.restart postgressu postgres psqlDROP DATABASE

Re: [Dhis2-devs] Upgrade from 2.10 to 2.12 failing

2013-09-24 Thread Gerald Thomas
Jason, Please can you send us your log file Sent from my BlackBerry® smartphone from Airtel Sierra Leone -Original Message- From: Jason Pickering Date: Tue, 24 Sep 2013 11:00:54 To: Cc: Subject: Re: [Dhis2-devs] Upgrade from 2.10 to 2.12 failing Hi Gerald,  I have done all of this

Re: [Dhis2-devs] Upgrade from 2.10 to 2.12 failing

2013-09-24 Thread Jason Pickering
Hi Gerald, I have done all of this already. Sorry, my procedure was not really detailed enough (kill Tomcat, remove WAR, remove directory in webapps, download WAR, restart Tomcat) It is likely a structural problem or metadata problem with my particular database. On other databases, it works fine

Re: [Dhis2-devs] Upgrade from 2.10 to 2.12 failing

2013-09-24 Thread Gerald Thomas
Jason, I had done those procedures before and I had not experience such issues. What I think should be done is to stop the tomcat, copy route file somewhere else and delete it. Then put the new war file and restart tomcat. Sent from my BlackBerry® smartphone from Airtel Sierra Leone -Origina

Re: [Dhis2-devs] Upgrade from 2.10 to 2.12 failing

2013-09-24 Thread Jason Pickering
Hi Gerald, There is no procedure for this really other than replacing the WAR file. When you move from 2.10 to 2.12, you simply replace the old WAR file with the new one, and the application is supposed to ugprade itself automatically. However in this case, it does not , which indicates a problem

Re: [Dhis2-devs] Upgrade from 2.10 to 2.12 failing

2013-09-24 Thread Gerald Thomas
You said, you are stuck on step 4/10 which means you have means you have an upgrade procedure installation file. That is the file I want you to share with me. Sent from my BlackBerry® smartphone from Airtel Sierra Leone -Original Message- From: Jason Pickering Date: Tue, 24 Sep 2013 10

Re: [Dhis2-devs] Upgrade from 2.10 to 2.12 failing

2013-09-24 Thread Gerald Thomas
Please can you share the steps file you are using with me. Thanks in advance. Sent from my BlackBerry® smartphone from Airtel Sierra Leone -Original Message- From: Jason Pickering Date: Tue, 24 Sep 2013 10:26:56 To: Subject: [Dhis2-devs] Upgrade from 2.10 to 2.12 failing Using the l

[Dhis2-devs] Upgrade from 2.10 to 2.12 failing

2013-09-24 Thread Jason Pickering
Using the latest 2.12 build from Jenkins. Looks like something is failing on the startup, but not sure what? This DB runs fine on 2.10. The first time around, a bunch of timestamps were updated. I killed the server, restarted, but still getting stuck at step 4 /10. Any tips? Regards, Jason *

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 12227: Web api, using current user if no user set for analytical objects

2013-09-24 Thread noreply
revno: 12227 committer: Lars Helge Øverland branch nick: dhis2 timestamp: Tue 2013-09-24 11:43:55 +0200 message: Web api, using current user if no user set for analytical objects modified: dhis-2/dhis-services/dhis-service-core/src/

Re: [Dhis2-devs] [Bug 1229494] Re: Aggregate of Avg type field is summed across Org Units

2013-09-24 Thread Ola Hodne Titlestad
When it comes to e.g. population or staffing numbers it makes sense to sum on orgunit and average on time, so don't think we are planning to change the default behaviour here. That said, from the use case Jason described it probably makes sense to also support average on orgunit dimension, but the

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 12226: add getAll(ProgramInstance, ProgramStage) method to programStageInstanceStore/Service, useful for...

2013-09-24 Thread noreply
revno: 12226 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Tue 2013-09-24 11:31:28 +0200 message: add getAll(ProgramInstance, ProgramStage) method to programStageInstanceStore/Service, useful for cases where you have rep

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 12225: Analytics, added period type column to event analytics tables

2013-09-24 Thread noreply
revno: 12225 committer: Lars Helge Øverland branch nick: dhis2 timestamp: Tue 2013-09-24 11:29:24 +0200 message: Analytics, added period type column to event analytics tables modified: dhis-2/dhis-services/dhis-service-analytics/src

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 12224: various fixes for multi-stage programs in tracker web-api, also more tests

2013-09-24 Thread noreply
revno: 12224 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Tue 2013-09-24 11:10:26 +0200 message: various fixes for multi-stage programs in tracker web-api, also more tests modified: dhis-2/dhis-api/src/main/java/org/hi

[Dhis2-devs] [Merge] lp:~sis-ma/dhis2/SISMA-362 into lp:dhis2

2013-09-24 Thread Leandro Soares
Leandro Soares has proposed merging lp:~sis-ma/dhis2/SISMA-362 into lp:dhis2. Requested reviews: DHIS 2 core developers (dhis2-devs-core) For more details, see: https://code.launchpad.net/~sis-ma/dhis2/SISMA-362/+merge/187168 -- https://code.launchpad.net/~sis-ma/dhis2/SISMA-362/+merge/187168

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 12223: minor

2013-09-24 Thread noreply
revno: 12223 committer: Lai branch nick: dhis2 timestamp: Tue 2013-09-24 15:21:12 +0700 message: minor modified: dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/sms/UnregisteredSMSListener.java -- lp:dhis2 https

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 12222: Minor

2013-09-24 Thread noreply
revno: 1 committer: Lars Helge Øverland branch nick: dhis2 timestamp: Tue 2013-09-24 10:11:36 +0200 message: Minor modified: dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/AnalyticsTableService

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 12221: Moved some resourcetable code to ResourceTableTask

2013-09-24 Thread noreply
revno: 12221 committer: Lars Helge Øverland branch nick: dhis2 timestamp: Tue 2013-09-24 09:41:09 +0200 message: Moved some resourcetable code to ResourceTableTask modified: dhis-2/dhis-api/src/main/java/org/hisp/dhis/resourcetable/

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 12220: Resource tables, avoiding outer transaction for generate all method

2013-09-24 Thread noreply
revno: 12220 committer: Lars Helge Øverland branch nick: dhis2 timestamp: Tue 2013-09-24 09:18:23 +0200 message: Resource tables, avoiding outer transaction for generate all method modified: dhis-2/dhis-services/dhis-service-adminis

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 12219: Impl dateperiodstructure resource table

2013-09-24 Thread noreply
revno: 12219 committer: Lars Helge Øverland branch nick: dhis2 timestamp: Tue 2013-09-24 09:05:03 +0200 message: Impl dateperiodstructure resource table modified: dhis-2/dhis-api/src/main/java/org/hisp/dhis/period/PeriodType.java

Re: [Dhis2-devs] [Bug 1229494] Re: Aggregate of Avg type field is summed across Org Units

2013-09-24 Thread Troy Borja
I think the current behavior needs to be changed since summing averages does not mean anything while taking the average across org units would be useful. On Sep 24, 2013 12:50 PM, "jason.p.pickering" <1229...@bugs.launchpad.net> wrote: > This is supposed to be the intended behaviour I think, but I