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 <knu...@gmail.com> wrote: > 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.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@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ 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
