← Back to team overview

dhis2-users team mailing list archive

Re: Error while running analytics in 2.29

 

I am using Postgres 9.4 . Please find the attached postgres conf file

On Tue, Jun 5, 2018 at 11:24 AM, gerald thomas <gerald17006@xxxxxxxxx>
wrote:

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



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

PNG image

Attachment: postgresql.conf
Description: Binary data


Follow ups

References