This seems to be only the case when there are no data elements selected for export.
** Summary changed: - Data mart exports are broken + Data mart exports fail when there are no data elements selected for export -- Data mart exports fail when there are no data elements selected for export https://bugs.launchpad.net/bugs/527066 You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. Status in DHIS 2 - District Health Information Software: New Bug description: * INFO 15:41:06,526 Export process started (DefaultDataMartEngine.java [Thread-20]) * INFO 15:41:06,536 Deleted existing aggregated data: 0:00:00.003 (DefaultDataMartEngine.java [Thread-20]) * INFO 15:41:07,027 Filtered data elements (DefaultDataMartEngine.java [Thread-20]) * INFO 15:41:07,027 Validated crosstab table: 0:00:00.496 (DefaultDataMartEngine.java [Thread-20]) * WARN 15:41:08,660 No operands selected for crosstab table (DefaultCrossTabService.java [Thread-20]) * INFO 15:41:08,661 Populated crosstab table: 0:00:02.130 (DefaultDataMartEngine.java [Thread-20]) * ERROR 15:41:08,664 The process threw exception (ProcessExecutor.java [Thread-20]) java.lang.RuntimeException: Failed to get crosstab table columns at org.hisp.dhis.datamart.crosstab.jdbc.JDBCCrossTabStore.createTrimmedCrossTabTable(JDBCCrossTabStore.java:220) at org.hisp.dhis.datamart.crosstab.DefaultCrossTabService.trimCrossTabTable(DefaultCrossTabService.java:180) at org.hisp.dhis.datamart.engine.DefaultDataMartEngine.export(DefaultDataMartEngine.java:250) 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 org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy33.export(Unknown Source) at org.hisp.dhis.datamart.DataMartInternalProcess.executeStatements(DataMartInternalProcess.java:125) at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:79) at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:37) at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:125) at java.lang.Thread.run(Thread.java:619) Caused by: org.postgresql.util.PSQLException: ERROR: relation "datavaluecrosstab" does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:299) at org.hisp.dhis.datamart.crosstab.jdbc.JDBCCrossTabStore.createTrimmedCrossTabTable(JDBCCrossTabStore.java:216) ... 18 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
