dhis2-users team mailing list archive

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