Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009363Openbravo ERP00. Application dictionarypublic2009-06-08 10:082009-06-13 00:00
ReporterAinhoaPagola 
Assigned ToAinhoaPagola 
PrioritynormalSeveritytrivialReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 8.4
Product Versionmain 
Target VersionFixed in Versionpi 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009363: Foreing key violated: Contraint not registeted in AD_Message
DescriptionDeleting a record from Salary Category window displays an error:

update or delete on table "c_bpartner" violates foreign key constraint "c_bp_salcategory_c_bpartner" on table "c_bp_salcategory"
Detail: Key (c_bpartner_id)=(706766F2E88640B4B10A4494A126EA28) is still referenced from table "c_bp_salcategory

This happens because the contraint is not registered in AD_Message.

c_bp_salcategory_c_bpartner constraint in c_bp_salcategory table.
Steps To Reproduce* Create a new salary category. Fill Cost tab.
* Create a business partner and in the employee tab, select this salary category.
* Try to delete the employee.
Proposed SolutionAdd this constraint to AD_message. The msgtext should be: "This record cannot be deleted because it is associated with other existing elements. Please see Linked Items"
Additional Information
TagsNo tags attached.
Relationships
related to defect 0009285 closed AinhoaPagola Poor error message when trying to delete current project phase 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-06-08 10:08AinhoaPagolaNew Issue
2009-06-08 10:08AinhoaPagolaAssigned To => rafaroda
2009-06-08 10:08AinhoaPagolaOBNetwork customer => No
2009-06-08 10:13AinhoaPagolaRelationship addedrelated to 0009285
2009-06-08 10:19AinhoaPagolaAssigned Torafaroda => AinhoaPagola
2009-06-08 10:19AinhoaPagolaStatusnew => scheduled
2009-06-08 10:19AinhoaPagolafix_in_branch => pi
2009-06-08 18:35AinhoaPagolaStatusscheduled => resolved
2009-06-08 18:35AinhoaPagolaFixed in SCM revision => d7fc5e28a753e7da72573372c87c62c875e9dac1
2009-06-08 18:35AinhoaPagolaResolutionopen => fixed
2009-06-08 18:35AinhoaPagolaNote Added: 0017114
2009-06-12 13:05sureshbabuStatusresolved => closed
2009-06-12 13:05sureshbabuNote Added: 0017255
2009-06-12 13:05sureshbabuFixed in Version => pi
2009-06-13 00:00anonymoussf_bug_id0 => 2805712

Notes
(0017114)
AinhoaPagola   
2009-06-08 18:35   
Fix together with bug 0009285
(0017255)
sureshbabu   
2009-06-12 13:05   
Message "This record cannot be deleted because it is associated with other existing elements. Please see Linked Items" rightly appears if we try to delete the Employee which is associated with an Salary category