Re: [Dhis2-devs] [Dhis2-users] Error while running analytics in 2.29

2018-06-05 Thread gerald thomas 
Dear Kumar,
What version of Postgres are running? Normally, these errors occurs when
the postgres.conf is not configured properly based on the data size it has
to analyzed.
Please can you send your Postgres.conf file.

On Tue, 5 Jun 2018 at 05:40, Kumar Shahdeo 
wrote:

> Yes, I rebooted the server, but still I am getting the same issue while
> running analytics
>
> On Tue, Jun 5, 2018 at 10:52 AM, gerald thomas 
> wrote:
>
>> Dear Kumar,
>> Have you tried to reboot the server after upgrades and then run analytics
>> again?
>>
>> On Tue, 5 Jun 2018 at 04:49, Kumar Shahdeo 
>> wrote:
>>
>>> Hi DHIS users,
>>>
>>>
>>> I have migrated from DHIS 2.27 to DHIS 2.29. I used the upgrade script
>>> provided by DHIS to upgrade the db. I have tried both incremental upgrade
>>> (2.27->2.28->2.29) and skipping 2.28(2.27->2.29). In both the cases I am
>>> getting the same issue.
>>>
>>> I am not able to run analytics. Analytics fails with below
>>> error(captured in screenshot)
>>>
>>>
>>>
>>>
>>>
>>> When I checked server logs. I got this exception :
>>>
>>> org.springframework.dao.DataIntegrityViolationException with error
>>> message ‘new row for relation "analytics_temp_2012" violates check
>>> constraint "analytics_temp_2012,_yearly_check”’
>>>
>>>
>>> Any suggestions on this will be highly appreciated.
>>>
>>> Regards
>>> --
>>> Kumar Gaurav Nath Shahdeo
>>> Developer
>>> Email gaura...@thoughtworks.com
>>> Telephone +91 9160688935 <+91+9160688935>
>>> [image: ThoughtWorks]
>>> 
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-us...@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>> --
>> Regards,
>>
>> Gerald
>>
>
>
>
> --
> Kumar Gaurav Nath Shahdeo
> Developer
> Email gaura...@thoughtworks.com
> Telephone +91 9160688935 <+91+9160688935>
> [image: ThoughtWorks]
> 
>
-- 
Regards,

Gerald
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Error while running analytics in 2.29

2018-06-04 Thread Kumar Shahdeo 
Yes, I rebooted the server, but still I am getting the same issue while
running analytics

On Tue, Jun 5, 2018 at 10:52 AM, gerald thomas 
wrote:

> Dear Kumar,
> Have you tried to reboot the server after upgrades and then run analytics
> again?
>
> On Tue, 5 Jun 2018 at 04:49, Kumar Shahdeo 
> wrote:
>
>> Hi DHIS users,
>>
>>
>> I have migrated from DHIS 2.27 to DHIS 2.29. I used the upgrade script
>> provided by DHIS to upgrade the db. I have tried both incremental upgrade
>> (2.27->2.28->2.29) and skipping 2.28(2.27->2.29). In both the cases I am
>> getting the same issue.
>>
>> I am not able to run analytics. Analytics fails with below error(captured
>> in screenshot)
>>
>>
>>
>>
>>
>> When I checked server logs. I got this exception :
>>
>> org.springframework.dao.DataIntegrityViolationException with error
>> message ‘new row for relation "analytics_temp_2012" violates check
>> constraint "analytics_temp_2012,_yearly_check”’
>>
>>
>> Any suggestions on this will be highly appreciated.
>>
>> Regards
>> --
>> Kumar Gaurav Nath Shahdeo
>> Developer
>> Email gaura...@thoughtworks.com
>> Telephone +91 9160688935 <+91+9160688935>
>> [image: ThoughtWorks]
>> 
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
> --
> Regards,
>
> Gerald
>



-- 
Kumar Gaurav Nath Shahdeo
Developer
Email gaura...@thoughtworks.com
Telephone +91 9160688935 <+91+9160688935>
[image: ThoughtWorks]

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Error while running analytics in 2.29

2018-06-04 Thread gerald thomas 
Dear Kumar,
Have you tried to reboot the server after upgrades and then run analytics
again?

On Tue, 5 Jun 2018 at 04:49, Kumar Shahdeo 
wrote:

> Hi DHIS users,
>
>
> I have migrated from DHIS 2.27 to DHIS 2.29. I used the upgrade script
> provided by DHIS to upgrade the db. I have tried both incremental upgrade
> (2.27->2.28->2.29) and skipping 2.28(2.27->2.29). In both the cases I am
> getting the same issue.
>
> I am not able to run analytics. Analytics fails with below error(captured
> in screenshot)
>
>
>
>
>
> When I checked server logs. I got this exception :
>
> org.springframework.dao.DataIntegrityViolationException with error message
> ‘new row for relation "analytics_temp_2012" violates check constraint
> "analytics_temp_2012,_yearly_check”’
>
>
> Any suggestions on this will be highly appreciated.
>
> Regards
> --
> Kumar Gaurav Nath Shahdeo
> Developer
> Email gaura...@thoughtworks.com
> Telephone +91 9160688935 <+91+9160688935>
> [image: ThoughtWorks]
> 
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
-- 
Regards,

Gerald
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp