dhis2-devs team mailing list archive

[Orvalho Augusto <orvaquim@xxxxxxxxx>]

Thank you for the time you took on this.

I attach attach the logs containing the precious analytics generation
moment. I logged the machine by
"INFO  2013-07-29 12:53:20".

I went to pivot tables and tried to build a table (dataelement: first
consultations, period: all months from 2012, organisationunities: I have
chosen a lot of levels and specific health centers). The layout is rows for
data, columns for periods and filter the organisationunit.

During that time no word from Mr tomcat on catalina.out! I clicked the home
button there was some special words from tomcat:

Hibernate: select documents0_.userid as userid1_27_3_,
documents0_.documentid as document2_28_3_, documents0_.sort_order as
sort3_3_, document1_.documentid as document1_58_0_, document1_.uid as
uid2_58_0_, document1_.code as code3_58_0_, document1_.created as
created4_58_0_, document1_.lastUpdated as lastUpda5_58_0_, document1_.name
as name6_58_0_, document1_.url as url7_58_0_, document1_.external as
external8_58_0_, document1_.contentType as contentT9_58_0_,
document1_.userid as userid10_58_0_, document1_.publicAccess as
publicA11_58_0_, user2_.userinfoid as userinfo1_189_1_, user2_.uid as
uid2_189_1_, user2_.code as code3_189_1_, user2_.lastUpdated as
lastUpda4_189_1_, user2_.created as created5_189_1_, user2_.surname as
surname6_189_1_, user2_.firstName as firstNam7_189_1_, user2_.email as
email8_189_1_, user2_.phoneNumber as phoneNum9_189_1_, user2_.jobTitle as
jobTitl10_189_1_, user2_.introduction as introdu11_189_1_, user2_.gender as
gender12_189_1_, user2_.birthday as birthda13_189_1_, user2_.nationality as
nationa14_189_1_, user2_.employer as employe15_189_1_, user2_.education as
educati16_189_1_, user2_.interests as interes17_189_1_, user2_.languages as
languag18_189_1_, user2_.lastCheckedInterpretations as lastChe19_189_1_,
usercreden3_.userid as userid1_196_2_, usercreden3_.username as
username2_196_2_, usercreden3_.password as password3_196_2_,
usercreden3_.lastLogin as lastLogi4_196_2_, usercreden3_.restoreToken as
restoreT5_196_2_, usercreden3_.restoreCode as restoreC6_196_2_,
usercreden3_.restoreExpiry as restoreE7_196_2_, usercreden3_.selfRegistered
as selfRegi8_196_2_, usercreden3_.disabled as disabled9_196_2_,
usercreden3_.created as created10_196_2_ from dashboardcontent_documents
documents0_ inner join document document1_ on
documents0_.documentid=document1_.documentid left outer join userinfo
user2_ on document1_.userid=user2_.userinfoid left outer join users
usercreden3_ on user2_.userinfoid=usercreden3_.userid where
documents0_.userid=?
* WARN  2013-07-29 13:05:44,725 Validation failed: At least one period must
be specified as dimension or filter (DefaultQueryPlanner.java [http-8080-8])
* WARN  2013-07-29 13:05:45,087 Validation failed: At least one period must
be specified as dimension or filter (DefaultQueryPlanner.java
[http-8080-10])
* WARN  2013-07-29 13:05:45,095 Validation failed: At least one period must
be specified as dimension or filter (DefaultQueryPlanner.java [http-8080-3])

I decided to go back to the Pivot tables. Tomcat screamos this interesting
line:
* WARN  2013-07-29 13:06:04,122 HHH000179: Narrowing proxy to class
org.hisp.dhis.period.YearlyPeriodType - this operation breaks ==
(StatefulPersistenceContext.java [http-8080-5])

And keeps quite when I try anything on Pivot table. I clicked home again
and again got back to Pivot table etc... the same behavior.

One very important note:
The data I use on this database was once built on a CentOS 6.3 server with
Postgres 8.4 and DHIS 2.10. Then I pgdumped the database to this server
with Postgres 9.2 [which has this troubles] on CentOS 6.3. Yesterday after
this frustration I build another server with same CentOS but 8.4 with DHIS
2.12. It works fine!

I would like to have pgsql 9.2.

If necessary I can provide DHIS credentials to you to have a look.

Caveman




On Mon, Jul 29, 2013 at 10:28 AM, Jason Pickering <
jason.p.pickering@xxxxxxxxx> wrote:

> 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
>>
>>
>

Attachment: tomcatlog_20130729.tar.gz
Description: GNU Zip compressed data