dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #35346
Re: [Dhis2-users] Error Generating Event Reports
Great
On 26 Jan 2015 19:15, "Pamod Amarakoon" <pamodm@xxxxxxxxx> wrote:
> 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
>
>
Follow ups
References