Re: [Dhis2-devs] Problem generating resource tables
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 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 wrote: > >> https://bugs.launchpad.net/dhis2/+bug/1603179 >> >> On Thu, Jul 14, 2016 at 8:08 PM, Knut Staring 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 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 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.fra
Re: [Dhis2-devs] Problem generating resource tables
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 wrote: > https://bugs.launchpad.net/dhis2/+bug/1603179 > > On Thu, Jul 14, 2016 at 8:08 PM, Knut Staring 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 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 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.springfram
Re: [Dhis2-devs] Problem generating resource tables
https://bugs.launchpad.net/dhis2/+bug/1603179 On Thu, Jul 14, 2016 at 8:08 PM, Knut Staring 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 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 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(Delegat
Re: [Dhis2-devs] Problem generating resource tables
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 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 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.ScheduledThreadPoolE
Re: [Dhis2-devs] Problem generating resource tables
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 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 ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.lau
Re: [Dhis2-devs] Problem generating resource tables because of "invalid byte sequence"
No, nothing about encoding in hibernate.properties - you mean it should be there? # PostgreSQL # testing hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect hibernate.connection.driver_class = org.postgresql.Driver hibernate.connection.url = jdbc:postgresql:... hibernate.connection.username = ... hibernate.connection.password = ... hibernate.hbm2ddl.auto = update Olav 18. sep. 2012 kl. 12:50 skrev Jason Pickering : > What does your hibernate.properties file look like? Do you have something like > > &characterEncoding=UTF-8 ? > > Postgres attempts to keep invalid characters out of the system, and > this character is a Hangul (Korean) symbol apparently which Postgres > feels is invalid.I assume you do not need to support Korean? > > > > > On Tue, Sep 18, 2012 at 9:54 AM, Olav wrote: >> >> It's UTF-8. >> >> Encoding | Collation |Ctype| Access privileges >> --+-+-+--- >> UTF8 | en_US.UTF-8 | en_US.UTF-8 | >> >> Olav >> >> >> 18. sep. 2012 kl. 07:25 skrev Jason Pickering : >> >> What is the encoding for your database? UTF8 or ANSI? >> >> Regards, >> Jason >> >> >> On Mon, Sep 17, 2012 at 5:24 PM, Olav wrote: >>> >>> Hi, >>> generating resource tables for dataelements and dataelementgroups fails. >>> "org.postgresql.util.PSQLException: ERROR: invalid byte sequence for >>> encoding "UTF8": 0xd06d" >>> >>> Tried to look for strange characters in the dataelementgroup or >>> dataelementgroupsets, but only found () and - (which should be fine?). Any >>> advice on fixing this? What do I look for? >>> >>> Thanks >>> Olav >>> >>> >>> * INFO 2012-09-17 14:31:33,291 Create data element group set table SQL: >>> CREATE TABLE _dataelementgroupsetstructure ( dataelementid INTEGER NOT >>> NULL, dataelementname VARCHAR (250), clinical_services VARCHAR (250), >>> disease_control VARCHAR (250), family_health_and_nutrition VARCHAR (250), >>> hiv_aids_control VARCHAR (250), malaria_control VARCHAR (250), >>> other_services VARCHAR (250), patientbased_data_elements VARCHAR (250), >>> PRIMARY KEY ( dataelementid ) ) >>> (CreateDataElementGroupSetTableStatement.java [http-8080-3]) >>> * ERROR 2012-09-17 14:31:33,523 Error while executing action >>> (ExceptionInterceptor.java [http-8080-3]) >>> java.lang.RuntimeException: Failed to flush BatchHandler >>>at >>> org.amplecode.quick.batchhandler.AbstractBatchHandler.flush(AbstractBatchHandler.java:311) >>>at >>> org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDataElementGroupSetTable(DefaultResourceTableService.java:242) >>>at >>> org.hisp.dhis.dataadmin.action.resourcetable.GenerateResourceTableAction.execute(GenerateResourceTableAction.java:135) >>>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>>at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >>>at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >>>at java.lang.reflect.Method.invoke(Method.java:597) >>>at >>> com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:453) >>>at >>> com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:292) >>>at >>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:255) >>>at >>> org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87) >>>at >>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) >>>at >>> org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90) >>>at >>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) >>>at >>> org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96) >>>at >>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) >>>at >>> org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:118) >>>at >>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) >>>at >>> org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:81) >>>at >>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) >>>at >>> org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:80) >>>at >>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) >>>at >>> org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84) >>>at >>> com.opensymphony.xwork2.DefaultActionInvo
Re: [Dhis2-devs] Problem generating resource tables because of "invalid byte sequence"
What does your hibernate.properties file look like? Do you have something like &characterEncoding=UTF-8 ? Postgres attempts to keep invalid characters out of the system, and this character is a Hangul (Korean) symbol apparently which Postgres feels is invalid.I assume you do not need to support Korean? On Tue, Sep 18, 2012 at 9:54 AM, Olav wrote: > > It's UTF-8. > > Encoding | Collation |Ctype| Access privileges > --+-+-+--- > UTF8 | en_US.UTF-8 | en_US.UTF-8 | > > Olav > > > 18. sep. 2012 kl. 07:25 skrev Jason Pickering : > > What is the encoding for your database? UTF8 or ANSI? > > Regards, > Jason > > > On Mon, Sep 17, 2012 at 5:24 PM, Olav wrote: >> >> Hi, >> generating resource tables for dataelements and dataelementgroups fails. >> "org.postgresql.util.PSQLException: ERROR: invalid byte sequence for >> encoding "UTF8": 0xd06d" >> >> Tried to look for strange characters in the dataelementgroup or >> dataelementgroupsets, but only found () and - (which should be fine?). Any >> advice on fixing this? What do I look for? >> >> Thanks >> Olav >> >> >> * INFO 2012-09-17 14:31:33,291 Create data element group set table SQL: >> CREATE TABLE _dataelementgroupsetstructure ( dataelementid INTEGER NOT NULL, >> dataelementname VARCHAR (250), clinical_services VARCHAR (250), >> disease_control VARCHAR (250), family_health_and_nutrition VARCHAR (250), >> hiv_aids_control VARCHAR (250), malaria_control VARCHAR (250), >> other_services VARCHAR (250), patientbased_data_elements VARCHAR (250), >> PRIMARY KEY ( dataelementid ) ) >> (CreateDataElementGroupSetTableStatement.java [http-8080-3]) >> * ERROR 2012-09-17 14:31:33,523 Error while executing action >> (ExceptionInterceptor.java [http-8080-3]) >> java.lang.RuntimeException: Failed to flush BatchHandler >> at >> org.amplecode.quick.batchhandler.AbstractBatchHandler.flush(AbstractBatchHandler.java:311) >> at >> org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDataElementGroupSetTable(DefaultResourceTableService.java:242) >> at >> org.hisp.dhis.dataadmin.action.resourcetable.GenerateResourceTableAction.execute(GenerateResourceTableAction.java:135) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >> at java.lang.reflect.Method.invoke(Method.java:597) >> at >> com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:453) >> at >> com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:292) >> at >> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:255) >> at >> org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87) >> at >> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) >> at >> org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90) >> at >> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) >> at >> org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96) >> at >> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) >> at >> org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:118) >> at >> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) >> at >> org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:81) >> at >> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) >> at >> org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:80) >> at >> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) >> at >> org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84) >> at >> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) >> at >> org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:103) >> at >> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) >> at >> org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:88) >> at >> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) >> at >> org.hisp.dhis.intercept
Re: [Dhis2-devs] Problem generating resource tables because of "invalid byte sequence"
It's UTF-8. Encoding | Collation |Ctype| Access privileges --+-+-+--- UTF8 | en_US.UTF-8 | en_US.UTF-8 | Olav 18. sep. 2012 kl. 07:25 skrev Jason Pickering : > What is the encoding for your database? UTF8 or ANSI? > > Regards, > Jason > > > On Mon, Sep 17, 2012 at 5:24 PM, Olav wrote: > Hi, > generating resource tables for dataelements and dataelementgroups fails. > "org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding > "UTF8": 0xd06d" > > Tried to look for strange characters in the dataelementgroup or > dataelementgroupsets, but only found () and - (which should be fine?). Any > advice on fixing this? What do I look for? > > Thanks > Olav > > > * INFO 2012-09-17 14:31:33,291 Create data element group set table SQL: > CREATE TABLE _dataelementgroupsetstructure ( dataelementid INTEGER NOT NULL, > dataelementname VARCHAR (250), clinical_services VARCHAR (250), > disease_control VARCHAR (250), family_health_and_nutrition VARCHAR (250), > hiv_aids_control VARCHAR (250), malaria_control VARCHAR (250), other_services > VARCHAR (250), patientbased_data_elements VARCHAR (250), PRIMARY KEY ( > dataelementid ) ) (CreateDataElementGroupSetTableStatement.java [http-8080-3]) > * ERROR 2012-09-17 14:31:33,523 Error while executing action > (ExceptionInterceptor.java [http-8080-3]) > java.lang.RuntimeException: Failed to flush BatchHandler > at > org.amplecode.quick.batchhandler.AbstractBatchHandler.flush(AbstractBatchHandler.java:311) > at > org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDataElementGroupSetTable(DefaultResourceTableService.java:242) > at > org.hisp.dhis.dataadmin.action.resourcetable.GenerateResourceTableAction.execute(GenerateResourceTableAction.java:135) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at > com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:453) > at > com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:292) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:255) > at > org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) > at > org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) > at > org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) > at > org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:118) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) > at > org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:81) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) > at > org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:80) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) > at > org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) > at > org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:103) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) > at > org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:88) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) > at > org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:137) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) > at > com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:211) > at > com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) > at > com.opensymphony.xwork2.DefaultAction
Re: [Dhis2-devs] Problem generating resource tables because of "invalid byte sequence"
What is the encoding for your database? UTF8 or ANSI? Regards, Jason On Mon, Sep 17, 2012 at 5:24 PM, Olav wrote: > Hi, > generating resource tables for dataelements and dataelementgroups fails. > "org.postgresql.util.PSQLException: ERROR: invalid byte sequence for > encoding "UTF8": 0xd06d" > > Tried to look for strange characters in the dataelementgroup or > dataelementgroupsets, but only found () and - (which should be fine?). Any > advice on fixing this? What do I look for? > > Thanks > Olav > > > * INFO 2012-09-17 14:31:33,291 Create data element group set table SQL: > CREATE TABLE _dataelementgroupsetstructure ( dataelementid INTEGER NOT > NULL, dataelementname VARCHAR (250), clinical_services VARCHAR (250), > disease_control VARCHAR (250), family_health_and_nutrition VARCHAR (250), > hiv_aids_control VARCHAR (250), malaria_control VARCHAR (250), > other_services VARCHAR (250), patientbased_data_elements VARCHAR (250), > PRIMARY KEY ( dataelementid ) ) > (CreateDataElementGroupSetTableStatement.java [http-8080-3]) > * ERROR 2012-09-17 14:31:33,523 Error while executing action > (ExceptionInterceptor.java [http-8080-3]) > java.lang.RuntimeException: Failed to flush BatchHandler > at > org.amplecode.quick.batchhandler.AbstractBatchHandler.flush(AbstractBatchHandler.java:311) > at > org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDataElementGroupSetTable(DefaultResourceTableService.java:242) > at > org.hisp.dhis.dataadmin.action.resourcetable.GenerateResourceTableAction.execute(GenerateResourceTableAction.java:135) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at > com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:453) > at > com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:292) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:255) > at > org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) > at > org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) > at > org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) > at > org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:118) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) > at > org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:81) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) > at > org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:80) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) > at > org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) > at > org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:103) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) > at > org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:88) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) > at > org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:137) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) > at > com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:211) > at > com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) > at > com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) > a