Re: [Dhis2-users] Error duplicate key violates unique constraint after to import data to Database

[Knut Staring]

Hi again,

Since you have been importing patients, you probably want to find the max
like this:
SELECT max(patientid)+1 AS id FROM patient


On Wed, Jun 19, 2013 at 7:01 AM, Knut Staring  wrote:

> Hi Helder,
>
> Your problem is caused because you have not used the Postgres
> hibernate_sequence to generate IDs, but rather generated your own IDs.
> There are 3 answers:
>
> 1) This situation is avoided by using the DXF format, which takes a bit
> more work - then DHIS2 will add the IDs
>
> 2) If you are instead injecting data directly via SQL, it is recommended
> to use the following pattern (example from an earlier post by Jason to this
> list):
>
> INSERT INTO organisationunit(organisationunitid, name, shortname,
> parentid, active,openingdate)
> VALUES(nextval('hibernate_sequence'::regclass),'ad Federal Muslim
> Women Association in Nigeria Adamawa (FOMWAN
> A)','adFederalMuslimWomenAssociationinNigeriaAdamawaF',501,'true'
> ,'2001-01-01');
>
> Notice instead of setting the organisationunitid, i use the nextval of
> the hibernate_sequence. Of course the injection becomes a bit more complex,
> as you have to be sure that you get all of the parentIDs correct, but if
> you do it organisation layer by organisation layer, then it is relatively
> easy.
>
> 3) However, you have not followed 1) or 2) and therefore have to resolve
> the issue. You will now have to identify the maximum ID used in the
> tables you have added to and then to set the sequence value
> to one greater than the maximum.
>
> To find out the current status of your sequence, run this:
> SELECT nextval('hibernate_sequence');
>
> For example, if you have just added lots of orgunits manually with
> external IDs, you should run this:
>
> SELECT max(organisationunitid)+1 AS id FROM organisationunit
>
> Then use the new value like this:
> SELECT setval('hibernate_sequence', )
>
>
> On Wed, Jun 19, 2013 at 12:49 AM, Helder Yesid Castrillon Cobo <
> helders...@gmail.com> wrote:
>
>> Hi,
>>
>> We have needed to import data directly from Dhis Database(postgres), but
>> we have found that when entering the application does not allow adding new
>> records related to the imported information.
>> example:
>> If i import patient data,  then after the application not allow adding
>> new patients.
>>
>> when we doing tracking we found that the cause is an error that occurs
>> because DHIS try to create record with an existing key "Error Violates
>> duplicate unique key constraint".
>>
>> we have tried to index the tables again and did not solve the problem,
>> what other solution could be applied?
>>
>> Thanks,
>>
>> Helder Castrillon
>> Secretaria Departamental de salud del Cauca
>> Colombia
>>
>> --
>> __
>> @Heldersoft
>>
>>
>>
>> ___
>> 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
> Dept. of Informatics, University of Oslo
> +4791880522
> http://dhis2.org
>



-- 
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org
___
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] Error duplicate key violates unique constraint after to import data to Database

[Knut Staring]

Hi Helder,

Your problem is caused because you have not used the Postgres
hibernate_sequence to generate IDs, but rather generated your own IDs.
There are 3 answers:

1) This situation is avoided by using the DXF format, which takes a bit
more work - then DHIS2 will add the IDs

2) If you are instead injecting data directly via SQL, it is recommended to
use the following pattern (example from an earlier post by Jason to this
list):

INSERT INTO organisationunit(organisationunitid, name, shortname,
parentid, active,openingdate)
VALUES(nextval('hibernate_sequence'::regclass),'ad Federal Muslim
Women Association in Nigeria Adamawa (FOMWAN
A)','adFederalMuslimWomenAssociationinNigeriaAdamawaF',501,'true'
,'2001-01-01');

Notice instead of setting the organisationunitid, i use the nextval of the
hibernate_sequence. Of course the injection becomes a bit more complex, as
you have to be sure that you get all of the parentIDs correct, but if you
do it organisation layer by organisation layer, then it is relatively easy.

3) However, you have not followed 1) or 2) and therefore have to resolve
the issue. You will now have to identify the maximum ID used in the tables
you have added to and then to set the sequence value
to one greater than the maximum.

To find out the current status of your sequence, run this:
SELECT nextval('hibernate_sequence');

For example, if you have just added lots of orgunits manually with external
IDs, you should run this:

SELECT max(organisationunitid)+1 AS id FROM organisationunit

Then use the new value like this:
SELECT setval('hibernate_sequence', )


On Wed, Jun 19, 2013 at 12:49 AM, Helder Yesid Castrillon Cobo <
helders...@gmail.com> wrote:

> Hi,
>
> We have needed to import data directly from Dhis Database(postgres), but
> we have found that when entering the application does not allow adding new
> records related to the imported information.
> example:
> If i import patient data,  then after the application not allow adding new
> patients.
>
> when we doing tracking we found that the cause is an error that occurs
> because DHIS try to create record with an existing key "Error Violates
> duplicate unique key constraint".
>
> we have tried to index the tables again and did not solve the problem,
> what other solution could be applied?
>
> Thanks,
>
> Helder Castrillon
> Secretaria Departamental de salud del Cauca
> Colombia
>
> --
> __
> @Heldersoft
>
>
>
> ___
> 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
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org
___
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] Error duplicate key violates unique constraint after to import data to Database

[Helder Yesid Castrillon Cobo]

Hi,

We have needed to import data directly from Dhis Database(postgres), but we
have found that when entering the application does not allow adding new
records related to the imported information.
example:
If i import patient data,  then after the application not allow adding new
patients.

when we doing tracking we found that the cause is an error that occurs
because DHIS try to create record with an existing key "Error Violates
duplicate unique key constraint".

we have tried to index the tables again and did not solve the problem, what
other solution could be applied?

Thanks,

Helder Castrillon
Secretaria Departamental de salud del Cauca
Colombia

-- 
__
@Heldersoft
___
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] Problem with datamart in dhis 2.12

[Bob Jolliffe]

Ah sorry hang on with that.  I didn't backport fix to 2.12.  Earliest I can
do now is tomorrow unless someone else cares to (2 lines).

Cheers
Bob


On 18 June 2013 22:50, Jerry Aziawa  wrote:

> Ok thanx a lot for all your contribution. I will download the new
> version of DHIS 2.12
>  with the fixed bug.
>
>
> On 6/18/13, Bob Jolliffe  wrote:
> > OK it looks like a small javascript UI "bug" with a simple workaround for
> > now.  The onClick() which toggles the dataMart enable is triggered by
> > clicking on the label NOT on the checkbox.  So if your eyesight is not
> too
> > sharp like mine (and worryingly it seems also Lars who is a good deal
> > younger) then you can miss the checkbox and click on the label "Data mart
> > tables update" instead then all works as expected :-)
> >
> > I'll quickly fix this in trunk ... a rare javascript contribution ...
> >
> >
> >
> >
> > On 18 June 2013 21:03, Bob Jolliffe  wrote:
> >
> >> Yes I have seen the same problem on the carec system (also 2.12 build
> >> 11183).  Looks like a bug ...
> >>
> >>
> >> On 18 June 2013 19:42, Knut Staring  wrote:
> >>
> >>> Hi Lars,
> >>>
> >>> Running 2.12 build 11183 the date fields remain grayed out even when
> >>> checking the
> >>> Data mart tables update box
> >>>
> >>>
> >>> On Tue, Jun 18, 2013 at 7:28 PM, Lars Helge Øverland
> >>>  >>> > wrote:
> >>>
>  Hi Jerry,
> 
>  did you tick the "data mart tables update" checkbox? The date fields
>  are
>  only relevant to data mart.
> 
>  I guess we need to make that clearer in the ui.
> 
>  regards,
> 
>  Lars
> 
> 
>  On Mon, Jun 17, 2013 at 12:10 PM, Jerry Aziawa 
>  wrote:
> 
> > Good morning,
> >
> > I am currently facing a problem when using datamart in DHIS2.
> Whenever
> > I try to launch datamart the date fields are deactivated. So for that
> > reason I cannot choose the start date and the end the date. Did i
> miss
> > something during the process of launching datamart or is it a bug?
> >
> > Thanx a lot
> >
> > ___
> > 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
> 
> 
> >>>
> >>>
> >>> --
> >>> Knut Staring
> >>> Dept. of Informatics, University of Oslo
> >>> +4791880522
> >>> http://dhis2.org
> >>>
> >>> ___
> >>> 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] Problem with datamart in dhis 2.12

[Jerry Aziawa]

Ok thanx a lot for all your contribution. I will download the new
version of DHIS 2.12
 with the fixed bug.


On 6/18/13, Bob Jolliffe  wrote:
> OK it looks like a small javascript UI "bug" with a simple workaround for
> now.  The onClick() which toggles the dataMart enable is triggered by
> clicking on the label NOT on the checkbox.  So if your eyesight is not too
> sharp like mine (and worryingly it seems also Lars who is a good deal
> younger) then you can miss the checkbox and click on the label "Data mart
> tables update" instead then all works as expected :-)
>
> I'll quickly fix this in trunk ... a rare javascript contribution ...
>
>
>
>
> On 18 June 2013 21:03, Bob Jolliffe  wrote:
>
>> Yes I have seen the same problem on the carec system (also 2.12 build
>> 11183).  Looks like a bug ...
>>
>>
>> On 18 June 2013 19:42, Knut Staring  wrote:
>>
>>> Hi Lars,
>>>
>>> Running 2.12 build 11183 the date fields remain grayed out even when
>>> checking the
>>> Data mart tables update box
>>>
>>>
>>> On Tue, Jun 18, 2013 at 7:28 PM, Lars Helge Øverland
>>> >> > wrote:
>>>
 Hi Jerry,

 did you tick the "data mart tables update" checkbox? The date fields
 are
 only relevant to data mart.

 I guess we need to make that clearer in the ui.

 regards,

 Lars


 On Mon, Jun 17, 2013 at 12:10 PM, Jerry Aziawa 
 wrote:

> Good morning,
>
> I am currently facing a problem when using datamart in DHIS2. Whenever
> I try to launch datamart the date fields are deactivated. So for that
> reason I cannot choose the start date and the end the date. Did i miss
> something during the process of launching datamart or is it a bug?
>
> Thanx a lot
>
> ___
> 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


>>>
>>>
>>> --
>>> Knut Staring
>>> Dept. of Informatics, University of Oslo
>>> +4791880522
>>> http://dhis2.org
>>>
>>> ___
>>> 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] Problem with datamart in dhis 2.12

[Bob Jolliffe]

OK it looks like a small javascript UI "bug" with a simple workaround for
now.  The onClick() which toggles the dataMart enable is triggered by
clicking on the label NOT on the checkbox.  So if your eyesight is not too
sharp like mine (and worryingly it seems also Lars who is a good deal
younger) then you can miss the checkbox and click on the label "Data mart
tables update" instead then all works as expected :-)

I'll quickly fix this in trunk ... a rare javascript contribution ...




On 18 June 2013 21:03, Bob Jolliffe  wrote:

> Yes I have seen the same problem on the carec system (also 2.12 build
> 11183).  Looks like a bug ...
>
>
> On 18 June 2013 19:42, Knut Staring  wrote:
>
>> Hi Lars,
>>
>> Running 2.12 build 11183 the date fields remain grayed out even when
>> checking the
>> Data mart tables update box
>>
>>
>> On Tue, Jun 18, 2013 at 7:28 PM, Lars Helge Øverland > > wrote:
>>
>>> Hi Jerry,
>>>
>>> did you tick the "data mart tables update" checkbox? The date fields are
>>> only relevant to data mart.
>>>
>>> I guess we need to make that clearer in the ui.
>>>
>>> regards,
>>>
>>> Lars
>>>
>>>
>>> On Mon, Jun 17, 2013 at 12:10 PM, Jerry Aziawa  wrote:
>>>
 Good morning,

 I am currently facing a problem when using datamart in DHIS2. Whenever
 I try to launch datamart the date fields are deactivated. So for that
 reason I cannot choose the start date and the end the date. Did i miss
 something during the process of launching datamart or is it a bug?

 Thanx a lot

 ___
 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
>>>
>>>
>>
>>
>> --
>> Knut Staring
>> Dept. of Informatics, University of Oslo
>> +4791880522
>> http://dhis2.org
>>
>> ___
>> 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] Problem with datamart in dhis 2.12

[Bob Jolliffe]

Yes I have seen the same problem on the carec system (also 2.12 build
11183).  Looks like a bug ...


On 18 June 2013 19:42, Knut Staring  wrote:

> Hi Lars,
>
> Running 2.12 build 11183 the date fields remain grayed out even when
> checking the
> Data mart tables update box
>
>
> On Tue, Jun 18, 2013 at 7:28 PM, Lars Helge Øverland 
> wrote:
>
>> Hi Jerry,
>>
>> did you tick the "data mart tables update" checkbox? The date fields are
>> only relevant to data mart.
>>
>> I guess we need to make that clearer in the ui.
>>
>> regards,
>>
>> Lars
>>
>>
>> On Mon, Jun 17, 2013 at 12:10 PM, Jerry Aziawa  wrote:
>>
>>> Good morning,
>>>
>>> I am currently facing a problem when using datamart in DHIS2. Whenever I
>>> try to launch datamart the date fields are deactivated. So for that reason
>>> I cannot choose the start date and the end the date. Did i miss something
>>> during the process of launching datamart or is it a bug?
>>>
>>> Thanx a lot
>>>
>>> ___
>>> 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
>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> +4791880522
> http://dhis2.org
>
> ___
> 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] Problem with datamart in dhis 2.12

[Knut Staring]

Hi Lars,

Running 2.12 build 11183 the date fields remain grayed out even when
checking the
Data mart tables update box


On Tue, Jun 18, 2013 at 7:28 PM, Lars Helge Øverland wrote:

> Hi Jerry,
>
> did you tick the "data mart tables update" checkbox? The date fields are
> only relevant to data mart.
>
> I guess we need to make that clearer in the ui.
>
> regards,
>
> Lars
>
>
> On Mon, Jun 17, 2013 at 12:10 PM, Jerry Aziawa  wrote:
>
>> Good morning,
>>
>> I am currently facing a problem when using datamart in DHIS2. Whenever I
>> try to launch datamart the date fields are deactivated. So for that reason
>> I cannot choose the start date and the end the date. Did i miss something
>> during the process of launching datamart or is it a bug?
>>
>> Thanx a lot
>>
>> ___
>> 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
>
>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org
___
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] Dataset report error

[Lars Helge Øverland]

Hi Angela,

can you please have a look in the Tomcat log and post errors related to
this?

regards,

Lars


http://www.dhis2.org/doc/snapshot/en/implementer/html/ch09s03.html


On Tue, Jun 18, 2013 at 8:03 PM, Hinds, Ms. Angela (CAR) <
hinds...@carpha.org> wrote:

>  Hello All
>
> ** **
>
> Our system was recently upgraded to DHIS 2.12.  All seems well except that
> when we try to run a dataset report.  If the chosen period has no data, the
> report is displayed (with blanks as it should).  If the period has data the
> following message is displayed:-
>
> ** **
>
> Sorry The system failed to execute the operation. Usually, no data is lost
> and you can continue working by going back to the previous page
>
> ** **
>
> Any ideas?
>
> ** **
>
> Angela 
>
> ** **
>
> ___
> 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] Problem with datamart in dhis 2.12

[Lars Helge Øverland]

Hi Jerry,

did you tick the "data mart tables update" checkbox? The date fields are
only relevant to data mart.

I guess we need to make that clearer in the ui.

regards,

Lars


On Mon, Jun 17, 2013 at 12:10 PM, Jerry Aziawa  wrote:

> Good morning,
>
> I am currently facing a problem when using datamart in DHIS2. Whenever I
> try to launch datamart the date fields are deactivated. So for that reason
> I cannot choose the start date and the end the date. Did i miss something
> during the process of launching datamart or is it a bug?
>
> Thanx a lot
>
> ___
> 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] Dataset report error

[Hinds, Ms. Angela (CAR)]

Hello All

Our system was recently upgraded to DHIS 2.12.  All seems well except that when 
we try to run a dataset report.  If the chosen period has no data, the report 
is displayed (with blanks as it should).  If the period has data the following 
message is displayed:-

Sorry The system failed to execute the operation. Usually, no data is lost and 
you can continue working by going back to the previous page

Any ideas?

Angela

___
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.11 Saving Value Failed with Status Code 1

[Lars Helge Øverland]

Likely to be a caching issue. To force an update of all data sets you can
do this SQL:

update dataset set version = (version+1);

regards,

Lars



On Mon, Jun 10, 2013 at 2:30 PM, Dayo Adeyomoye  wrote:

> Thanks Olav,
>
> I restarted the DHIS server and it works now. As you also mentioned, one
> of the users experienced the problem again but after changing browser it
> was resolved. I also encountered it again but when I tried Chrome Incognito
> and IE that I haven't used for it before. The problem did not surface.
>
> It must have cached the issues.
>
> Thank you.
>
>
>
> BlackBerry: 3114F90C
> Phone: 08028851441, 08035560463
> emails: deemo...@yahoo.com, addyr...@yahoo.com
> Yahoo IM: deemoyes
> Facebook: pharael
> twitter:pharaell
>   --
>  *From:* Olav Poppe 
> *To:* Dayo Adeyomoye 
> *Cc:* "dhis2-users@lists.launchpad.net" 
> *Sent:* Monday, June 10, 2013 12:05 PM
> *Subject:* Re: [Dhis2-users] DHIS2.11 Saving Value Failed with Status
> Code 1
>
> Hi
> did this start occurring after updating from 2.10 to 2.11? Does the same
> thing happen if using Chrome in Incognito mode?
>
> Olav
>
>
> 10. juni 2013 kl. 11:27 skrev Dayo Adeyomoye :
>
> Hi all,
>
> DHIS 2.11 Data Entry page gives this error whenever a value is entered
> into the boxes. It says Saving Value Failed with Status Code 1. Instead
> of also turning green, it first turns yellow and then RED.
>
> Anyone with a solution?
>
> Thanks
>
> Dayo
> ___
> 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

Re: [Dhis2-users] User Security Question

[Lars Helge Øverland]

Hello Rajib,

creating such a user role is perfectly possible. Make sure you give the
"See data entry module", "Add data value", "Update data value" and "Delete
data value" and not much else.

If you do not give "See x module" authority for any maintenance modules,
then the maintenance top menu link will be hidden. You can hide any module
by not giving the "See x module" authority.

regards,

Lars



On Sun, Jun 9, 2013 at 4:08 PM, Rajib Sengupta  wrote:

> Hi,
>
> We will like to have a User Role which should have access to ONLY "Data
> Entry" page where they can change the value of Data elements.
>
> Please let me know what are the minimal "Authorities" that needs to be
> provided to this role?
>
> Also, we will like to know, for this role only, if it is possible to not
> show the The "Maintenance"  menu  completely as well as the sub-menus of
> the "Services" , such as "Dashboard", "GIS" etc.
>
> We started to do this by changing the CSS but that will be applicable for
> all users which we don't want.
>
> Thanks,
> Rajib
>
> www.missionarogya.org
>
> ___
> 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] [Dhis2-devs] Need Calendar Object to display future dates

[Lars Helge Øverland]

Hi John,

yes everything is possible, I have put up a blueprint for it here:

https://blueprints.launchpad.net/dhis2/+spec/tracker-future-dates

best regards,

Lars



On Sat, Jun 8, 2013 at 10:18 PM, John Ojo  wrote:

> Hi All,
>
> I am creating an information system based on the dhis2 Tracker module and
> need to set the value of a data element to a future date. However, the
> calendar object associated with the data element displays '2013' (i.e. the
> current year) as the highest value for the year but the value for the data
> element is supposed to be July, 2015 (please see the attached screenShot).
>
> Is it possible to make the Calendar Object in dhis2 display future dates?
>
> Thank you,
> John
>
> *John Ojo MD, FMCPH
> *
> Accra, Ghana.
> Mobile: +233 234691626
> Skype:  Johnojo
> Email: jn...@yahoo.com 
> 
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> 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] DHIS2 Road Map

[Farai Mutero]

Thanks Prosper!


On Tue, Jun 18, 2013 at 3:59 PM, Prosper BT  wrote:

> Check out the series and milestone and click on the version to see the
> features
>
> https://launchpad.net/dhis2
>
>
>
>
> On Tue, Jun 18, 2013 at 4:42 PM, Farai Mutero  wrote:
>
>> Hi All
>>
>> Is there a publicly available url for the DHIS2 Road Map which can give
>> us an idea of what to expect in the upcoming releases of DHIS2. I'm a aware
>> though of the blueprints on Launchpad.
>>
>> Regards
>>
>> --
>> Farai Mutero
>>
>>
>> ___
>> 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
>>
>>
>
>
> --
> Prosper Behumbiize, MPH
> Phone:+256 414 320076
> Cell:+256 752 751776
>+256 702 762707
>



-- 
Farai Mutero
___
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 Road Map

[Prosper BT]

Check out the series and milestone and click on the version to see the
features

https://launchpad.net/dhis2




On Tue, Jun 18, 2013 at 4:42 PM, Farai Mutero  wrote:

> Hi All
>
> Is there a publicly available url for the DHIS2 Road Map which can give us
> an idea of what to expect in the upcoming releases of DHIS2. I'm a aware
> though of the blueprints on Launchpad.
>
> Regards
>
> --
> Farai Mutero
>
>
> ___
> 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
>
>


-- 
Prosper Behumbiize, MPH
Phone:+256 414 320076
Cell:+256 752 751776
   +256 702 762707
___
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 Road Map

[Farai Mutero]

Hi All

Is there a publicly available url for the DHIS2 Road Map which can give us
an idea of what to expect in the upcoming releases of DHIS2. I'm a aware
though of the blueprints on Launchpad.

Regards

-- 
Farai Mutero
___
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] Fwd:

[Lars Helge Øverland]

This column is obsolete after 2.12 and should have been dropped by the
startup routines. If not then simply drop that column "doindicators" from
the table manually.

Lars


On Mon, Jun 3, 2013 at 2:53 PM, Knut Staring  wrote:

> We have "resolved" this issue by deleting all the reporttables in the
> database.
>
> Knut
>
>
>
> On Mon, Jun 3, 2013 at 12:30 PM, Knut Staring  wrote:
>
>> Hi has anyone come across a message like the one below while clicking on
>> the Report Table link?
>>
>> This is in 2.10
>>
>> * ERROR 2013-06-03 12:12:01,054 Error while executing action
>> (ExceptionIntercept
>> or.java [http-apr-8080-exec-10])
>> org.hibernate.PropertyAccessException: Null value was assigned to a
>> property of
>> primitive type setter of
>> org.hisp.dhis.reporttable.ReportTable.doIndicators
>> at
>> org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPro
>> pertyAccessor.java:108)
>>
>>
>>
>> --
>> Knut Staring
>> Dept. of Informatics, University of Oslo
>> +4791880522
>> http://dhis2.org
>>
>> ___
>> 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
> Dept. of Informatics, University of Oslo
> +4791880522
> http://dhis2.org
>
> ___
> 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] Problems with Large Aggregate queries

[Tran Chau]

Dear Jose,

This was fixed for 2.12. The maximum number of characters is 1000 now.

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispviet...@gmail.com


On Mon, May 27, 2013 at 11:34 PM, Jose Garcia Muñoz wrote:

>
> Dear all,
>
> it seems that in the aggregation query builder (under Maintenance -
> Persons and Programs), is not allowed to introduce conditions larger than
> 254 characters. Any idea about how we could solve this in case large
> queries are needed?
>
> I am using 2.11 DHIS2 version
>
> Thanks
> Jose
>
> ___
> 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