← Back to team overview

dhis2-devs team mailing list archive

Re: Problem with Analytic Reports (Vizualizer and pivot table)

 

we created a category combination A which depends on two categories x;y,
where x and y had category options, then we deleted the options that were
in y in category options management. so y category became void (without
options). to solve the problem, we simply deleted the category y.

i hope the explanation is clear.


On Thu, Feb 6, 2014 at 11:31 AM, Lars Helge Øverland <larshelge@xxxxxxxxx>wrote:

> Hi,
>
> could you please tell us if it was the first (option combos) or second
> problem (missing options) that caused it? We could make a check for this to
> prevent it happening.
>
> Lars
>
>
>
> On Thu, Feb 6, 2014 at 5:21 PM, Emmanuel Willer CHARLES <
> emmanuelwiller@xxxxxxxxx> wrote:
>
>> Hi all,
>>
>> you were all right, it was a problem with category and category
>> combination thank you all.
>> now that the problem is solve i can take the time to tackle another
>> issue. that you all are going to be in copy.
>>
>>
>> On Thu, Feb 6, 2014 at 2:18 AM, Lars Helge Øverland <larshelge@xxxxxxxxx>wrote:
>>
>>> Hi Emmanuel,
>>>
>>> first try to go to data administration >  maintenance > generate
>>> category option combos and go. Then try running analytics again.
>>>
>>> If that does not help, please chech whether you have any categories
>>> without any category options. If so remove them.
>>>
>>> Let us know how it goes.
>>>
>>> regards,
>>>
>>> Lars
>>> On Feb 5, 2014 11:13 PM, "Knut Staring" <knutst@xxxxxxxxx> wrote:
>>>
>>>> .My guess is a problem with your categoryoptioncombos, but again,
>>>> whenever there is an error, please share the (same) log file. Perhaps
>>>> someone has time to have a look at your db, though if you don't have much
>>>> in it yet, it could be advisable to start a fresh (just create a new empty
>>>> db and point to that one in hibernate.properties)
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On Wed, Feb 5, 2014 at 10:47 PM, Emmanuel Willer CHARLES <
>>>> emmanuelwiller@xxxxxxxxx> wrote:
>>>>
>>>>> it is surely for test.
>>>>>
>>>>> i tried to run resource table
>>>>>  i have the attached error message.
>>>>>
>>>>>
>>>>>
>>>>> On Wed, Feb 5, 2014 at 2:19 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
>>>>>
>>>>>> I think the relevant file is tomcat7-stdout.2014-02-05.log. I see you
>>>>>> are running on Windows 7, is that just for testing on your laptop or is it
>>>>>> meant to be a server?
>>>>>>
>>>>>> Below is the last part of the log, which seems to show a problem with
>>>>>> categories. Others should have more insight on this, but you could try
>>>>>> going to Maintenance -> Data Administration -> Resource Table and click on
>>>>>> Generate Table.
>>>>>>
>>>>>> -------------------------------
>>>>>> * INFO  2014-02-05 15:03:10,491 Version: 3.5.3 (Service.java
>>>>>> [taskScheduler-1])
>>>>>> * INFO  2014-02-05 15:03:10,491 JRE Version: 1.7.0_40 (Service.java
>>>>>> [taskScheduler-1])
>>>>>> * INFO  2014-02-05 15:03:10,491 JRE Impl Version: 24.0-b56
>>>>>> (Service.java [taskScheduler-1])
>>>>>> * INFO  2014-02-05 15:03:10,491 O/S: Windows 7 / amd64 / 6.1
>>>>>> (Service.java [taskScheduler-1])
>>>>>> * ERROR 2014-02-05 15:03:10,501 Unexpected error occurred in
>>>>>> scheduled task. (TaskUtils.java [taskScheduler-1])
>>>>>> java.lang.ArrayIndexOutOfBoundsException: 0
>>>>>> at
>>>>>> org.hisp.dhis.common.CombinationGenerator.getCurrent(CombinationGenerator.java:124)
>>>>>> at
>>>>>> org.hisp.dhis.common.CombinationGenerator.getNext(CombinationGenerator.java:98)
>>>>>>  at
>>>>>> org.hisp.dhis.dataelement.DataElementCategoryCombo.getSortedOptionCombos(DataElementCategoryCombo.java:171)
>>>>>> at
>>>>>> org.hisp.dhis.resourcetable.DefaultResourceTableService.generateCategoryOptionComboNames(DefaultResourceTableService.java:206)
>>>>>>  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>>>> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
>>>>>>  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>>>>>> at java.lang.reflect.Method.invoke(Unknown Source)
>>>>>>
>>>>>>
>>>>>> On Wed, Feb 5, 2014 at 9:05 PM, Emmanuel Willer CHARLES <
>>>>>> emmanuelwiller@xxxxxxxxx> wrote:
>>>>>>
>>>>>>> ok. i send all files found in the logs folder.
>>>>>>>
>>>>>>>
>>>>>>> On Wed, Feb 5, 2014 at 1:34 PM, Knut Staring <knutst@xxxxxxxxx>wrote:
>>>>>>>
>>>>>>>> Fine. But the most important is your Tomcat log file.
>>>>>>>>
>>>>>>>> Sent from my mobile
>>>>>>>> On 5 Feb 2014 20:33, "Emmanuel Willer CHARLES" <
>>>>>>>> emmanuelwiller@xxxxxxxxx> wrote:
>>>>>>>>
>>>>>>>>> Hi Knut,
>>>>>>>>>
>>>>>>>>> here are the requested information.
>>>>>>>>>
>>>>>>>>> version 2.13
>>>>>>>>> build number: 12941.
>>>>>>>>>
>>>>>>>>> thanks
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Wed, Feb 5, 2014 at 1:31 PM, Knut Staring <knutst@xxxxxxxxx>wrote:
>>>>>>>>>
>>>>>>>>>> Hi Emmanuel, pls let us know the version and build number, and
>>>>>>>>>> share your log file.
>>>>>>>>>>
>>>>>>>>>> Sent from my mobile
>>>>>>>>>> On 5 Feb 2014 17:43, "Emmanuel Willer CHARLES" <
>>>>>>>>>> emmanuelwiller@xxxxxxxxx> wrote:
>>>>>>>>>>
>>>>>>>>>>> Hello Guys
>>>>>>>>>>>  I think I need a little help out there. everything is set up,
>>>>>>>>>>> and I completed few forms in data entry for some months and org units, when
>>>>>>>>>>> running dataset reports, we can see the data is stored.
>>>>>>>>>>>
>>>>>>>>>>> scheduling is started, when I run analytic reports it takes a
>>>>>>>>>>> while in showing the working/progress bar, but doesn't give the complete
>>>>>>>>>>> status, and when i try to pull up data in the pivot table it doesn't show
>>>>>>>>>>> values (no value found).
>>>>>>>>>>> --
>>>>>>>>>>> ___________________________________
>>>>>>>>>>> Charles Emmanuel Willer
>>>>>>>>>>> 12,Lilavois 50 Croix des Bouquets, HT
>>>>>>>>>>> Tels:  +509-3842-3854 / +509-3270-0655
>>>>>>>>>>> Skype: emmanuelwiller
>>>>>>>>>>> emmanuelwiller@xxxxxxxxx
>>>>>>>>>>> emmanuelwiller@xxxxxxxxx
>>>>>>>>>>>
>>>>>>>>>>> _______________________________________________
>>>>>>>>>>> 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
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> ___________________________________
>>>>>>>>> Charles Emmanuel Willer
>>>>>>>>> 12,Lilavois 50 Croix des Bouquets, HT
>>>>>>>>> Tels:  +509-3842-3854 / +509-3270-0655
>>>>>>>>> Skype: emmanuelwiller
>>>>>>>>> emmanuelwiller@xxxxxxxxx
>>>>>>>>> emmanuelwiller@xxxxxxxxx
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> ___________________________________
>>>>>>> Charles Emmanuel Willer
>>>>>>> 12,Lilavois 50 Croix des Bouquets, HT
>>>>>>> Tels:  +509-3842-3854 / +509-3270-0655
>>>>>>> Skype: emmanuelwiller
>>>>>>> emmanuelwiller@xxxxxxxxx
>>>>>>> emmanuelwiller@xxxxxxxxx
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Knut Staring
>>>>>> Dept. of Informatics, University of Oslo
>>>>>> +4791880522
>>>>>> http://dhis2.org
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> ___________________________________
>>>>> Charles Emmanuel Willer
>>>>> 12,Lilavois 50 Croix des Bouquets, HT
>>>>> Tels:  +509-3842-3854 / +509-3270-0655
>>>>> Skype: emmanuelwiller
>>>>> emmanuelwiller@xxxxxxxxx
>>>>> emmanuelwiller@xxxxxxxxx
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Knut Staring
>>>> Dept. of Informatics, University of Oslo
>>>> +4791880522
>>>> http://dhis2.org
>>>>
>>>
>>
>>
>> --
>> ___________________________________
>> Charles Emmanuel Willer
>> 12,Lilavois 50 Croix des Bouquets, HT
>> Tels:  +509-3842-3854 / +509-3270-0655
>> Skype: emmanuelwiller
>> emmanuelwiller@xxxxxxxxx
>> emmanuelwiller@xxxxxxxxx
>>
>
>


-- 
___________________________________
Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels:  +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@xxxxxxxxx
emmanuelwiller@xxxxxxxxx

Follow ups

References