← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] Error Generating Event Reports

 

Thanx Knut,

That seems to solve the problem [?]

On Mon, Jan 26, 2015 at 11:23 PM, Knut Staring <knutst@xxxxxxxxx> wrote:

> Please rename Level2 and Level3, just to be sure the labels are actually
> stored in the db.
> On 26 Jan 2015 17:45, "Pamod Amarakoon" <pamodm@xxxxxxxxx> wrote:
>
>> Hi Olav,
>>
>> 0. It's national, level2 and level 3
>>
>>
>>
>> 1. Yes, can generate resource tables without any errors
>>
>>
>> 2. Didn't see any errors during generation of analytic tables
>>
>>
>>
>>
>>
>> After following above I tried to display the results in the usual way in
>> Event Reports and still I get that "No values found" error.
>>
>> Thank you
>>
>> On Mon, Jan 26, 2015 at 3:33 PM, Ola Hodne Titlestad <olati@xxxxxxxxxx>
>> wrote:
>>
>>> Hi Pamod,
>>>
>>> 0) Do you have any values/names for the various Orgunit levels? Please
>>> open and save this page:
>>>
>>> https://apps.dhis2.org/demo/dhis-web-maintenance-organisationunit/organisationUnitLevel.action
>>>
>>> 1) Are you able to generate resource tables without any errors?
>>>
>>> https://apps.dhis2.org/demo/dhis-web-maintenance-dataadmin/displayResourceTableForm.action
>>>
>>> 2) Any errors during generation of analytics tables?
>>> https://apps.dhis2.org/demo/dhis-web-reporting/displayDataMartForm.action
>>>
>>> Just replace my URLs with correct ones for your DHIS 2 instance.
>>>
>>> Ola
>>> --------
>>>
>>>
>>>
>>> ----------------------------------
>>> Ola Hodne Titlestad (Mr)
>>> HISP
>>> Department of Informatics
>>> University of Oslo
>>>
>>> Mobile: +47 48069736
>>> Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
>>> <https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norge&hl=en&ie=UTF8&sll=59.893855,10.785116&sspn=0.222842,0.585709&oq=eftas%C3%A5sen+68,+0687+Oslo,+&t=h&hnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norway&z=16>
>>>
>>> On 23 January 2015 at 18:51, Pamod Amarakoon <pamodm@xxxxxxxxx> wrote:
>>>
>>>> Dear All,
>>>>
>>>> I have an instance of DHIS2 version 2.16, which is primarily used for
>>>> tracker related data on Single event with registration. The issue is after
>>>> generating analytic tables and view results on Event Reports I receive "No
>>>> data found" on both aggregated data as well as individual records. I tested
>>>> it on 2.17 and 2.18, but same error persists.
>>>>
>>>> I checked the catalina.out and it puts out several errors related to
>>>> "uidlevels". Same appear for uidlevel3. In analytic table only uidlevel1 is
>>>> there, which is also empty. Following is the exact error.
>>>>
>>>> column "uidlevel2" does not exist....
>>>>
>>>> The relevant portion of catalina.out is attached herewith. I'd be
>>>> grateful if you could help me fix this.
>>>>
>>>> Thank you
>>>> --
>>>> Pamod
>>>>
>>>>
>>>> _______________________________________________
>>>> 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
>>>>
>>>>
>>>
>>
>>
>> --
>> Pamod
>>
>>
>> _______________________________________________
>> 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
>>
>>


-- 
Pamod

PNG image

PNG image

PNG image

PNG image

PNG image

PNG image

GIF image


Follow ups

References