=== modified file 'dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/startup/TableAlteror.java' --- dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/startup/TableAlteror.java 2012-11-07 07:08:15 +0000 +++ dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/startup/TableAlteror.java 2012-11-07 08:12:06 +0000 @@ -149,6 +149,8 @@ executeSql( "ALTER TABLE mapview RENAME COLUMN maplegendtype TO legendtype" ); executeSql( "ALTER TABLE mapview RENAME COLUMN maplegendsetid TO legendsetid" ); executeSql( "ALTER TABLE mapview ALTER COLUMN opacity TYPE double precision" ); + + executeSql( "ALTER TABLE datavalue ALTER COLUMN storedby TYPE character varying(100)" ); executeSql( "ALTER TABLE maplegend DROP CONSTRAINT maplegend_name_key" ); === modified file 'dhis-2/dhis-services/dhis-service-core/src/main/resources/org/hisp/dhis/datavalue/hibernate/DataValue.hbm.xml' --- dhis-2/dhis-services/dhis-service-core/src/main/resources/org/hisp/dhis/datavalue/hibernate/DataValue.hbm.xml 2011-12-19 16:44:56 +0000 +++ dhis-2/dhis-services/dhis-service-core/src/main/resources/org/hisp/dhis/datavalue/hibernate/DataValue.hbm.xml 2012-11-07 08:12:06 +0000 @@ -15,7 +15,7 @@ - + === modified file 'dhis-2/dhis-services/dhis-service-datamart-default/src/main/java/org/hisp/dhis/datamart/engine/DefaultDataMartEngine.java' --- dhis-2/dhis-services/dhis-service-datamart-default/src/main/java/org/hisp/dhis/datamart/engine/DefaultDataMartEngine.java 2012-08-29 15:44:32 +0000 +++ dhis-2/dhis-services/dhis-service-datamart-default/src/main/java/org/hisp/dhis/datamart/engine/DefaultDataMartEngine.java 2012-11-07 08:12:06 +0000 @@ -291,7 +291,7 @@ indicatorOperands.retainAll( allOperands ); clock.logTime( "Number of operands with data: " + allOperands.size() + ", " + SystemUtils.getMemoryString() ); - notifier.notify( id, DATAMART, "Populating crosstabulation table" ); + notifier.notify( id, DATAMART, "Populating crosstab table" ); // --------------------------------------------------------------------- // Create crosstabtable === modified file 'dhis-2/dhis-support/dhis-support-system/src/main/java/org/hisp/dhis/system/util/SystemUtils.java' --- dhis-2/dhis-support/dhis-support-system/src/main/java/org/hisp/dhis/system/util/SystemUtils.java 2012-01-09 20:03:56 +0000 +++ dhis-2/dhis-support/dhis-support-system/src/main/java/org/hisp/dhis/system/util/SystemUtils.java 2012-11-07 08:12:06 +0000 @@ -56,8 +56,9 @@ public static String getMemoryString() { - return "Mem used: " + ( Runtime.getRuntime().totalMemory() / FACTOR_MB ) + - ", max: " + ( Runtime.getRuntime().maxMemory() / FACTOR_MB ) + - ", free: " + ( Runtime.getRuntime().freeMemory() / FACTOR_MB ); + return "Mem Total in JVM: " + ( Runtime.getRuntime().totalMemory() / FACTOR_MB ) + + " Free in JVM: " + ( Runtime.getRuntime().freeMemory() / FACTOR_MB ) + + " Max Limit: " + ( Runtime.getRuntime().maxMemory() / FACTOR_MB ); + } } === modified file 'dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/about/about.vm' --- dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/about/about.vm 2012-10-11 16:23:03 +0000 +++ dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/about/about.vm 2012-11-07 08:12:06 +0000 @@ -19,5 +19,7 @@
$i18n.getString( "os_architecture" ):
$systemProperties.get( "os.arch" )
$i18n.getString( "os_version" ):
$systemProperties.get( "os.version" )
$i18n.getString( "server_date" ):
$format.formatDateTime( $serverDate )
+
$i18n.getString( "server_memory" ):
$memoryInfo
+
$i18n.getString( "cpu_cores" ):
$cpuCores
#end \ No newline at end of file === modified file 'dhis-2/dhis-web/dhis-web-commons/src/main/java/org/hisp/dhis/about/action/AboutAction.java' --- dhis-2/dhis-web/dhis-web-commons/src/main/java/org/hisp/dhis/about/action/AboutAction.java 2012-10-11 16:23:03 +0000 +++ dhis-2/dhis-web/dhis-web-commons/src/main/java/org/hisp/dhis/about/action/AboutAction.java 2012-11-07 08:12:06 +0000 @@ -42,6 +42,7 @@ import org.hisp.dhis.i18n.I18n; import org.hisp.dhis.system.database.DatabaseInfo; import org.hisp.dhis.system.database.DatabaseInfoProvider; +import org.hisp.dhis.system.util.SystemUtils; import org.hisp.dhis.user.CurrentUserService; import org.hisp.dhis.util.ContextUtils; @@ -165,6 +166,20 @@ { return serverDate; } + + private String memoryInfo; + + public String getMemoryInfo() + { + return memoryInfo; + } + + private int cpuCores; + + public int getCpuCores() + { + return cpuCores; + } // ------------------------------------------------------------------------- // Action implementation @@ -242,6 +257,10 @@ currentUserIsSuper = currentUserService.currentUserIsSuper(); + memoryInfo = SystemUtils.getMemoryString(); + + cpuCores = SystemUtils.getCpuCores(); + return SUCCESS; } } === modified file 'dhis-2/dhis-web/dhis-web-commons/src/main/resources/i18n_global.properties' --- dhis-2/dhis-web/dhis-web-commons/src/main/resources/i18n_global.properties 2012-11-03 20:19:30 +0000 +++ dhis-2/dhis-web/dhis-web-commons/src/main/resources/i18n_global.properties 2012-11-07 08:12:06 +0000 @@ -352,6 +352,8 @@ messages=Messages interpretations=Interpretations interface_style=Interface style +server_memory=Server memory +cpu_cores=CPU cores #-- Change Log------------------------------------------------------------------# === modified file 'resources/sql/div.sql' --- resources/sql/div.sql 2012-10-29 10:01:44 +0000 +++ resources/sql/div.sql 2012-11-07 08:12:06 +0000 @@ -90,3 +90,15 @@ from users u join userinfo ui on u.userid=ui.userinfoid order by u.username; + +-- Explore report tables + +select rt.name, rt.paramleafparentorganisationunit as leaf, +rt.paramgrandparentorganisationunit as grand, rt.paramparentorganisationunit as parent, +(select count(*) from reporttable_dataelements where reporttableid=rt.reporttableid) as de, +(select count(*) from reporttable_datasets where reporttableid=rt.reporttableid) as ds, +(select count(*) from reporttable_indicators where reporttableid=rt.reporttableid) as in, +(select count(*) from reporttable_organisationunits where reporttableid=rt.reporttableid) as ou, +(select count(*) from reporttable_orgunitgroups where reporttableid=rt.reporttableid) as oug, +(select count(*) from reporttable_periods where reporttableid=rt.reporttableid) as pe +from reporttable rt;