Thanks! The medicine suggested (generating the resources tables manually) did not make the bad spirits go away. Still the same interesting empty window.
I follow your recommendations below. On Sun, Jul 28, 2013 at 6:09 PM, Lars Helge Ă˜verland <larshe...@gmail.com>wrote: > Hi Caveman, > > First try to run the resource tables directly from maintenance. > > If that works, can you please look around and tell us whether: > > - there are any exceptions in any of the tomcat logs, there might be > access*, localhost*, manager*, catalina.out. > There is one exception occurring when I log into DHIS on localhost* file SEVERE: Servlet.service() for servlet webapi threw exception org.hisp.dhis.analytics.IllegalQueryException: At least one period must be specified as dimension or filter at org.hisp.dhis.analytics.data.DefaultQueryPlanner.validate(DefaultQueryPlanner.java:149) at org.hisp.dhis.analytics.data.DefaultAnalyticsService.getAggregatedDataValues(DefaultAnalyticsService.java:186) at org.hisp.dhis.analytics.data.DefaultAnalyticsService.getAggregatedDataValueMapping(DefaultAnalyticsService.java:446) at org.hisp.dhis.analytics.data.DefaultAnalyticsService.getAggregatedDataValueMapping(DefaultAnalyticsService.java:477) at org.hisp.dhis.chart.impl.DefaultChartService.getCategoryDataSet(DefaultChartService.java:681) at org.hisp.dhis.chart.impl.DefaultChartService.getJFreeChart(DefaultChartService.java:499) at org.hisp.dhis.chart.impl.DefaultChartService.getJFreeChart(DefaultChartService.java:202) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) And thereafter nothing else even when I try to run Pivot table or Charts. On catalina.out there are some errors related to alter table and add keys which have been described on previous mails as innocent messages. > - there are any tables in Mr database starting with analytics* > Mr database contain those great anlytics* table Schema | Name | Type | Owner --------+------------------------------------------+----------+------- public | Sheet1 | table | dhis public | _categoryoptioncomboname | table | dhis public | _categorystructure | table | dhis public | _dataelementcategoryoptioncombo | table | dhis public | _dataelementgroupsetstructure | table | dhis public | _dataelementstructure | table | dhis public | _indicatorgroupsetstructure | table | dhis public | _organisationunitgroupsetstructure | table | dhis public | _orgunitstructure | table | dhis public | _periodstructure | table | dhis public | _view_makeconemdummies | view | dhis public | _view_pgactivity | view | dhis public | _view_rootorgunits | view | dhis public | _view_sqlteste | view | dhis public | aggregateddatasetcompleteness | table | dhis public | aggregateddatavalue | table | dhis public | aggregatedindicatorvalue | table | dhis public | aggregatedorgunitdatasetcompleteness | table | dhis public | aggregatedorgunitdatavalue | table | dhis public | aggregatedorgunitindicatorvalue | table | dhis public | analytics_2011 | table | dhis public | analytics_2012 | table | dhis public | analytics_2013 | table | dhis - how many records there are in these tables > dhis2=# select 2011 as year, count(*) as N from analytics_2011 union all select 2012, count(*) as N from analytics_2012 union all select 2013, count(*) as N from analytics_2013; year | n ------+-------- 2011 | 161 2012 | 821318 2013 | 279987 (3 rows) > - please also post your tomcat log contents after the process starts. > Those tomcat gossips are attached on the mail. They have targzipped. Lars > > > Thanks! Caveman > On Jul 27, 2013 8:28 PM, "Orvalho Augusto" <orvaq...@gmail.com> wrote: > > > > I have setup a DHIS server with the war: > > Version: > > 2.12 > > Build revision: > > 11253 > > Build date: > > 2013-07-26 15:57 > > Using OpenJDK 7 on a 64 bit linux box and PostreSQL 9.2. > > > > The problem: > > NO table neither chart can be dispalyed. I have tried a lot of > dataelements for the periods and organisationunit I know to have data but I > just have a small blank window. And Mr tomcat doens't say nothing on the > logs (I have -f on tail command). > > > > I have run Mr Analytics and Mr Datamart. And I am on Firefox 22 (64 bit > Xubuntu). > > Caveman > > > > > > > > > > _______________________________________________ > > 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 > > > >
tomcatlog.tar.gz
Description: GNU Zip compressed data
_______________________________________________ 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