← Back to team overview

dhis2-users team mailing list archive

Resource Table error

 

Dear friend,
when i run analytic, i always got error like below. how to fix this problem?

==========================================
Resource table process failed
Resource table process failed, please check the logs. Time:
2016-04-07T21:45:16.145+07:00. Message: PreparedStatementCallback; SQL
[insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR:
duplicate key value violates unique constraint "_dateperiodstructure_pkey"
Detail: Key (dateperiod)=(1975-01-01) already exists.; nested exception is
org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "_dateperiodstructure_pkey"
Detail: Key (dateperiod)=(1975-01-01) already exists. Cause:
org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "_dateperiodstructure_pkey"
Detail: Key (dateperiod)=(1975-01-01) already exists.

at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)

at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)

at
org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1130)

at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:396)

at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2892)

at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)

at
org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005)

at
org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:989)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673)

at
org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989)

at
org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(BatchUpdateUtils.java:32)

at
org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1039)

at
org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034)

at
org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(JdbcResourceTableStore.java:101)

at
org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDatePeriodTable(DefaultResourceTableService.java:456)

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

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

at java.lang.reflect.Method.invoke(Unknown Source)

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

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

at com.sun.proxy.$Proxy262.generateDatePeriodTable(Unknown Source)

at
org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)

at
org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:85)

at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)

at
org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)

at
org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown
Source)

at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown
Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Follow ups