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) *
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
