Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0009363
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 00. Application dictionarytrivialalways2009-06-08 10:082009-06-13 00:00
ReporterAinhoaPagolaView Statuspublic 
Assigned ToAinhoaPagola 
PrioritynormalResolutionfixedFixed in Versionpi
StatusclosedFix in branchpiFixed in SCM revisiond7fc5e28a753
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseAnyJava version1.5
OS VersionUbuntu 8.4Database versionAnt version1.7
Product VersionmainSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009363: 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"
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0009285 closedAinhoaPagola Poor error message when trying to delete current project phase 

-  Notes
(0017114)
AinhoaPagola (reporter)
2009-06-08 18:35

Fix together with bug 0009285
(0017255)
sureshbabu (reporter)
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

- Issue History
Date Modified Username Field Change
2009-06-08 10:08 AinhoaPagola New Issue
2009-06-08 10:08 AinhoaPagola Assigned To => rafaroda
2009-06-08 10:13 AinhoaPagola Relationship added related to 0009285
2009-06-08 10:19 AinhoaPagola Assigned To rafaroda => AinhoaPagola
2009-06-08 10:19 AinhoaPagola Status new => scheduled
2009-06-08 10:19 AinhoaPagola fix_in_branch => pi
2009-06-08 18:35 AinhoaPagola Status scheduled => resolved
2009-06-08 18:35 AinhoaPagola Fixed in SCM revision => d7fc5e28a753e7da72573372c87c62c875e9dac1
2009-06-08 18:35 AinhoaPagola Resolution open => fixed
2009-06-08 18:35 AinhoaPagola Note Added: 0017114
2009-06-12 13:05 sureshbabu Status resolved => closed
2009-06-12 13:05 sureshbabu Note Added: 0017255
2009-06-12 13:05 sureshbabu Fixed in Version => pi
2009-06-13 00:00 anonymous sf_bug_id 0 => 2805712


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker