← Back to team overview

dhis2-users team mailing list archive

Re: [Dhis2-devs] Problem generating resource tables

 

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

References