← Back to team overview

dhis2-devs team mailing list archive

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

 

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
>

Follow ups

References