dhis2-devs team mailing list archive

[Ese Egerega <ese@xxxxxxxxxx>]

Dear All,

Am having trouble with my dhis2 instance after upgrading from dhis2.17 to
2.18. After loading the 2.18 war file, I no longer have access to the
system. The home page loads quite alright but when I try to login I get the
following error message:
An exception occurred

Sorry! The system failed to execute the operation. Usually, no data is lost
and you can continue working by going back to the previous page.
My tomcat error log shows something like column organisati1_.active does
not exist.

See details below:

* WARN  2015-04-12 15:39:57,998 SQL Error: 0, SQLState: 42703
(SqlExceptionHelper.java [ajp-bio-8009-exec-18])
* ERROR 2015-04-12 15:39:57,998 ERROR: column organisati1_.active does not
exist
  Position: 608 (SqlExceptionHelper.java [ajp-bio-8009-exec-18])
* ERROR 2015-04-12 15:39:57,998 Error while executing action
(ExceptionInterceptor.java [ajp-bio-8009-exec-18])
org.hibernate.exception.SQLGrammarException: could not extract ResultSet

I will appreciate any advice
.

Thanks,
Ese