dhis2-users team mailing list archive

[Kumar Shahdeo <gauravns@xxxxxxxxxxxxxxxx>]

Yes, its 8 GB

On Tue, Jun 5, 2018 at 2:13 PM, gerald thomas <gerald17006@xxxxxxxxx> wrote:

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



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