dhis2-users team mailing list archive

[Ilias Dine <ilias.dine@xxxxxxxxx>]

Hi
Did it but still nothing on report.
If this can help figure out what's going on:
- In data administrator -- data browser, when selecting period daily, begin
and end dates covering the entry periods, browse by __organization unit___
then selecting the root organization unit, I can see the values appearing
on the result page
- But when browsing by __data sets__, there is no result
I note also that : when selecting organization unit in browser type, a
contextual select menu for organization units appears; no contextual select
menu for data sets appears when choosing to browse by data set. Is this
normal ?


2013/12/8 Lars Helge Øverland <larshelge@xxxxxxxxx>

> Hi there,
>
> go to data admin, resource tables and generate the resource tables there.
>
> Then run analytics again, and verify that the process completes
> successfully.
>
> The first step happens automatically for scheduled analytics processes,
> but not for ad-hoc. I think we could include a check in the first situation
> and generate them if not existing at all.
>
> Lars
> On Dec 7, 2013 2:47 PM, "Ilias Dine" <ilias.dine@xxxxxxxxx> wrote:
>
>> OK.
>> Here is the result of the query to the database
>>
>> dhis2=> select dataelementid, periodid, sourceid, value from datavalue;
>>
>>  dataelementid | periodid | sourceid | value
>> ---------------+----------+----------+-------
>>             49 |       51 |       48 | 1
>>             49 |       52 |       48 | 2
>>             49 |       53 |       48 | 5
>> (3 rows)
>>
>> The values correspond to what has been set with data entry. But they
>> still don't appear in the dataset report...
>>
>>
>>
>>
>>
>> 2013/12/7 Knut Staring <knutst@xxxxxxxxx>
>>
>>> The data will be in datavalues
>>> 7. des. 2013 14:02 skrev "Ilias Dine" <ilias.dine@xxxxxxxxx> følgende:
>>>
>>> Hi
>>>>
>>>> I'm testing DHIS2, the installation on ubuntu following the guide was
>>>> ok. I then tried to add data elements and visualize them with the
>>>> reports but couldn't get this work. I even tried to add one simple data
>>>> element (named element A, value type: number, aggregation operator: sum
>>>> - as default), then defined a data set (named collect, frequency: daily)
>>>> and associated the data element A to it. An organization unit named root
>>>> has been created and associated to this data set. Through the data entry
>>>> form I added some values for 4 days. I can see them when selecting back
>>>> the periods. But when I go to reports - dataset reports, there is no
>>>> value linked to this data element A...
>>>>
>>>> I tried with several examples, this last one were the simplest, but I
>>>> still can not get any value with the report tools. A look at the
>>>> catalina.out log is showing me this line dealing with my report query:
>>>> "nested exception in org.postgresql.util.PSQLException: ERROR: Relation
>>>> "analytics_2013" doesn't exist"
>>>>
>>>> I've just run Analytics and datasmart -- start exporting, as suggested
>>>> by Knut (thanks to him) but the situation is the same. I shall also mention
>>>> that when doing a reporting rate summary, I'm getting correct rates
>>>> corresponding to the number of data I added.
>>>>
>>>> I'm using version 2.13. Any idea of what is going wrong ? Where can I
>>>> check in the postgresql database (which table to look in?) ?
>>>>
>>>> Thanks for the help.
>>>>
>>>> Regards
>>>> Ilias
>>>>
>>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>