dhis2-users team mailing list archive

[Lorill Crees <lcrees@xxxxxxxxxx>]

Hi,

When we upgrade our application to 2.24 this is also an issue for us. We
are creating DataSets via the WebAPI and have never previously set a
categoryCombo to the new DataSet. Will you be setting the default
categoryCombo if one is not supplied as part of this bug fix?

https://bugs.launchpad.net/dhis2/+bug/1603179

Thanks,

Lorill

On Tue, Aug 23, 2016 at 10:59 AM, Wilfred Senyoni <senyoni@xxxxxxxxx> wrote:

> Hi developers
> I have experienced the same issue while creating a fresh database with
> version 2.24 build revision: 23511.
> Just to add on the new dataset interface you can create a new dataset
> without a assigning a datasaet category combination while using the old
> interface you are forced to choose one.
>
> Cheers
>
> Wilfred Senyoni
> Information Systems Researcher
> Skype: senyoni
> Mob: (+255) 0713595231/(+47) 46573133
>
> On Thu, Jul 14, 2016 at 9:25 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
>
>> https://bugs.launchpad.net/dhis2/+bug/1603179
>>
>> On Thu, Jul 14, 2016 at 8:08 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
>>
>>> Ok, so I have tracked this down to a missing (NULL) value for
>>> categorycomboid in the dataset table. It should have been filled with the
>>> default value (15). I will file a bug report.
>>>
>>>
>>>
>>> On Thu, Jul 14, 2016 at 2:12 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
>>>
>>>> So I started again with a blank db, first just adding a few orgunits
>>>> and levels, and a couple of data elements. Generating resources tables then
>>>> is fine.
>>>>
>>>> The error below happens as soon as I create a dataset. Any clues as to
>>>> why?
>>>>
>>>> Knut
>>>>
>>>> On Thu, Jul 14, 2016 at 11:16 AM, Knut Staring <knutst@xxxxxxxxx>
>>>> wrote:
>>>>
>>>>> Hi there,
>>>>>
>>>>> I am building a 2.24 database from scratch/empty, and have so far just
>>>>> added a couple of OU and DE into a DataSet and entered a few values.
>>>>>
>>>>> Now when I try to generate the resource tables, I get the following.
>>>>> Any clues?
>>>>>
>>>>> * INFO  2016-07-14 11:13:38,901 [Level: INFO, category:
>>>>> RESOURCETABLE_UPDATE, time: Thu Jul 14 11:13:38 CEST 2016, message:
>>>>> Generating resource tables] (InMemoryNotifier.java [taskScheduler-3])
>>>>>
>>>>> * INFO  2016-07-14 11:13:38,912 Create table SQL: create table
>>>>> _orgunitstructure_temp (organisationunitid integer not null primary key,
>>>>> organisationunituid character(11), level integer, "idlevel1" integer,
>>>>> "uidlevel1" character(11), "idlevel2" integer, "uidlevel2" character(11));
>>>>> (JdbcResourceTableStore.java [taskScheduler-3])
>>>>>
>>>>> * INFO  2016-07-14 11:13:38,920 Populate table content rows: 3
>>>>> (JdbcResourceTableStore.java [taskScheduler-3])
>>>>>
>>>>> * INFO  2016-07-14 11:13:38,923 Create index SQL: create unique index
>>>>> in_orgunitstructure_organisationunituid_k8awu on
>>>>> _orgunitstructure_temp(organisationunituid)
>>>>> (JdbcResourceTableStore.java [taskScheduler-3])
>>>>>
>>>>> * INFO  2016-07-14 11:13:38,929 Swapped resource table, done:
>>>>> _orgunitstructure in: 00:00:00.025 (JdbcResourceTableStore.java
>>>>> [taskScheduler-3])
>>>>>
>>>>> * INFO  2016-07-14 11:13:38,932 [Level: ERROR, category:
>>>>> RESOURCETABLE_UPDATE, time: Thu Jul 14 11:13:38 CEST 2016, message: Process
>>>>> failed: null] (InMemoryNotifier.java [taskScheduler-3])
>>>>>
>>>>> * INFO  2016-07-14 11:13:38,932 'system-process' create
>>>>> org.hisp.dhis.message.MessageConversation, name: Resource table
>>>>> process failed, uid: BvFty94jh6y (AuditLogUtil.java [taskScheduler-3])
>>>>>
>>>>> * INFO  2016-07-14 11:13:38,933 Message failed:
>>>>> (SmsMessageSender.java [taskScheduler-3])
>>>>>
>>>>> * INFO  2016-07-14 11:13:38,933 Failure cause: no gateway is set to
>>>>> default (SmsMessageSender.java [taskScheduler-3])
>>>>>
>>>>> * ERROR 2016-07-14 11:13:38,941 Unexpected error occurred in scheduled
>>>>> task. (TaskUtils.java [taskScheduler-3])
>>>>>
>>>>> java.lang.NullPointerException
>>>>>
>>>>> at org.hisp.dhis.resourcetable.table.DataSetOrganisationUnitCat
>>>>> egoryResourceTable.getPopulateTempTableContent(DataSetOrgani
>>>>> sationUnitCategoryResourceTable.java:96)
>>>>>
>>>>> at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.gene
>>>>> rateResourceTable(JdbcResourceTableStore.java:77)
>>>>>
>>>>> at org.hisp.dhis.resourcetable.DefaultResourceTableService.gene
>>>>> rateDataSetOrganisationUnitCategoryTable(DefaultResourceTabl
>>>>> eService.java:145)
>>>>>
>>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>>>
>>>>> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
>>>>> ssorImpl.java:62)
>>>>>
>>>>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
>>>>> thodAccessorImpl.java:43)
>>>>>
>>>>> at java.lang.reflect.Method.invoke(Method.java:498)
>>>>>
>>>>> at org.springframework.aop.support.AopUtils.invokeJoinpointUsin
>>>>> gReflection(AopUtils.java:302)
>>>>>
>>>>> at org.springframework.aop.framework.ReflectiveMethodInvocation
>>>>> .invokeJoinpoint(ReflectiveMethodInvocation.java:190)
>>>>>
>>>>> at org.springframework.aop.framework.ReflectiveMethodInvocation
>>>>> .proceed(ReflectiveMethodInvocation.java:157)
>>>>>
>>>>> at org.springframework.transaction.interceptor.TransactionInter
>>>>> ceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
>>>>>
>>>>> at org.springframework.transaction.interceptor.TransactionAspec
>>>>> tSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
>>>>>
>>>>> at org.springframework.transaction.interceptor.TransactionInter
>>>>> ceptor.invoke(TransactionInterceptor.java:96)
>>>>>
>>>>> at org.springframework.aop.framework.ReflectiveMethodInvocation
>>>>> .proceed(ReflectiveMethodInvocation.java:179)
>>>>>
>>>>> at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(
>>>>> JdkDynamicAopProxy.java:208)
>>>>>
>>>>> at com.sun.proxy.$Proxy76.generateDataSetOrganisationUnitCategoryTable(Unknown
>>>>> Source)
>>>>>
>>>>> at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.gen
>>>>> erateAll(ResourceTableTask.java:115)
>>>>>
>>>>> at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run
>>>>> (ResourceTableTask.java:84)
>>>>>
>>>>> at org.springframework.scheduling.support.DelegatingErrorHandli
>>>>> ngRunnable.run(DelegatingErrorHandlingRunnable.java:54)
>>>>>
>>>>> at java.util.concurrent.Executors$RunnableAdapter.call(
>>>>> Executors.java:511)
>>>>>
>>>>> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
>>>>>
>>>>> at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFu
>>>>> tureTask.ac
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Knut Staring
>>>> Dept. of Informatics, University of Oslo
>>>> Norway: +4791880522
>>>> Skype: knutstar
>>>> http://dhis2.org
>>>>
>>>
>>>
>>>
>>> --
>>> Knut Staring
>>> Dept. of Informatics, University of Oslo
>>> Norway: +4791880522
>>> Skype: knutstar
>>> http://dhis2.org
>>>
>>
>>
>>
>> --
>> Knut Staring
>> Dept. of Informatics, University of Oslo
>> Norway: +4791880522
>> Skype: knutstar
>> http://dhis2.org
>>
>> _______________________________________________
>> 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
>>
>>
>
> _______________________________________________
> 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
>
>


-- 
Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd. <http://www.2paths.com>

lcrees@xxxxxxxxxx
skype: lorill2paths
(604) 689-4123 x 15