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<mailto: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<mailto: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

[Dhis2-users] Analytics error

[Ngoni Manika]

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

Re: [Dhis2-users] Select option in aggregate data entry

[Ngoni Manika]

Dear Abyot

Solved, Thanks a lot that was exactly the problem

Regards

Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

From: Abyot Asalefew Gizaw<mailto:ab...@dhis2.org>
Sent: Monday, March 27, 2017 1:39 PM
To: Ngoni Manika<mailto:nman...@hotmail.com>
Cc: Absolom MURAMIRA<mailto:absolo...@yahoo.com>; DHIS 2 Users 
list<mailto:dhis2-users@lists.launchpad.net>; 
dhis2-devs<mailto:dhis2-d...@lists.launchpad.net>
Subject: Re: [Dhis2-users] Select option in aggregate data entry

Hi Ngoni,

Does your options have both name and code?

--
Abyot A. Gizaw.
Senior Engineer, DHIS2
University of Oslo
http://www.dhis2.org

On Mon, Mar 27, 2017 at 1:22 PM, Ngoni Manika 
<nman...@hotmail.com<mailto:nman...@hotmail.com>> wrote:
Hi Absolom

Yes I did assign. The list is showing but you cannot select anything

Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

From: Absolom MURAMIRA<mailto:absolo...@yahoo.com>
Sent: Monday, March 27, 2017 11:41 AM
To: Ngoni Manika<mailto:nman...@hotmail.com>; DHIS 2 Users 
list<mailto:dhis2-users@lists.launchpad.net>; 
dhis2-devs<mailto:dhis2-d...@lists.launchpad.net>
Subject: Re: [Dhis2-users] Select option in aggregate data entry

Dear Ngoni,

Did you assign the option sets to the data elements?

On Monday, March 27, 2017 2:33 AM, Ngoni Manika 
<nman...@hotmail.com<mailto:nman...@hotmail.com>> wrote:

Greetings

I am trying to design a system that capture veterinary information, and this 
includes text.

I have designed the data elements and their respective option sets, but when I 
go for data entry I cannot select the option in the drop down list.

May you please assist

Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

___
Mailing list: https://launchpad.net/~dhis2-users
Post to: 
dhis2-users@lists.launchpad.net<mailto: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<mailto: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] Select option in aggregate data entry

[Ngoni Manika]

Hi Absolom

Yes I did assign. The list is showing but you cannot select anything

Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

From: Absolom MURAMIRA<mailto:absolo...@yahoo.com>
Sent: Monday, March 27, 2017 11:41 AM
To: Ngoni Manika<mailto:nman...@hotmail.com>; DHIS 2 Users 
list<mailto:dhis2-users@lists.launchpad.net>; 
dhis2-devs<mailto:dhis2-d...@lists.launchpad.net>
Subject: Re: [Dhis2-users] Select option in aggregate data entry

Dear Ngoni,

Did you assign the option sets to the data elements?

On Monday, March 27, 2017 2:33 AM, Ngoni Manika <nman...@hotmail.com> wrote:

Greetings

I am trying to design a system that capture veterinary information, and this 
includes text.

I have designed the data elements and their respective option sets, but when I 
go for data entry I cannot select the option in the drop down list.

May you please assist

Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

___
Mailing list: https://launchpad.net/~dhis2-users
Post to: 
dhis2-users@lists.launchpad.net<mailto: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] Select option in aggregate data entry

[Ngoni Manika]

Greetings

I am trying to design a system that capture veterinary information, and this 
includes text.

I have designed the data elements and their respective option sets, but when I 
go for data entry I cannot select the option in the drop down list.

May you please assist

Sent from Mail for Windows 10

___
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] Html report

[Ngoni Manika]

Hi guys

I'm trying to create an html report using js, I want to check a value then 
change the CSS color. Example

//get data from analytics

If  ($(#bcg).html.json())  50)
{
//change background color for the span bcg to green
}
 
The point is i want to check if an indicator is in a certain range set the 
background color of the  span/div to say green.

Any help is appreciated 
Regards

Ngoni Windows Phone___
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] Restore a large PostgreSQL dump

[Ngoni Manika]

Hi team

 

I am having a challenge on restoring a postres dump which is large (16gig),
it gives an error on restoring data in table analytics 2014.

 

Can anyone please help with how I can go around it, or maybe how to edit the
dump (notepad++ cannot open the file is too large).

 

Regards

 

Ngonidzashe Manika

Data Officer

+263 772 789673,  mailto:nman...@hotmail.com nman...@hotmail.com, skype:
ngoni.manika

Ministry of Health and Child Care, AIDS and TB Unit, 2nd Floor, Library,
Mkwati Building

 

___
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] Restore a large PostgreSQL dump

[Ngoni Manika]

Thanks a lot, I have also tried the command line but it's the same result. I
guess its corrupted then. Will try to do another one.

 

Thanks guys

 

Ngonidzashe Manika

Data Officer

+263 772 789673, nman...@hotmail.com mailto:nman...@hotmail.com , skype:
ngoni.manika

Ministry of Health and Child Care, AIDS and TB Unit, 2nd Floor, Library,
Mkwati Building

 

From: Bob Jolliffe [mailto:bobjolli...@gmail.com] 
Sent: Wednesday, March 11, 2015 9:29 PM
To: Ngoni Manika
Cc: Knut Staring; dhis2-users
Subject: RE: [Dhis2-users] Restore a large PostgreSQL dump

 

Thats a bit odd. If the data was in the table when it was dumped it should
be there when its restored. Looks like the dump file could be corrupted.
Are you restoring with pgadmin. You might have better luck with command
line.
If you don't have the option to make another dump then leave out these big
useless analytics tables as others have suggested

On 11 Mar 2015 19:49, Ngoni Manika nman...@hotmail.com
mailto:nman...@hotmail.com  wrote:

 Thanks Bob

  

 Below is the error im getting

  

 pg_restore: [archiver (db)] Error while PROCESSING TOC:

 pg_restore: [archiver (db)] Error from TOC entry 5328; 0 1415587 TABLE
DATA analytics_2014 postgres

 pg_restore: [archiver (db)] COPY failed for table analytics_2014: ERROR:
missing data for column NDAElbuYMNM

 CONTEXT:  COPY analytics_2014, line 11201741: \N \N   \N
\N   \N   xuuDrpnpEPDc2g5zOOo

 pg_restore: restoring data for table analytics_2015

 pg_restore: [tar archiver] corrupt tar header found in \N (expected 3679,
computed 33533) file position 9118576128

  

 Regards

  

 Ngonidzashe Manika

 Data Officer

 +263 772 789673, nman...@hotmail.com mailto:nman...@hotmail.com , skype:
ngoni.manika

 Ministry of Health and Child Care, AIDS and TB Unit, 2nd Floor, Library,
Mkwati Building

  

 From: Bob Jolliffe [mailto:bobjolli...@gmail.com
mailto:bobjolli...@gmail.com ] 
 Sent: Wednesday, March 11, 2015 6:52 PM
 To: Knut Staring
 Cc: Ngoni Manika; dhis2-users
 Subject: Re: [Dhis2-users] Restore a large PostgreSQL dump

  

 Knut and Jason are both right.  There is no point dumping tables which can
be recreated.

  

 But that in itself shouldn't cause an error restoring a dump and 16G is
far from huge (of course too big for notepad++ but that's a different
issue).  What was the error message?

  

 On 11 March 2015 at 16:39, Knut Staring knu...@gmail.com
mailto:knu...@gmail.com  wrote:

 This advice may be a bit late for you,  but I would recommend excluding
analytics when you do a backup.

 On 11 Mar 2015 17:31, Ngoni Manika nman...@hotmail.com
mailto:nman...@hotmail.com  wrote:

 Hi team

  

 I am having a challenge on restoring a postres dump which is large
(16gig), it gives an error on restoring data in table analytics 2014.

  

 Can anyone please help with how I can go around it, or maybe how to edit
the dump (notepad++ cannot open the file is too large).

  

 Regards

  

 Ngonidzashe Manika

 Data Officer

 +263 772 789673, nman...@hotmail.com mailto:nman...@hotmail.com ,
skype: ngoni.manika

 Ministry of Health and Child Care, AIDS and TB Unit, 2nd Floor, Library,
Mkwati Building

  

  

 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-users@lists.launchpad.net
mailto: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
mailto: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] Restore a large PostgreSQL dump

[Ngoni Manika]

Thanks Bob

 

Below is the error im getting

 

pg_restore: [archiver (db)] Error while PROCESSING TOC:

pg_restore: [archiver (db)] Error from TOC entry 5328; 0 1415587 TABLE DATA
analytics_2014 postgres

pg_restore: [archiver (db)] COPY failed for table analytics_2014: ERROR:
missing data for column NDAElbuYMNM

CONTEXT:  COPY analytics_2014, line 11201741: \N \N   \N
\N   \N   xuuDrpnpEPDc2g5zOOo

pg_restore: restoring data for table analytics_2015

pg_restore: [tar archiver] corrupt tar header found in \N (expected 3679,
computed 33533) file position 9118576128

 

Regards

 

Ngonidzashe Manika

Data Officer

+263 772 789673, nman...@hotmail.com mailto:nman...@hotmail.com , skype:
ngoni.manika

Ministry of Health and Child Care, AIDS and TB Unit, 2nd Floor, Library,
Mkwati Building

 

From: Bob Jolliffe [mailto:bobjolli...@gmail.com] 
Sent: Wednesday, March 11, 2015 6:52 PM
To: Knut Staring
Cc: Ngoni Manika; dhis2-users
Subject: Re: [Dhis2-users] Restore a large PostgreSQL dump

 

Knut and Jason are both right.  There is no point dumping tables which can
be recreated.

 

But that in itself shouldn't cause an error restoring a dump and 16G is far
from huge (of course too big for notepad++ but that's a different issue).
What was the error message?

 

On 11 March 2015 at 16:39, Knut Staring knu...@gmail.com
mailto:knu...@gmail.com  wrote:

This advice may be a bit late for you,  but I would recommend excluding
analytics when you do a backup. 

On 11 Mar 2015 17:31, Ngoni Manika nman...@hotmail.com
mailto:nman...@hotmail.com  wrote:

Hi team

 

I am having a challenge on restoring a postres dump which is large (16gig),
it gives an error on restoring data in table analytics 2014.

 

Can anyone please help with how I can go around it, or maybe how to edit the
dump (notepad++ cannot open the file is too large).

 

Regards

 

Ngonidzashe Manika

Data Officer

+263 772 789673, nman...@hotmail.com mailto:nman...@hotmail.com , skype:
ngoni.manika

Ministry of Health and Child Care, AIDS and TB Unit, 2nd Floor, Library,
Mkwati Building

 

 

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
mailto: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
mailto: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