dhis2-devs team mailing list archive

[Lorill Crees <lcrees@xxxxxxxxxx>]

Hi,

When running analytics on one of our instances, we get the error "Process
failed: Analytics table dimensions contain duplicates: ["oZXosvGYth6"]".
The full stack is pasted below.

How can I fix this? I took a quick look through a couple tables to see if I
could find this UID but no success, and wasn't sure where I should be
looking.

We are on 2.22 R 22089.

Thanks!

Lorill


* ERROR 2016-08-08 16:48:12,556 Unexpected error occurred in scheduled
task. (TaskUtils.java [taskScheduler-4])

java.lang.IllegalStateException: Analytics table dimensions contain
duplicates: ["oZXosvGYth6"]

at
org.hisp.dhis.analytics.table.AbstractJdbcTableManager.validateDimensionColumns(AbstractJdbcTableManager.java:323)

at
org.hisp.dhis.analytics.table.JdbcEventAnalyticsTableManager.createTable(JdbcEventAnalyticsTableManager.java:145)

at sun.reflect.GeneratedMethodAccessor935.invoke(Unknown Source)

at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:483)

at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)

at com.sun.proxy.$Proxy146.createTable(Unknown Source)

at
org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.createTables(DefaultAnalyticsTableService.java:193)

at
org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAnalyticsTableService.java:124)

at
org.hisp.dhis.analytics.table.scheduling.AnalyticsTableTask.call(AnalyticsTableTask.java:158)

at
org.hisp.dhis.security.NoSecurityContextRunnable.run(NoSecurityContextRunnable.java:47)

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)

*