dhis2-devs team mailing list archive

["jason.p.pickering" <jason.p.pickering@xxxxxxxxx>]

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