dhis2-users team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

Thanks.

The results show there are:
22 category options without category option combos
16 catetegory options without categories
1 category without category options

and
5 categories without category combos (not an error but could be removed)

I started by trying to delete the one  category without category options,
but that also produced an error:
 ERROR 16:04:13,935 Error while executing action (ExceptionInterceptor.java
[32181168@qtp-6718343-4])
org.springframework.dao.DataIntegrityViolationException: could not execute
statement; SQL [n/a]; constraint [fk_categorycombo_categoryid]; nested
exception is org.hibernate.exception.ConstraintViolationException: could
not execute statement
 at
org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:138)





On Thu, Jul 18, 2013 at 3:52 PM, Lars Helge Øverland <larshelge@xxxxxxxxx>wrote:

> Run SQL queries in attached file to check integrity of the category model.
> Look for category options without any categories. Let us know so we can
> make the code robust against these kind of anomalies.
>
> Lars
>
>
>
>
>
>
>
> On Thu, Jul 18, 2013 at 3:38 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
>
>> I'm experiencing some issues with a database: When I try to create a new
>> indicator and click on either Edit numerator or Edit denominator, no Data
>> Elements show up in the pop-up window.
>>
>> The log seems to indicate an issue with Categorycombos - but how to find
>> out what the issue might be?
>>
>>
>> * ERROR 15:33:43,426 Error while executing action
>> (ExceptionInterceptor.java [25299772@qtp-24670213-4])
>> java.lang.ArrayIndexOutOfBoundsException: 0
>> at
>> org.hisp.dhis.common.CombinationGenerator.getCurrent(CombinationGenerator.java:123)
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org