dhis2-users team mailing list archive
-
dhis2-users team
-
Mailing list archive
-
Message #15897
Re: Error while running analytics in 2.29
Kumar,
What is the RAM size of this server, Is it 8BG?
On Tue, Jun 5, 2018 at 6:39 AM, Kumar Shahdeo <gauravns@xxxxxxxxxxxxxxxx>
wrote:
> 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>
>
--
Regards,
Gerald
Follow ups
References