dhis2-devs team mailing list archive

Thread
Date
[Bug 729072] Re: data-mart-exports-fail-with-too-many-operands

To: dhis2-devs@xxxxxxxxxxxxxxxxxxx
From: Lars Helge Øverland <larshelge@xxxxxxxxx>
Date: Sun, 13 Mar 2011 05:07:22 -0000
Reply-to: Bug 729072 <729072@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
This is a known bug:)

** Changed in: dhis2
     Assignee: (unassigned) => Lars Helge Øverland (larshelge)

** Changed in: dhis2
    Milestone: None => 2.2

** Changed in: dhis2
       Status: New => Confirmed

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/729072

Title:
  data-mart-exports-fail-with-too-many-operands

Status in DHIS 2 - District Health Information Software:
  Confirmed

Bug description:
  * INFO  14:25:09,625 Internal process started (AbstractStatementInternalProcess.java [Thread-17])
  * INFO  14:25:57,511 Filtered data elements, number of operands: 3150, 0:00:46.637 (DefaultDataMartEngine.java [Thread-17])
  * INFO  14:32:09,853 Number of operands with data: 2904, 0:06:58.982 (DefaultDataMartEngine.java [Thread-17])
  * INFO  14:36:05,070 Populated crosstab table for key: zs3MjJZL (DefaultCrossTabService.java [Thread-17])
  * INFO  14:38:47,843 Populated crosstab table for key: CWZd1CCz (DefaultCrossTabService.java [Thread-17])
  * INFO  14:38:47,847 Number of crosstab tables: 2, 0:13:36.976 (DefaultDataMartEngine.java [Thread-17])
  * INFO  14:38:47,865 Dropped potential indexes: 0:13:36.995 (DefaultDataMartEngine.java [Thread-17])
  * INFO  14:38:48,392 Deleted existing aggregated data: 0:13:37.522 (DefaultDataMartEngine.java [Thread-17])
  * ERROR 14:38:51,556 Internal process failed (AbstractStatementInternalProcess.java [Thread-17])
  java.lang.RuntimeException: Failed to get CrossTabDataValues
          at org.hisp.dhis.datamart.crosstab.jdbc.JDBCCrossTabStore.getCrossTabDataValues(JDBCCrossTabStore.java:169)
          at org.hisp.dhis.datamart.crosstab.DefaultCrossTabService.getCrossTabDataValues(DefaultCrossTabService.java:173)
          at org.hisp.dhis.datamart.aggregation.dataelement.SumIntAggregator.getAggregatedValues(SumIntAggregator.java:92)
          at org.hisp.dhis.datamart.dataelement.DefaultDataElementDataMart.exportDataValues(DefaultDataElementDataMart.java:107)
          at org.hisp.dhis.datamart.engine.DefaultDataMartEngine.export(DefaultDataMartEngine.java:302)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          at java.lang.reflect.Method.invoke(Method.java:616)
          at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
          at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
          at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
          at $Proxy42.export(Unknown Source)
          at org.hisp.dhis.datamart.impl.DefaultDataMartService.export(DefaultDataMartService.java:95)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          at java.lang.reflect.Method.invoke(Method.java:616)
          at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
          at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
          at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:80)
          at org.hisp.dhis.jdbc.StatementInterceptor.intercept(StatementInterceptor.java:65)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          at java.lang.reflect.Method.invoke(Method.java:616)
          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:65)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
          at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
          at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
          at $Proxy43.export(Unknown Source)
          at org.hisp.dhis.datamart.DataMartInternalProcess.executeStatements(DataMartInternalProcess.java:108)
          at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:91)
          at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:40)
          at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:125)
          at java.lang.Thread.run(Thread.java:636)
  Caused by: org.postgresql.util.PSQLException: ERROR: target lists can have at most 1664 entries
          at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
          at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
          at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
          at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
          at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
          at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
          at org.hisp.dhis.datamart.crosstab.jdbc.JDBCCrossTabStore.getCrossTabDataValues(JDBCCrossTabStore.java:163)
          ... 44 more
  java.lang.RuntimeException: Failed to get CrossTabDataValues
          at org.hisp.dhis.datamart.crosstab.jdbc.JDBCCrossTabStore.getCrossTabDataValues(JDBCCrossTabStore.java:169)
          at org.hisp.dhis.datamart.crosstab.DefaultCrossTabService.getCrossTabDataValues(DefaultCrossTabService.java:173)
          at org.hisp.dhis.datamart.aggregation.dataelement.SumIntAggregator.getAggregatedValues(SumIntAggregator.java:92)
          at org.hisp.dhis.datamart.dataelement.DefaultDataElementDataMart.exportDataValues(DefaultDataElementDataMart.java:107)
          at org.hisp.dhis.datamart.engine.DefaultDataMartEngine.export(DefaultDataMartEngine.java:302)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          at java.lang.reflect.Method.invoke(Method.java:616)
          at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
          at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
          at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
          at $Proxy42.export(Unknown Source)
          at org.hisp.dhis.datamart.impl.DefaultDataMartService.export(DefaultDataMartService.java:95)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          at java.lang.reflect.Method.invoke(Method.java:616)
          at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
          at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
          at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:80)
          at org.hisp.dhis.jdbc.StatementInterceptor.intercept(StatementInterceptor.java:65)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          at java.lang.reflect.Method.invoke(Method.java:616)
          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:65)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
          at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
          at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
          at $Proxy43.export(Unknown Source)
          at org.hisp.dhis.datamart.DataMartInternalProcess.executeStatements(DataMartInternalProcess.java:108)
          at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:91)
          at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:40)
          at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:125)
          at java.lang.Thread.run(Thread.java:636)
  Caused by: org.postgresql.util.PSQLException: ERROR: target lists can have at most 1664 entries
          at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
          at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
          at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
          at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
          at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
          at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
          at org.hisp.dhis.datamart.crosstab.jdbc.JDBCCrossTabStore.getCrossTabDataValues(JDBCCrossTabStore.java:163)
          ... 44 more
References

[Bug 729072] [NEW] data-mart-exports-fail-with-too-many-operands
From: jason.p.pickering, 2011-03-04