← Back to team overview

dhis2-devs team mailing list archive

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

 

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
>

Follow ups

References