dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi Caveman,
Took a look at your files, but the process when the analytics tables are
generated are not there. This would be useful to see but from your SQL
output, it seems they are there.

Are you sure that your chart/table has been specified properly? I have seen
this bug with legacy charts, so it might be useful to try and create a new
one and be sure it is not related to this. While you do this, "tail" the
catalina.out log and send us the output.

Regards,
Jason



On Sun, Jul 28, 2013 at 8:31 PM, Orvalho Augusto <orvaquim@xxxxxxxxx> wrote:

> 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 <larshelge@xxxxxxxxx>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" <orvaquim@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>> > Unsubscribe : https://launchpad.net/~dhis2-devs
>> > More help   : https://help.launchpad.net/ListHelp
>> >
>>
>>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>