dhis2-users team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

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.DataSetOrganisationUnitCategoryResourceTable.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(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$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