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) > > >
_______________________________________________ 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