| Thread Previous • Date Previous • Date Next • Thread Next |
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>
Attachment:
postgresql.conf
Description: Binary data
| Thread Previous • Date Previous • Date Next • Thread Next |
