I cleared cache and even restarted my tomcat server
Moemedi Ntunyane
Co-founder KeyInConsulting
Date: Tue, 16 Sep 2014 06:09:43 +0200
Subject: Re: [Dhis2-devs] periodstructure giving errors...
From: jason.p.picker...@gmail.com
To: moemedi.ntuny...@hotmail.com
CC: larshe...@gmail.com; dhis2-devs@
Yeah, well, I can't offer much more advice other in this case. We had
similar problems as I mentioned before with 2.16, but after carefully
cleaning up all of the faulty periods, things worked OK.
One thing which I would suggest would be to turn on full logging of all
postgresql queries, and see e
Thanks, I was upgrading from 2.0.5 to 2.14. I can only see this error its not
complaining of duplication but null value error:
org.postgresql.util.PSQLException: ERROR: null value in column "iso" violates
not-null constraint.
Moemedi Ntunyane
Co-founder KeyInConsulting
Date: Tue, 16 Sep 2014
Yes, you will see that error, but immediately after that exception in the
logs, should be another one. If you do not see it, as I said, you may need
to resort to postgresql logging to figure out exactly what is causing the
problem.
On Tue, Sep 16, 2014 at 9:27 AM, Moemedi Ntunyane <
moemedi.ntuny.
Depending on how much of configuration you have in your database, one
option could be to start afresh - doing metadata and data exports, and
import to an empty database. You would lose certain things (like users),
but also possibly get rid of some issues, rather than operating directly in
the datab
Hi devs,
Just an idea for your feedback.
We sometimes have DE with multiple categories where, for indicator
calculations, we only need sub-aggregated results. Let me give an example:
DE: Workers
Categories: Gender (2 options), Sector (10 options)
I have my indicator: number of women working in
Hi Robin,
I think that is the real issue, namely that you are applying DHIS2 in a
domain which is slightly different than it's typical domain, namely health.
I have been involved in some other projects with DHIS2 on the fringes of
what it can do out of the box in food security, water and sanitatio
Hello All,
Just wanted to know if there is any api that is exposed to "Start Export"
for "Analytics And Data Mart" ?
--
Regards,
Mansi Singhal
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe
Hi Mansi,
yes it is, see here:
https://www.dhis2.org/doc/snapshot/en/user/html/ch31s24.html
Lars
On Tue, Sep 16, 2014 at 12:09 PM, Mansi Singhal
wrote:
>
> Hello All,
>
> Just wanted to know if there is any api that is exposed to "Start Export"
> for "Analytics And Data Mart" ?
>
>
> --
> Re
Thanks Lars .
On Tue, Sep 16, 2014 at 3:45 PM, Lars Helge Øverland
wrote:
> Hi Mansi,
>
> yes it is, see here:
>
> https://www.dhis2.org/doc/snapshot/en/user/html/ch31s24.html
>
> Lars
>
>
> On Tue, Sep 16, 2014 at 12:09 PM, Mansi Singhal > wrote:
>
>>
>> Hello All,
>>
>> Just wanted to know if
Hey Lars,
How will i come to know if the initiated server side process is completed ?
On Tue, Sep 16, 2014 at 3:46 PM, Mansi Singhal
wrote:
> Thanks Lars .
>
> On Tue, Sep 16, 2014 at 3:45 PM, Lars Helge Øverland
> wrote:
>
>> Hi Mansi,
>>
>> yes it is, see here:
>>
>> https://www.dhis2.org/do
Hi Mansi,
You can see this thread
https://lists.launchpad.net/dhis2-devs/msg17759.html
for some approaches of how to see what is going on with the analytics
process.
This info may be a bit dated, but essentially, the approach is the same.
Regards,
Jason
On Tue, Sep 16, 2014 at 12:40 PM, Mansi
Thanks Jason.
On Tue, Sep 16, 2014 at 4:13 PM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:
> Hi Mansi,
> You can see this thread
>
> https://lists.launchpad.net/dhis2-devs/msg17759.html
>
> for some approaches of how to see what is going on with the analytics
> process.
>
> This info ma
Hi!
I am trying to access the demo site but login credentials admin / district
are not working. Can you please reset?
Thanks!
Inés
2014-08-04 10:23 GMT+02:00 Knut Staring :
> It seems that a lot of people are inclined to change the admin password
>
> I have now set it to "District1" again
I have changed the admin password to "District123" for now.
It will be reset to "district" at midnight (Oslo time).
Ola
---
--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo
Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Osl
Hi devs,
I'm having what seems like a bug with the import module:
When importing data from CSV, I get the following error message and the batch
doesn't run. However, this only happens when importing a data element over
different categoryoptioncombos and only when it is new data, not updates. In
Hi,
my experience is that when this happens (dry run works, but actual import fails
with an error similar to this), it is usually caused by duplicate values in the
source file i.e. multiple values with the same orgunit, data element, category
and period.
Olav
> 16. sep. 2014 kl. 14.22 skrev
Hi,
I see that your log file actually confirms this:
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value
violates unique constraint "datavalue_pkey"
Detail: Key (dataelementid, periodid, sourceid, categoryoptioncomboid,
attributeoptioncomboid)=(2443, 2079, 59, 16, 16) alre
Public bug reported:
In Event Reports and Event Visualizer, when "last month" is selected,
the current month is selected for the report instead of last. For
example, in September, then September is selected for the report instead
of August.
** Affects: dhis2
Importance: Medium
Assignee:
Thanks a lot for your assistance, I just used a fresh database and imported
meta data and the data itself eventhough other info was missing but managed to
fix everything. Now its working ok on my local instance.
Moemedi Ntunyane
Co-founder KeyInConsulting
From: knu...@gmail.com
Date: Tue, 16 S
Sorry, my system detail as follow
*Version: 2.16**Build revision:16414**Database type:MySQL*
*Java version:1.7.0_04**OS name:Windows 7*
On Tue, Sep 16, 2014 at 7:23 PM, sumudu weerasinghe
wrote:
> Dear all ,
> I have updated my instance from 2.15 to 2.16 over the old mysql database.
> Then i l
Hi Olav,
Thanks for the answer but I don't think that's the issue.
First of all, when checking my CSV with Excel's "Duplicate data" functionality
there's no duplicates found.
Secondly, when importing the same CSV file but piece by piece (per data
element-catoptcombo set) I don't have this issue
Hi Sumudu,
we are migrating the old individual case module to the new "tracker
capture" app in 2.16. Could you please try out the new app and see if it
meets your needs?
regards,
Lars
On Tue, Sep 16, 2014 at 3:56 PM, sumudu weerasinghe
wrote:
> Sorry, my system detail as follow
> *Version: 2
Hi,
if you are sure there are no duplicates it must be something else.
However, the fact that it works when you import piece by piece also points to
duplicates being the problem: if you split the file so that each of the
duplicate values are in different batches your import will work.
Olav
Hi Robin,
usually the problem is internal duplicates in the import file like Olav
says.
Importing piece by piece is not really proof in this case - if the
duplicates are spread across two pieces then the second piece will simply
update the record imported in the first instead of crashing.
We do
Hi Sumudu,
Could you please run these statements below in your database directly to
fix this bug ? Then restart tomcat again ?
*ALTER TABLE programstageinstance MODIFY status INTEGER;*
*UPDATE programstageinstance SET status='ACTIVE' WHERE status='0';*
*UPDATE programstageinstance SET status='COM
Hi Robin,
I have seem this happen in Excel before. AFAIK, there is no way to check
for discordant duplicates, which have the same orgunit/period/data
element/category combo but different values. Excel will not detect these as
being duplicates, if you include the value field as part of the criteria
I can also confirm that duplicates are the most likely cause of this
(having hit it quite a few times myself). We should consider catching this
exception and reporting such to the user ...
On 16 September 2014 15:31, Jason Pickering
wrote:
> Hi Robin,
>
> I have seem this happen in Excel before
Hi all,
I understand your comments, however I'm pretty sure there are no duplicates. I
put the CSV file in annex, please have a look for yourself. Note that I used
the "code" setting for both data elements and orgunits.
About Excel: when you select only the columns in which you want to find
du
Hi Robin,
I agree, it seems, you have no duplicates here, but the spec for the CSV
file is different I think. Are you not using UIDs?
It should look something like this.
"dataelement","period","orgunit","categoryoptioncombo","attributeoptioncombo","value","storedby","timestamp","comment","follow
Hi Tran,
I tried it but there is error in some query. My database "status" is a
integer.
I got following error?
*mysql> ALTER TABLE programstageinstance MODIFY status INTEGER;Query OK, 0
rows affected (0.10 sec)Records: 0 Duplicates: 0 Warnings: 0mysql> UPDATE
programstageinstance
Hi Jason,
Thanks for confirming on the duplicates. I've got the mistake now.
I'm using the CSV importer of DHIS2 itself, where you can set the "Data element
ID scheme" and "Org unit ID scheme" under "more options". I used "code" for
both. However, I used the PK for catoptcombos instead of the I
Glad that is sorted. You are right the catoptcombo doesn't currently
support a code. Its something we should look at.
I'm not sure why the importer threw the duplicate key exception rather than
something more helpful like unknown or invalid catoptcombo. Maybe Lars
would have a better idea. I g
On Tue, Sep 16, 2014 at 6:29 PM, Bob Jolliffe wrote:
> Glad that is sorted. You are right the catoptcombo doesn't currently
> support a code. Its something we should look at.
>
Actually trunk supports setting codes on category option combos, as well as
identifier schemes for data export as of
Damn, I was thinking about upgrading today... Well, good to know for next time!
:)
From: Lars Helge Øverland [mailto:larshe...@gmail.com]
Sent: 16 September 2014 18:35
To: Bob Jolliffe
Cc: Robin Martens; dhis2-devs@lists.launchpad.net
Subject: Re: [Dhis2-devs] DHIS2 - Import data from CSV - bug
Ps: we're close to our project deadlines now so I just wanted to say I
appreciated your fast replies of the last days.
Have a good night!
Robin
From: Lars Helge Øverland [mailto:larshe...@gmail.com]
Sent: 16 September 2014 18:35
To: Bob Jolliffe
Cc: Robin Martens; dhis2-devs@lists.launchpad.net
revno: 16730
committer: Lars Helge Overland
branch nick: dhis2
timestamp: Tue 2014-09-16 18:40:46 +0200
message:
Model change. Added list of Indicators to Section. Impl maintenance UI.
added:
dhis-2/dhis-web/dhis-web-commons/src/mai
Public bug reported:
The web application [/dhis] appears to have started a thread named
[SimpleAsyncTaskExecutor-64] but has failed to stop it. This is very
likely to create a memory leak.
** Affects: dhis2
Importance: Undecided
Status: New
--
You received this bug notification be
revno: 16731
committer: Lars Helge Overland
branch nick: dhis2
timestamp: Wed 2014-09-17 00:33:15 +0200
message:
Validation. Explicit printing of stacktrace for validation. Spring is poor at
printing stacktraces for async processes so
Hi Sumudu,
I am sorry I sent wrong statements by mistake. The *status *column should
be change to* varchar(25)*.
Could you please run the statements below and re-start tomcat ?
*ALTER TABLE programstageinstance MODIFY status varchar(25);*
*UPDATE programstageinstance SET status='ACTIVE' WHERE sta
revno: 16732
committer: Morten Olav Hansen
branch nick: dhis2
timestamp: Wed 2014-09-17 13:15:25 +0700
message:
NPE check for UserCredentials
modified:
dhis-2/dhis-web/dhis-web-api/src/main/java/org/hisp/dhis/webapi/controller/Accou
41 matches
Mail list logo
