Re: [Dhis2-users] Delete Validation Rules

[Morten Olav Hansen]

Hi Em

I'm not sure if there is any UI for deleting validation results, but you
can do it yourself in the database.

The validationresults are located in the table "validationresult", and it
has a column called "validationruleid" which links to your validation rules.

So you need to find that validation rule in the "validationrule" table, and
use that "validationruleid" to delete the correct rows from the
"validationresult" table.

"DELETE FROM validationresult WHERE validationruleid=??"

This does sound like a bug though, so please file one in JIRA

-- 
Morten Olav Hansen
Senior Engineer, DHIS 2
Team Integration Lead
University of Oslo
http://www.dhis2.org

On Tue, Aug 7, 2018 at 5:07 PM, Em Le Hong  wrote:

> Dear all,
>
> DHIS 2.29
>
> I try to delete a validation rule on my database but the system response a
> message:
> Could not delete due to association with another object: ValidationResult
>
> This mean we need to delete Validation Result before delete Validation Rule
>
> Does anyone know how to delete Validation Result, if you don't mind please
> share.
>
> Thanks,
> --
> *Em Le Hong*
> DHIS2 Implementation| *HISP Vietnam *
> em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com
>
>
>
>
>
>
> ___
> 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] Importing GADM boundaries into DHIS2

[Shurajit Dutta]

Hi everyone

Was wondering if there was a simplified process to import GADM (
https://gadm.org/) boundaries into DHIS2.

For example, if I have a global hierarchy of some sort and only want to
import the country-level boundaries.

ie.
Global
---Regional
-Country

Thanks,
Nick

-- 
Shurajit Dutta (MPH, MHI)
Health Information Systems Adviser
___
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] A bug in DHIS2?

[riddy ndoma]

Can you share your log file?

2018-08-07 12:27 GMT+02:00 Carlos Nyembwe :

> Hi Riddy
>
> I'm on DHIS2 2.29
>
> Regards
>
> On Tue, Aug 7, 2018 at 11:26 AM, riddy ndoma  wrote:
>
>> Hi carlos,
>> Which version of DHIS2 do you use?
>>
>> regards,
>>
>> 2018-08-07 12:22 GMT+02:00 Carlos Nyembwe :
>>
>>> Hello all
>>>
>>> I have a problem, in Data Entry for aggregate data, when I finish to
>>> entry data, and need to click on Complete bouton,
>>>
>>> I'm seeing this message " Error in registering data set completeness I
>>> don't know what it's mean, Who can help me?
>>>
>>> Thanks
>>>
>>> --
>>> *Carlos Nyembwe*
>>> *I'm just a Computer Scientist*
>>>
>>> *Skype: carloscnk1*
>>> *Cell: (+243)813166381*
>>> *Find me in: | Google Plus  | 
>>> **Linkedin
>>>  | Facebook
>>>  | Twitter
>>>  |*
>>>
>>> ___
>>> 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
>>>
>>>
>>
>>
>> --
>> Riddy NDOMA
>> *Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
>> *Twitter:* riddyndoma, *LinkedIn:* riddy ndoma
>> *Blog:* http://riddyndoma.blogspot.com/
>> *Vous servir est mon désire (Serving you is my desire)*
>>
>
>
>
> --
> *Carlos Nyembwe*
> *I'm just a Computer Scientist*
>
> *Skype: carloscnk1*
> *Cell: (+243)813166381*
> *Find me in: | Google Plus  | 
> **Linkedin
>  | Facebook
>  | Twitter
>  |*
>



-- 
Riddy NDOMA
*Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
*Twitter:* riddyndoma, *LinkedIn:* riddy ndoma
*Blog:* http://riddyndoma.blogspot.com/
*Vous servir est mon désire (Serving you is my desire)*
___
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] Delete Validation Rules

[Em Le Hong]

Dear all,

DHIS 2.29

I try to delete a validation rule on my database but the system response a
message:
Could not delete due to association with another object: ValidationResult

This mean we need to delete Validation Result before delete Validation Rule

Does anyone know how to delete Validation Result, if you don't mind please
share.

Thanks,
-- 
*Em Le Hong*
DHIS2 Implementation| *HISP Vietnam *
em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com
___
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] A bug in DHIS2?

[Carlos Nyembwe]

Hello all

I have a problem, in Data Entry for aggregate data, when I finish to entry
data, and need to click on Complete bouton,

I'm seeing this message " Error in registering data set completeness I
don't know what it's mean, Who can help me?

Thanks

-- 
*Carlos Nyembwe*
*I'm just a Computer Scientist*

*Skype: carloscnk1*
*Cell: (+243)813166381*
*Find me in: | Google Plus  |
**Linkedin
 | Facebook
 | Twitter
 |*
___
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] A bug in DHIS2?

[Barnabas Akumba]

Hello Carlos,

tail -f your catalina.out and try to resubmit the dataset again so you can
monitor the logs realtime.

Regards

On Tue, Aug 7, 2018 at 11:38 AM Carlos Nyembwe  wrote:

> Hi Riddy
>
> I'm on DHIS2 2.29
>
> Regards
>
> On Tue, Aug 7, 2018 at 11:26 AM, riddy ndoma  wrote:
>
>> Hi carlos,
>> Which version of DHIS2 do you use?
>>
>> regards,
>>
>> 2018-08-07 12:22 GMT+02:00 Carlos Nyembwe :
>>
>>> Hello all
>>>
>>> I have a problem, in Data Entry for aggregate data, when I finish to
>>> entry data, and need to click on Complete bouton,
>>>
>>> I'm seeing this message " Error in registering data set completeness I
>>> don't know what it's mean, Who can help me?
>>>
>>> Thanks
>>>
>>> --
>>> *Carlos Nyembwe*
>>> *I'm just a Computer Scientist*
>>>
>>> *Skype: carloscnk1*
>>> *Cell: (+243)813166381*
>>> *Find me in: | Google Plus  | 
>>> **Linkedin
>>>  | Facebook
>>>  | Twitter
>>>  |*
>>>
>>> ___
>>> 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
>>>
>>>
>>
>>
>> --
>> Riddy NDOMA
>> *Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
>> *Twitter:* riddyndoma, *LinkedIn:* riddy ndoma
>> *Blog:* http://riddyndoma.blogspot.com/
>> *Vous servir est mon désire (Serving you is my desire)*
>>
>
>
>
> --
> *Carlos Nyembwe*
> *I'm just a Computer Scientist*
>
> *Skype: carloscnk1*
> *Cell: (+243)813166381*
> *Find me in: | Google Plus  | 
> **Linkedin
>  | Facebook
>  | Twitter
>  |*
> ___
> 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
>


-- 

Barnabas AKUMBA

*Mobile:* +2348036195778
*Skype:* barnabas.akumba
___
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] A bug in DHIS2?

[Barnabas Akumba]

Hello Carlos,
You can check your logs. There should be an explanation there.

Regards


On Tue, Aug 7, 2018 at 11:24 AM Carlos Nyembwe  wrote:

> Hello all
>
> I have a problem, in Data Entry for aggregate data, when I finish to entry
> data, and need to click on Complete bouton,
>
> I'm seeing this message " Error in registering data set completeness I
> don't know what it's mean, Who can help me?
>
> Thanks
>
> --
> *Carlos Nyembwe*
> *I'm just a Computer Scientist*
>
> *Skype: carloscnk1*
> *Cell: (+243)813166381*
> *Find me in: | Google Plus  | 
> **Linkedin
>  | Facebook
>  | Twitter
>  |*
> ___
> 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
>


-- 

Barnabas AKUMBA

*Mobile:* +2348036195778
*Skype:* barnabas.akumba
___
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] A bug in DHIS2?

[Carlos Nyembwe]

Hi Riddy

I'm on DHIS2 2.29

Regards

On Tue, Aug 7, 2018 at 11:26 AM, riddy ndoma  wrote:

> Hi carlos,
> Which version of DHIS2 do you use?
>
> regards,
>
> 2018-08-07 12:22 GMT+02:00 Carlos Nyembwe :
>
>> Hello all
>>
>> I have a problem, in Data Entry for aggregate data, when I finish to
>> entry data, and need to click on Complete bouton,
>>
>> I'm seeing this message " Error in registering data set completeness I
>> don't know what it's mean, Who can help me?
>>
>> Thanks
>>
>> --
>> *Carlos Nyembwe*
>> *I'm just a Computer Scientist*
>>
>> *Skype: carloscnk1*
>> *Cell: (+243)813166381*
>> *Find me in: | Google Plus  | 
>> **Linkedin
>>  | Facebook
>>  | Twitter
>>  |*
>>
>> ___
>> 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
>>
>>
>
>
> --
> Riddy NDOMA
> *Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
> *Twitter:* riddyndoma, *LinkedIn:* riddy ndoma
> *Blog:* http://riddyndoma.blogspot.com/
> *Vous servir est mon désire (Serving you is my desire)*
>



-- 
*Carlos Nyembwe*
*I'm just a Computer Scientist*

*Skype: carloscnk1*
*Cell: (+243)813166381*
*Find me in: | Google Plus  |
**Linkedin
 | Facebook
 | Twitter
 |*
___
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] A bug in DHIS2?

[riddy ndoma]

Hi carlos,
Which version of DHIS2 do you use?

regards,

2018-08-07 12:22 GMT+02:00 Carlos Nyembwe :

> Hello all
>
> I have a problem, in Data Entry for aggregate data, when I finish to entry
> data, and need to click on Complete bouton,
>
> I'm seeing this message " Error in registering data set completeness I
> don't know what it's mean, Who can help me?
>
> Thanks
>
> --
> *Carlos Nyembwe*
> *I'm just a Computer Scientist*
>
> *Skype: carloscnk1*
> *Cell: (+243)813166381*
> *Find me in: | Google Plus  | 
> **Linkedin
>  | Facebook
>  | Twitter
>  |*
>
> ___
> 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
>
>


-- 
Riddy NDOMA
*Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
*Twitter:* riddyndoma, *LinkedIn:* riddy ndoma
*Blog:* http://riddyndoma.blogspot.com/
*Vous servir est mon désire (Serving you is my desire)*
___
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] Analytics error

[Ngoni Manika]

Thanks a lot Jason

I will try all the options

Regards

From: Jason Pickering 
Sent: Monday, 06 August 2018 11:21 AM
To: Ngoni Manika 
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Analytics error

Hi Ngoni,
From the error message, you still do not have enough disk space.

Analytics uses a large amount of disk space during regeneration because it 
effectively creates a copy of of the analytics tables. These tables can get 
very large, so its important to be sure you have enough disk space.

You can get a good estimate of your disk usage using one of the queries listed 
here https://wiki.postgresql.org/wiki/Disk_Usage.

In my case, the output looks like this:

dhis2-# LIMIT 20;
   name|  owner   |  size
---+--+-
 training  | postgres | 73 GB

Usually, the analytics tables occupies a large part of the disk space, so I 
generally would want to be sure I have at least 150 GB free disk space before I 
attempt to do a full run  of analytics.

The simplest way to solve this problem is just to ensure you have enough disk 
space, but if that is not an option you can

1) Drop all analytics tables prior to a full regeneration.
2) Perform a partial analytics regeneration (like the last two years) and see 
if that works.

Best regards,
Jason




On Mon, Aug 6, 2018 at 10:57 AM Ngoni Manika 
mailto:nman...@hotmail.com>> wrote:
Greeting team

I am trying to run analytics but I get the following error.


org.postgresql.util.PSQLException: ERROR: could not extend file 
"base/28039/3075745": wrote only 4096 of 8192 bytes at block 472 Hint: Check 
free disk space.

I have cleared some log files and the server has space, but I am still getting 
the error.

Could you please assist

Regards
___
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


--
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
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