Hi We added a relationship type which was added to a program. But now we need to delete it. But when we try to do so nothing happens except the progress bar keeps moving. Here is the stack trace from my local instance:
*INFO 2015-05-21 12:56:04,619 'admin' delete org.hisp.dhis.relationship.RelationshipType, name: Eq/Mo, uid: K7kjkslt5w7 (AuditLogUtil.java [http-bio-8090-exec-9])* ** WARN 2015-05-21 12:56:04,655 SQL Error: 0, SQLState: 23503 (SqlExceptionHelper.java [http-bio-8090-exec-9])* ** ERROR 2015-05-21 12:56:04,656 ERROR: update or delete on table "relationshiptype" violates foreign key constraint "fk_program_relationshipid" on table "program"* * Detail: Key (relationshiptypeid)=(355) is still referenced from table "program". (SqlExceptionHelper.java [http-bio-8090-exec-9])* ** ERROR 2015-05-21 12:56:04,766 Error while executing action (ExceptionInterceptor.java [http-bio-8090-exec-9])* *org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [fk_program_relationshipid]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement* * at org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:163)* * at org.springframework.orm.hibernate4.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:730)* * at org.springframework.orm.hibernate4.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:592)* * at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:757)* *.* *.* *.* *.* In view of the above error we have tried to delete the relationship from the program (by editing it) but it seems that there is no way in which this can be done.Please confirm. Any help is appreciated. Regards
_______________________________________________ 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
