← Back to team overview

dhis2-devs team mailing list archive

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

 

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