dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #46491
Upgrading to 2.24 and /api/24/metadata issue
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!!
Follow ups