Okay thanks Ferdie. I suspect the problem a missing value in the valuetype
column.
Try running this SQL and see what effect it has:
update dataelement set valuetype='UNIT_INTERVAL' where
numbertype='unitInterval';
I will change the upgrade statements inside dhis accordingly if this has
any effe
Attached the catalina log.
Till now - I have a 2.20 db running perfectly.
* I then used the Data Administration/Maintenance option and selected "Drop
SQL Views".
* After the maintenance was performed, I verified in PgAdmin that no views
exist in the db.
* I now replaced the 2.20 WAR with a 2.21 WA
Hi Ferdie,
okay. Are you getting the same error this time or another one? Do you think
you could post the output to the Tomcat log from when you started last time?
Lars
On Fri, Nov 13, 2015 at 9:25 AM, Ferdie Botha wrote:
> Hi Lars, all views were dropped prior to the upgrade using the mainten
Hi Lars, all views were dropped prior to the upgrade using the maintenance
functionality. PgAdmin also indicated "Views (0)" in the database.
Should I delete the SQL views altogether instead of just "Drop SQL views"
from the Maintenance User-Screen?
Any other potential reasons I can investigate?
Hi Ferdie,
I guess the problem is that you have some SQL views which refer to the
dataelement table. We are changing the length of the dataelement.valuetype
column in 2.21. For that to work you need to drop all SQL views prior to
the first time you start on 2.21. This information can be found in t
Hi,
I have a VM running Ubuntu 15.10, Java OpenJDK (Latest version), Tomcat 8,
PostgreSQL 9.4.
The DHIS instance is running version 2.20.
Via PGAdmin the number of Views on the db is confirmed to be 0.
When upgrading to version 2.21 (by replacing the 2.20 WAR file with the
2.21 version), I expe
6 matches
Mail list logo