search cancel

Error Code: 20000 - Unable to delete mapping

book

Article ID: 228849

calendar_today

Updated On:

Products

Endevor Software Change Manager (SCM)

Issue/Introduction

Foreign key constraint violation occurs when deleting a mapping in our Endevor Bridge for Git, the Tomcat server log shows error;

Internal Exception: org.apache.derby.shared.common.error.DerbySQLIntegrityConstraintViolationException: DELETE on table 'BRANCH_SETTINGS' caused a violation of foreign key constraint 'FK_TEMPORARY_ELEMENT_BRANCHSETTINGS_ID' for key (51430).  The statement has been rolled back.                                                                                                                                                                                 
Error Code: 20000                                                               
Call: DELETE FROM branch_settings WHERE ((id = ?) AND (VERSION = ?)) 

 

 

Cause

The foreign key constraint violation occurs when deleting a mapping with temporary elements present.
This has been detected with Endevor Bridge for Git version 2.8.*.

Environment

Release : 2.8.*

Component : ENDEVOR BRIDGE FOR GIT

Resolution

ENDEVOR BRIDGE FOR GIT version 2.9.0 allows to delete mappings without issues.
Apply solution # LU03109 - Endevor Bridge for Git 2.9.0