← Back to team overview

dhis2-devs team mailing list archive

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

 

That is perfectly clear. We will add in a log message to make it more
apparent what is going on in this case.

Lars



On Thu, Feb 6, 2014 at 7:56 PM, Emmanuel Willer CHARLES <
emmanuelwiller@xxxxxxxxx> wrote:

> 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
>

References