Hi, When we upgrade our application to 2.24 this is also an issue for us. We are creating DataSets via the WebAPI and have never previously set a categoryCombo to the new DataSet. Will you be setting the default categoryCombo if one is not supplied as part of this bug fix?
https://bugs.launchpad.net/dhis2/+bug/1603179 Thanks, Lorill On Tue, Aug 23, 2016 at 10:59 AM, Wilfred Senyoni <seny...@gmail.com> wrote: > 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.DataSetOrganisationUnitCat >>>>> egoryResourceTable.getPopulateTempTableContent(DataSetOrgani >>>>> sationUnitCategoryResourceTable.java:96) >>>>> >>>>> at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.gene >>>>> rateResourceTable(JdbcResourceTableStore.java:77) >>>>> >>>>> at org.hisp.dhis.resourcetable.DefaultResourceTableService.gene >>>>> rateDataSetOrganisationUnitCategoryTable(DefaultResourceTabl >>>>> eService.java:145) >>>>> >>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>>>> >>>>> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce >>>>> ssorImpl.java:62) >>>>> >>>>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe >>>>> thodAccessorImpl.java:43) >>>>> >>>>> at java.lang.reflect.Method.invoke(Method.java:498) >>>>> >>>>> at org.springframework.aop.support.AopUtils.invokeJoinpointUsin >>>>> gReflection(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.TransactionInter >>>>> ceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) >>>>> >>>>> at org.springframework.transaction.interceptor.TransactionAspec >>>>> tSupport.invokeWithinTransaction(TransactionAspectSupport.java:281) >>>>> >>>>> at org.springframework.transaction.interceptor.TransactionInter >>>>> ceptor.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.gen >>>>> erateAll(ResourceTableTask.java:115) >>>>> >>>>> at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run >>>>> (ResourceTableTask.java:84) >>>>> >>>>> at org.springframework.scheduling.support.DelegatingErrorHandli >>>>> ngRunnable.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$ScheduledFu >>>>> tureTask.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 > > -- Lorill Crees Project Leader / Senior Developer 2Paths Solutions Ltd. <http://www.2paths.com> lcr...@2paths.com skype: lorill2paths (604) 689-4123 x 15
_______________________________________________ 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