← Back to team overview

dhis2-devs team mailing list archive

[Bug 762941] Re: scheduled-datamart-fails-with-unique-period-constaint

 

** Changed in: dhis2
    Milestone: 2.2 => 2.3

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/762941

Title:
  scheduled-datamart-fails-with-unique-period-constaint

Status in DHIS 2 - District Health Information Software:
  New

Bug description:
  * INFO  17:10:46,894 Created index (AbstractDataSetCompletenessService.java [taskScheduler-2])
  * INFO  17:10:46,895 Completeness export process done (AbstractDataSetCompletenessService.java [taskScheduler-2])
  * WARN  17:10:46,943 SQL Error: 0, SQLState: 23505 (JDBCExceptionReporter.java [taskScheduler-1])
  * ERROR 17:10:46,944 Batch entry 0 insert into period (periodtypeid, startdate, enddate, periodid) values ('3', '2011-03-01 +00:00:00', '2011-03-31 +00:00:00', '40542') was aborted.  Call getNextException to see the cause. (JDBCExceptionReporter.java [taskScheduler-1])
  * WARN  17:10:46,944 SQL Error: 0, SQLState: 23505 (JDBCExceptionReporter.java [taskScheduler-1])
  * ERROR 17:10:46,945 ERROR: duplicate key value violates unique constraint "period_periodtypeid_key" (JDBCExceptionReporter.java [taskScheduler-1])
  * ERROR 17:10:46,946 Could not synchronize database state with session (AbstractFlushingEventListener.java [taskScheduler-1])
  org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
  	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
  	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
  	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
  	at org.hibernate.engine.ActionQueue.executeActions(Ac


References