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

Re: [Dhis2-users] Analytics error

[Jason Pickering]

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

Re: [Dhis2-users] Analytics Error: Process failed: StatementCallback; bad SQL grammar [create table analytics_event_temp_zxbjnsrdsai ("uidlevel1" character(11),"uidlevel2" character..

[Alejandro]

Hi Allan,

We had a similar error and in our case it was related to this indication in
the update instructions:


   - *PostGIS* is now a required extension for PostgreSQL. Make sure to
   install and enable PostGis in your database before upgrading to DHIS 2.30.
   Please consult the installation guide
   

   .

Just in case is the same issue.

Cheers,
Alejandro

On Thu, Jul 26, 2018 at 12:53 PM, Allan Makunku  wrote:

> Dear All
>
> I just upgraded my dhis2 instance from 2.29 to 2.30. However whenever I
> want to run analytics, I am getting the above error. Has anyone come
>  dhis.log
> 
> across this and what can I do to have it resolved. Attached is the log file
>
> Please help.
>
> Allan
>
> ___
> 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] Analytics error after upgrade to 2.29

[Knut Staring]

Still not sure why this error arose, but *fixed it" by deleting
completenessregistrations from before 2015:

delete from completedatasetregistration where periodid in (select periodid
from period where startdate <'2015-01-01')

On Tue, May 8, 2018 at 7:43 PM, Knut Staring  wrote:

> There seems to be a problem with year (it is trying to insert 2015 in a
> table that requires 2014). Does anyone have an insight into why this
> happens?
>
> Caused by: org.postgresql.util.PSQLException: ERROR: new row for relation
> "analytics_completeness_temp_2014" violates check constraint
> "analytics_completeness_temp_2014_yearly_check"
>   Detail: Failing row contains (null, null, null, null, XbBIPEpxTue,
> XbBIPEpxTue, aRxa6o8GqZN, HfVjCurKxh2, t0J75eHKxz5, xLWuQq3DjOR,
> iZNVvlnVxm6, ELzS3pnwJyh, null, null, null, null, null, null, null, 2015W1,
> null, null, null, null, 2015BiW0, 201501, 201501B, 2015Q1, 2015S1,
> 2014AprilS2, 2015, 2014April, 2014July, 2014Oct, t, zJrL4HQqYmD,
> 2015-01-06).
>



-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
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: "Process failed: Exception during execution"

[Aldren Gonzales]

Hi Lars,

It is already working with 2.21! Thank you very much for the assistance.

-Aldren




**  Please consider the environment before printing this e-mail.

*IMPORTANT:* This email is intended for the use of the individual
addressee(s) named above and may contain information that is confidential,
privileged or unsuitable for overly sensitive persons with low self-esteem,
no sense of humour or irrational religious beliefs. If you are not the
intended recipient, any dissemination, distribution or copying of this
email is not authorised (either explicitly or implicitly) and constitutes
an irritating social faux pas.


On Fri, Dec 11, 2015 at 9:38 PM, Lars Helge Øverland 
wrote:

> Hi,
>
> fixed now in 2.21.
>
> regards,
>
> Lars
>
>
> On Fri, Dec 11, 2015 at 8:38 AM, Aldren Gonzales  > wrote:
>
>> ​​​
>>  host-manager.2015-12-07.log
>> <
>> https://drive.google.com/file/d/0BySmpLv3ac4xZUtJMlpUcDQyekU/view?usp=drive_web
>> >
>> ​Hi Everyone,
>>
>> Our team is currently exploring DHIS2 for our project here in the
>> Philippines. I have installed DHIS2 with MySql database on localhost and
>> worked fine (entering org units, data elements, and forms). However, when
>> running analytics, I got this error:
>>
>> [image: Inline image 1]
>>
>>
>> I have attached the log files for your reference. I hope someone could
>> help
>> me on this.
>>
>> Cheers,
>>
>> Aldren Gonzales
>>
>>
>> **  Please consider the environment before printing this e-mail.
>>
>> *IMPORTANT:* This email is intended for the use of the individual
>> addressee(s) named above and may contain information that is confidential,
>> privileged or unsuitable for overly sensitive persons with low
>> self-esteem,
>> no sense of humour or irrational religious beliefs. If you are not the
>> intended recipient, any dissemination, distribution or copying of this
>> email is not authorised (either explicitly or implicitly) and constitutes
>> an irritating social faux pas.
>>
>> ___
>> 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
>>
>>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> http://www.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] Analytics Error: "Process failed: Exception during execution"

[Lars Helge Øverland]

Hi,

fixed now in 2.21.

regards,

Lars


On Fri, Dec 11, 2015 at 8:38 AM, Aldren Gonzales 
wrote:

> ​​​
>  host-manager.2015-12-07.log
> <
> https://drive.google.com/file/d/0BySmpLv3ac4xZUtJMlpUcDQyekU/view?usp=drive_web
> >
> ​Hi Everyone,
>
> Our team is currently exploring DHIS2 for our project here in the
> Philippines. I have installed DHIS2 with MySql database on localhost and
> worked fine (entering org units, data elements, and forms). However, when
> running analytics, I got this error:
>
> [image: Inline image 1]
>
>
> I have attached the log files for your reference. I hope someone could help
> me on this.
>
> Cheers,
>
> Aldren Gonzales
>
>
> **  Please consider the environment before printing this e-mail.
>
> *IMPORTANT:* This email is intended for the use of the individual
> addressee(s) named above and may contain information that is confidential,
> privileged or unsuitable for overly sensitive persons with low self-esteem,
> no sense of humour or irrational religious beliefs. If you are not the
> intended recipient, any dissemination, distribution or copying of this
> email is not authorised (either explicitly or implicitly) and constitutes
> an irritating social faux pas.
>
> ___
> 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
>
>


-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
http://www.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