← Back to team overview

dhis2-devs team mailing list archive

Re: Error generating resource table - (_categoryoptioncomboname)

 

Thanks Lars,

Got the offending option. Will be good if the data integrity checks can pick
this up since if can affect the resource tables.

 

 

………………………………………………………………..

Regards

 

Dapo Adejumo

+2348033683677

Skype : dapojorge

 

From: Lars Helge Øverland [mailto:larshelge@xxxxxxxxx] 
Sent: Tuesday, July 2, 2013 1:58 PM
To: Dapo Adejumo
Cc: DHIS 2 developers
Subject: Re: [Dhis2-devs] Error generating resource table -
(_categoryoptioncomboname)

 

Hi Dapo,

 

this must be a problem related to the categories/category options in your
database, ie. a data integrity issue like a category without options or
similar. It is hard to make a diagnosis without seeing the database. I
usually use these SQL integrity checks to reveal the problem. Ideally, none
of these SQLs should return any rows:

 

 

-- Get category option combos without category options

 

select * from categoryoptioncombo where categoryoptioncomboid not in (select
distinct categoryoptioncomboid from categoryoptioncombos_categoryoptions);

 

-- Get category option combos without category combo

 

select * from categoryoptioncombo where categoryoptioncomboid not in (select
distinct categoryoptioncomboid from categorycombos_optioncombos);

 

-- Get category options without category option combos

 

select * from dataelementcategoryoption where categoryoptionid not in
(select distinct categoryoptionid from
categoryoptioncombos_categoryoptions);

 

-- Get catetegory options without categories

 

select * from dataelementcategoryoption where categoryoptionid not in
(select distinct categoryoptionid from categories_categoryoptions);

 

-- Get categories without category options

 

select * from dataelementcategory where categoryid not in (select distinct
categoryid from categories_categoryoptions);

 

-- Get categories without category combos (not an error but could be
removed)

 

select * from dataelementcategory where categoryid not in (select distinct
categoryid from categorycombos_categories);

 

-- Get category combos without categories

 

select * from categorycombo where categorycomboid not in (select distinct
categorycomboid from categorycombos_categories);

 

 

 

 

regards,

 

Lars

 

 

On Tue, Jul 2, 2013 at 5:16 AM, Dapo Adejumo <dapo_adejumo@xxxxxxxxx> wrote:

Hello,

This error keeps coming up while trying to generate one of the resource
tables (_categoryoptioncomboname) . Other tables are generated without
issues. Below is the relevant log -

 

* ERROR 2013-07-02 04:08:35,285 Error while executing action
(ExceptionInterceptor.java [http-bio-127.0.0.1-8080-exec-8])

java.lang.ArrayIndexOutOfBoundsException: 0

        at
org.hisp.dhis.common.CombinationGenerator.getCurrent(CombinationGenerator.ja
va:121)

        at
org.hisp.dhis.common.CombinationGenerator.getNext(CombinationGenerator.java:
97)

        at
org.hisp.dhis.dataelement.DataElementCategoryCombo.getSortedOptionCombos(Dat
aElementCategoryCombo.java:170)

        at
org.hisp.dhis.resourcetable.DefaultResourceTableService.generateCategoryOpti
onComboNames(DefaultResourceTableService.java:241)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57
)

        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:43)

        at java.lang.reflect.Method.invoke(Method.java:601)

        at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopU
tils.java:317)

        at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint
(ReflectiveMethodInvocation.java:183)

        at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflect
iveMethodInvocation.java:150)

        at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(Tr
ansactionInterceptor.java:110)

        at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflect
iveMethodInvocation.java:172)

        at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopPro
xy.java:204)

        at $Proxy106.generateCategoryOptionComboNames(Unknown Source)

        at
org.hisp.dhis.dataadmin.action.resourcetable.GenerateResourceTableAction.exe
cute(GenerateResourceTableAction.java:176)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57
)

        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:43)

        at java.lang.reflect.Method.invoke(Method.java:601)

 

 

Any Ideas?

Thanks

 

 

………………………………………………………………..

Regards

 

Dapo Adejumo

+2348033683677

Skype : dapojorge

 


_______________________________________________
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

 


Follow ups

References