Problem generating resource tables

Support - Assistance technique
1

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