https://bugs.launchpad.net/dhis2/+bug/1603179
On Thu, Jul 14, 2016 at 8:08 PM, Knut Staring <knu...@gmail.com> 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 <knu...@gmail.com> 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 <knu...@gmail.com> 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
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp