dhis2-devs team mailing list archive

[Bjørnar Valbø <744125@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Cannot delete beneficiary attribute because they're associated with
patients:


* INFO  10:25:56,474 Deleted objects associatied with object of type PatientAttribute (DefaultDeletionManager.java [http-8080-1])
* WARN  10:25:56,483 SQL Error: 0, SQLState: 23503 (JDBCExceptionReporter.java [http-8080-1])
* ERROR 10:25:56,485 Batch entry 0 delete from patientattribute where patientattributeid='21021' was aborted.  Call 

getNextException to see the cause. (JDBCExceptionReporter.java [http-8080-1])
* WARN  10:25:56,486 SQL Error: 0, SQLState: 23503 (JDBCExceptionReporter.java [http-8080-1])
* ERROR 10:25:56,488 ERROR: update or delete on table "patientattribute" violates foreign key constraint 

"fk_patient_patientattributeid" on table "patient_attributes"
  Detail: Key (patientattributeid)=(21021) is still referenced from table "patient_attributes". (JDBCExceptionReporter.java [http-

8080-1])
* ERROR 10:25:56,490 Could not synchronize database state with session (AbstractFlushingEventListener.java [http-8080-1])
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

** Affects: dhis2
     Importance: Undecided
         Status: New

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

Title:
  Beneficiary attributes cannot be deleted

Status in DHIS 2 - District Health Information Software:
  New

Bug description:
  Cannot delete beneficiary attribute because they're associated with
  patients:

  
  * INFO  10:25:56,474 Deleted objects associatied with object of type PatientAttribute (DefaultDeletionManager.java [http-8080-1])
  * WARN  10:25:56,483 SQL Error: 0, SQLState: 23503 (JDBCExceptionReporter.java [http-8080-1])
  * ERROR 10:25:56,485 Batch entry 0 delete from patientattribute where patientattributeid='21021' was aborted.  Call 

  getNextException to see the cause. (JDBCExceptionReporter.java [http-8080-1])
  * WARN  10:25:56,486 SQL Error: 0, SQLState: 23503 (JDBCExceptionReporter.java [http-8080-1])
  * ERROR 10:25:56,488 ERROR: update or delete on table "patientattribute" violates foreign key constraint 

  "fk_patient_patientattributeid" on table "patient_attributes"
    Detail: Key (patientattributeid)=(21021) is still referenced from table "patient_attributes". (JDBCExceptionReporter.java [http-

  8080-1])
  * ERROR 10:25:56,490 Could not synchronize database state with session (AbstractFlushingEventListener.java [http-8080-1])
  org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update