← Back to team overview

dhis2-users team mailing list archive

resource table process failed

 

Dear all,
I got this error in console. Could you help me how to fix this problem?

Thank you
Channara

::::::Console::::
> Resource table process failed, please check the logs. Time:
2016-03-30T07:30:17.405+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.GeneratedMethodAccessor903.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.$Proxy104.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.DelegatingErrorHandlingRunnabl
e.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