dhis2-devs team mailing list archive

[Nguyen Tran Do Xuan Thuy <thuy.hispvietnam@xxxxxxxxx>]

Public bug reported:

Exception occurs when add a section contains data element which is
belong to existing section

- Exception (org.springframework.dao.DataIntegrityViolationException): Could not execute JDBC batch update; SQL [insert into sectiondataelements (sectionid, sort_order, dataelementid) values (?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
Caused by (org.hibernate.exception.ConstraintViolationException): Could not execute JDBC batch update

Caused by (java.sql.BatchUpdateException): Batch entry 5 insert into
sectiondataelements (sectionid, sort_order, dataelementid) values
('95790', '6', '3189') was aborted. Call getNextException to see the
cause.

** Affects: dhis2
     Importance: Undecided
         Status: New

** Description changed:

- Exception occurs when add a section which contain data element which is
+ Exception occurs when add a section contains data element which is
  belong to existing section
  
- - Exception (org.springframework.dao.DataIntegrityViolationException): Could not execute JDBC batch update; SQL [insert into sectiondataelements (sectionid, sort_order, dataelementid) values (?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update 
- Caused by (org.hibernate.exception.ConstraintViolationException): Could not execute JDBC batch update 
+ - Exception (org.springframework.dao.DataIntegrityViolationException): Could not execute JDBC batch update; SQL [insert into sectiondataelements (sectionid, sort_order, dataelementid) values (?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
+ Caused by (org.hibernate.exception.ConstraintViolationException): Could not execute JDBC batch update
  
  Caused by (java.sql.BatchUpdateException): Batch entry 5 insert into
  sectiondataelements (sectionid, sort_order, dataelementid) values
  ('95790', '6', '3189') was aborted. Call getNextException to see the
  cause.

-- 
Exception occur when create new Dataset section
https://bugs.launchpad.net/bugs/642550
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.

Status in DHIS 2 - District Health Information Software: New

Bug description:
Exception occurs when add a section contains data element which is belong to existing section

- Exception (org.springframework.dao.DataIntegrityViolationException): Could not execute JDBC batch update; SQL [insert into sectiondataelements (sectionid, sort_order, dataelementid) values (?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
Caused by (org.hibernate.exception.ConstraintViolationException): Could not execute JDBC batch update

Caused by (java.sql.BatchUpdateException): Batch entry 5 insert into sectiondataelements (sectionid, sort_order, dataelementid) values ('95790', '6', '3189') was aborted. Call getNextException to see the cause.