Hi Pramil, do you think you could upgrade your instance to a recent DHIS 2 version? That way it is easier for us to help you. We usually support the three last releases.
https://www.dhis2.org/downloads regard, Lars On Mon, Apr 25, 2016 at 3:39 PM, Pramil Liyanage <[email protected]> wrote: > Hi all, > > I am getting this error when trying to run the datamart in 2.19. (Database > postgres) > > 2016-04-25 13:11:27Process failed: java.sql.SQLSyntaxErrorException: > object name already exists: DEYVNZPZ39W2Y_P79KWQPTZRR > > > 2016-04-25 13:11:26 > > > Populating crosstabulation table > > What could be the reason? The second part of the object is a category > option combo. Below is the log. > > Regards > Pramil > > > * INFO 2016-04-25 18:40:07,553 Using periods: [[Quarterly: Fri Apr 01 > 00:00:00 IST 2016 - Thu Jun 30 00:00:00 IST 2016]] (DataMartTask.java > [taskScheduler-1]) > * ERROR 2016-04-25 18:40:07,718 Initialised statement manager > (StatementInterceptor.java [taskScheduler-1]) > * ERROR 2016-04-25 18:40:08,232 Initialised statement manager > (StatementInterceptor.java [taskScheduler-1]) > * INFO 2016-04-25 18:40:08,351 Data mart export process started, number > of CPU cores: 4, Mem Total in JVM: 4959 Free in JVM: 3514 Max Limit: 6667: > 00:00:00.000 (Clock.java [taskScheduler-1]) > * INFO 2016-04-25 18:40:08,351 [Level: INFO, category: DATAMART, time: > Mon Apr 25 18:40:08 IST 2016, message: Data mart export process started] > (InMemoryNotifier.java [taskScheduler-1]) > * INFO 2016-04-25 18:40:08,440 Recreated temporary tables: 00:00:00.089 > (Clock.java [taskScheduler-1]) > * INFO 2016-04-25 18:40:08,441 Data elements: 89, indicators: 182, > periods: 1, org units: 453: 00:00:00.090 (Clock.java [taskScheduler-1]) > * INFO 2016-04-25 18:40:08,552 Retrieved meta-data objects, using > periods: [[Quarterly: 2016-04-01 - 2016-06-30]]: 00:00:00.201 (Clock.java > [taskScheduler-1]) > * INFO 2016-04-25 18:40:08,552 [Level: INFO, category: DATAMART, time: > Mon Apr 25 18:40:08 IST 2016, message: Filtering meta-data] > (InMemoryNotifier.java [taskScheduler-1]) > * INFO 2016-04-25 18:40:43,798 Filtered objects: 00:00:35.447 (Clock.java > [taskScheduler-1]) > * INFO 2016-04-25 18:40:43,860 [Level: INFO, category: DATAMART, time: > Mon Apr 25 18:40:43 IST 2016, message: Loading indicators] > (InMemoryNotifier.java [taskScheduler-1]) > * INFO 2016-04-25 18:40:43,947 Exploded indicator expressions: > 00:00:35.596 (Clock.java [taskScheduler-1]) > * INFO 2016-04-25 18:40:43,947 [Level: INFO, category: DATAMART, time: > Mon Apr 25 18:40:43 IST 2016, message: Loading data elements] > (InMemoryNotifier.java [taskScheduler-1]) > * INFO 2016-04-25 18:41:24,111 Retrieved operands: 1002: 00:01:15.760 > (Clock.java [taskScheduler-1]) > * INFO 2016-04-25 18:41:24,299 [Level: INFO, category: DATAMART, time: > Mon Apr 25 18:41:24 IST 2016, message: Loading periods] > (InMemoryNotifier.java [taskScheduler-1]) > * INFO 2016-04-25 18:41:24,904 Number of periods: 1: 00:01:16.553 > (Clock.java [taskScheduler-1]) > * INFO 2016-04-25 18:41:24,905 [Level: INFO, category: DATAMART, time: > Mon Apr 25 18:41:24 IST 2016, message: Filtering data elements without > data] (InMemoryNotifier.java [taskScheduler-1]) > * INFO 2016-04-25 18:41:26,062 Number of operands with data: 97, Mem > Total in JVM: 4944 Free in JVM: 3350 Max Limit: 6667: 00:01:17.711 > (Clock.java [taskScheduler-1]) > * INFO 2016-04-25 18:41:26,062 [Level: INFO, category: DATAMART, time: > Mon Apr 25 18:41:26 IST 2016, message: Populating crosstabulation table] > (InMemoryNotifier.java [taskScheduler-1]) > * INFO 2016-04-25 18:41:27,117 Crosstab table columns: 99, rows: 0 > (DefaultCrossTabService.java [SimpleAsyncTaskExecutor-18]) > * INFO 2016-04-25 18:41:27,118 Crosstab table columns: 99, rows: 0 > (DefaultCrossTabService.java [SimpleAsyncTaskExecutor-21]) > * INFO 2016-04-25 18:41:27,149 Crosstab table columns: 99, rows: 0 > (DefaultCrossTabService.java [SimpleAsyncTaskExecutor-19]) > * INFO 2016-04-25 18:41:27,166 Crosstab table columns: 99, rows: 0 > (DefaultCrossTabService.java [SimpleAsyncTaskExecutor-20]) > * INFO 2016-04-25 18:41:27,166 Populated crosstab table, Mem Total in > JVM: 4944 Free in JVM: 3333 Max Limit: 6667: 00:01:18.815 (Clock.java > [taskScheduler-1]) > * INFO 2016-04-25 18:41:27,284 [Level: ERROR, category: DATAMART, time: > Mon Apr 25 18:41:27 IST 2016, message: Process failed: > java.sql.SQLSyntaxErrorException: object name already exists: > DEYVNZPZ39W2Y_P79KWQPTZRR] (InMemoryNotifier.java [taskScheduler-1]) > * INFO 2016-04-25 18:41:27,716 SMSLib: A Java API library for sending and > receiving SMS via a GSM modem or other supported gateways. > This software is distributed under the terms of the Apache v2.0 License. > Web Site: http://smslib.org (Service.java [taskScheduler-1]) > * INFO 2016-04-25 18:41:27,717 Version: 3.5.3 (Service.java > [taskScheduler-1]) > * INFO 2016-04-25 18:41:27,717 JRE Version: 1.8.0_77 (Service.java > [taskScheduler-1]) > * INFO 2016-04-25 18:41:27,717 JRE Impl Version: 25.77-b03 (Service.java > [taskScheduler-1]) > * INFO 2016-04-25 18:41:27,717 O/S: Linux / amd64 / 3.13.0-85-generic > (Service.java [taskScheduler-1]) > * ERROR 2016-04-25 18:41:27,956 Unexpected error occurred in scheduled > task. (TaskUtils.java [taskScheduler-1]) > java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: object name > already exists: DEYVNZPZ39W2Y_P79KWQPTZRR > at > org.amplecode.quick.statement.DefaultStatementHolder.executeUpdate(DefaultStatementHolder.java:96) > at > org.amplecode.quick.statement.DefaultStatementHolder.executeUpdate(DefaultStatementHolder.java:80) > at > org.hisp.dhis.datamart.crosstab.jdbc.JDBCCrossTabStore.createAggregatedDataCache(JDBCCrossTabStore.java:106) > at > org.hisp.dhis.datamart.crosstab.DefaultCrossTabService.createAggregatedDataCache(DefaultCrossTabService.java:196) > 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:317) > at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201) > at com.sun.proxy.$Proxy119.createAggregatedDataCache(Unknown Source) > at > org.hisp.dhis.datamart.engine.DefaultDataMartEngine.export(DefaultDataMartEngine.java:343) > at > org.hisp.dhis.datamart.engine.DefaultDataMartEngine.export(DefaultDataMartEngine.java:205) > 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:317) > 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.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85) > at > org.amplecode.quick.StatementInterceptor.intercept(StatementInterceptor.java:71) > 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.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621) > at > org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610) > at > org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) > at > org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) > at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) > at com.sun.proxy.$Proxy122.export(Unknown Source) > at org.hisp.dhis.scheduling.DataMartTask.run(DataMartTask.java:112) > at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60) > 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.access$201(ScheduledThreadPoolExecutor.java:180) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > Caused by: java.sql.SQLSyntaxErrorException: object name already exists: > DEYVNZPZ39W2Y_P79KWQPTZRR > at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) > at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) > at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) > at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) > at > org.amplecode.quick.statement.DefaultStatementHolder.executeUpdate(DefaultStatementHolder.java:87) > ... 47 more > Caused by: org.hsqldb.HsqlException: object name already exists: > DEYVNZPZ39W2Y_P79KWQPTZRR > at org.hsqldb.error.Error.error(Unknown Source) > at org.hsqldb.error.Error.error(Unknown Source) > at org.hsqldb.Table.addColumn(Unknown Source) > at org.hsqldb.ParserDDL.compileCreateTableBody(Unknown Source) > at org.hsqldb.ParserDDL.compileCreateTable(Unknown Source) > at org.hsqldb.ParserDDL.compileCreate(Unknown Source) > at org.hsqldb.ParserCommand.compilePart(Unknown Source) > at org.hsqldb.ParserCommand.compileStatements(Unknown Source) > at org.hsqldb.Session.executeDirectStatement(Unknown Source) > at org.hsqldb.Session.execute(Unknown Source) > ... 50 more > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- Lars Helge Øverland Lead developer, DHIS 2 University of Oslo Skype: larshelgeoverland http://www.dhis2.org <https://www.dhis2.org/>
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
