dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #12877
[Bug 762941] Re: scheduled-datamart-fails-with-unique-period-constaint
** Changed in: dhis2
Milestone: 2.3 => 2.4
--
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
To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/762941/+subscriptions
References