← Back to team overview

dhis2-users team mailing list archive

Re: Error while running analytics in 2.29

 

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 <gauravns@xxxxxxxxxxxxxxxx>
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 <gerald17006@xxxxxxxxx>
> 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 <gauravns@xxxxxxxxxxxxxxxx>
>> 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 gauravns@xxxxxxxxxxxxxxxx
>>> Telephone +91 9160688935 <+91+9160688935>
>>> [image: ThoughtWorks]
>>> <http://www.thoughtworks.com/?utm_campaign=kumar-gaurav%20nath%20shahdeo-signature&utm_medium=email&utm_source=thoughtworks-email-signature-generator>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>> --
>> Regards,
>>
>> Gerald
>>
>
>
>
> --
> Kumar Gaurav Nath Shahdeo
> Developer
> Email gauravns@xxxxxxxxxxxxxxxx
> Telephone +91 9160688935 <+91+9160688935>
> [image: ThoughtWorks]
> <http://www.thoughtworks.com/?utm_campaign=kumar-gaurav%20nath%20shahdeo-signature&utm_medium=email&utm_source=thoughtworks-email-signature-generator>
>
-- 
Regards,

Gerald

PNG image


Follow ups

References