Maybe you should turn of PG logging the DDL statements.. maybe there is startdate failed because of xyz, could be useful in hunting down the issue..
-- Morten Olav Hansen Senior Engineer, DHIS 2 University of Oslo http://www.dhis2.org On Tue, Aug 23, 2016 at 3:55 PM, Vanya Seth <van...@thoughtworks.com> wrote: > Well its very strange as this works fine in our local machines. > > On the VM's even tried dropping the db, creating new and then deploying > the war. Still to no avail. > > Mostly this manual creation of columns should work. But what if there are > other such things that might have been missed and will only come up when we > try to do some operations. > > Regards > Vanya > > On Tue, Aug 23, 2016 at 1:06 PM, Morten Olav Hansen <mor...@dhis2.org> > wrote: > >> That sounds strange Vanya, looked at the HBM files and there was nothing >> special about those fields. >> >> Could you try a manual add: >> alter table mapview add column startdate timestamp without time zone >> alter table mapview add column enddate timestamp without time zone >> >> and see if that fixes it (I haven't seen this issue anywhere else, so >> could be something very local) >> >> -- >> Morten Olav Hansen >> Senior Engineer, DHIS 2 >> University of Oslo >> http://www.dhis2.org >> >> On Tue, Aug 23, 2016 at 1:59 PM, Vanya Seth <van...@thoughtworks.com> >> wrote: >> >>> >>> Hello devs >>> >>> We were updating our test VM's to 2.24 from 2.21. We did it in an >>> incremental manner. >>> Apparently on few of the VM's after upgrade the /api/24/metadata (GET) >>> call is failing with the following error: >>> >>> WARN 2016-08-23 11:47:59,957 SQL Error: 0, SQLState: 42703 >>> (SqlExceptionHelper.java [http-bio-8080-exec-8]) >>> * ERROR 2016-08-23 11:47:59,957 ERROR: column this_.startdate does not >>> exist >>> Position: 463 (SqlExceptionHelper.java [http-bio-8080-exec-8]) >>> org.hibernate.exception.SQLGrammarException: could not extract >>> ResultSet >>> >>> We checked the startup logs and there was no specific error around table >>> update errors. It seems the mapview relation now has two new columns >>> 'startdate' and 'enddate'. These are not getting created during the >>> deployment and hence the metadata export call is failing. >>> >>> Tried stopping the server and restarting it multiple times but to no >>> avail. >>> >>> Can you please look into this and let know what could be causing this >>> strange issue. >>> >>> -- >>> With Regards >>> Vanya >>> >>> ThoughtWorks Technologies >>> Hyderabad >>> >>> --Stay Hungry Stay Foolish!! >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-devs >>> Post to : dhis2-devs@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> > > > -- > With Regards > ThoughtWorks Technologies > Hyderabad > > --Stay Hungry Stay Foolish!! >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
