dhis2-users team mailing list archive

[Wilfred Senyoni <senyoni@xxxxxxxxx>]

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.DataSetOrganisationUnitCategor
>>>> yResourceTable.getPopulateTempTableContent(
>>>> DataSetOrganisationUnitCategoryResourceTable.java:96)
>>>>
>>>> at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.
>>>> generateResourceTable(JdbcResourceTableStore.java:77)
>>>>
>>>> at org.hisp.dhis.resourcetable.DefaultResourceTableService.
>>>> generateDataSetOrganisationUnitCategoryTable(
>>>> DefaultResourceTableService.java:145)
>>>>
>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>>
>>>> at sun.reflect.NativeMethodAccessorImpl.invoke(
>>>> NativeMethodAccessorImpl.java:62)
>>>>
>>>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(
>>>> DelegatingMethodAccessorImpl.java:43)
>>>>
>>>> at java.lang.reflect.Method.invoke(Method.java:498)
>>>>
>>>> at org.springframework.aop.support.AopUtils.
>>>> invokeJoinpointUsingReflection(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.
>>>> TransactionInterceptor$1.proceedWithInvocation(
>>>> TransactionInterceptor.java:99)
>>>>
>>>> at org.springframework.transaction.interceptor.
>>>> TransactionAspectSupport.invokeWithinTransaction(
>>>> TransactionAspectSupport.java:281)
>>>>
>>>> at org.springframework.transaction.interceptor.
>>>> TransactionInterceptor.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.
>>>> generateAll(ResourceTableTask.java:115)
>>>>
>>>> at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.
>>>> run(ResourceTableTask.java:84)
>>>>
>>>> at org.springframework.scheduling.support.
>>>> DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnabl
>>>> e.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$
>>>> ScheduledFutureTask.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
>
>