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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0012078
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 02. Master data managementminoralways2010-01-27 16:102010-10-14 00:00
ReportermgerkeView Statuspublic 
Assigned Toharikrishnan 
PrioritynormalResolutionfixedFixed in Version2.50MP23
StatusclosedFix in branchFixed in SCM revisionecd5a5db58bd
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product Version2.50SCM revisionMP 9 
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
Summary

0012078: Business partner could not be deleted because of a constraint

DescriptionBusiness partner could not be deleted because of a constraint, if there is a Contact (=> Contact Tab) defined.

Openbravo error message is:
"This record cannot be deleted because it is associated with other existing elements. Please see Linked Items"

Tomcat log (translated from german):
Update or delete in table »c_bpartner« violates
foreign key constraint »cbpartner_aduser« on table »ad_user«
Detail: There is a reference on (c_bpartner_id)=(3A6DE4E9A61D4EC398C8B5B78D14BA90) from table »ad_user«

If other information like "bank account" is defined, business partners could be deleted.

Steps To Reproducenew business partner
new contact

delete business partner
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0014766 closedharikrishnan try-api 191 fails with a warning 

-  Notes
(0023835)
mtaal (viewer)
2010-01-27 16:56

 Hi Mgerke,
Question, is there a specific reason that you report this issue on the multiple business partner selector module. That module only allows selecting business partner but not removing them.

In which part of the Openbravo application did you encounter this issue?

gr. Martin
(0023918)
mgerke (viewer)
2010-02-03 10:11

 Hi Martin, this is because I must do a selection of a category and I don't have other choices (more suitable) in the list of categories. If I had, I would choose "Business Partner Dialog".
(0023919)
mtaal (viewer)
2010-02-03 10:18

 Hi Rafa,
Can you assign it to someone who can answer/take care of this issue?

gr. Martin
(0024416)
rafaroda (viewer)
2010-02-16 15:31

 Moved to project Openbravo ERP > Category: Master Data Management and re-assigned to Adrián.
(0030208)
Jan De Bruyne - Abboss (viewer)
2010-08-21 14:40

 The same error
"This record cannot be deleted because it is associated with other existing elements. Please see Linked Items"
appears in MP20 while importing business partners (using Import File Loader).
No idea why Openbravo tries to delete records while it should import from CSV.
(0030214)
shuehner (administrator)
2010-08-23 09:40

 @Jan:
The same error message is shown in all foreign key violations, independent of inser/updated/delete. As when building the message we don't have the info which action it is.

Please open a new defect for the problem.
(0030428)
Jan De Bruyne - Abboss (viewer)
2010-08-29 15:53

 @shuehner:
Done (Issue 0014358).
(0031727)
hgbot (developer)
2010-10-11 08:27

 Repository: erp/devel/pi
Changeset: ecd5a5db58bd257cad9e08034a5e10fb0459eb44
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Mon Oct 11 11:56:52 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/ecd5a5db58bd257cad9e08034a5e10fb0459eb44 [^]

Fixes Issue 12078: Business partner could not be deleted because of a constraint

---
M src-db/database/model/tables/AD_USER.xml
---
(0031729)
harikrishnan (viewer)
2010-10-11 08:31

 Steps to test:
* Create a business partner with contact details and try to delete the business partner.Now the business partner can be deleted.

Root cause:

*Before Ondelete=cascade attribute is not used in the constraint.

Impact:
*API will be fail due to this fix.
(0031764)
hudsonbot (viewer)
2010-10-11 15:18

 A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/ecd5a5db58bd [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/f03dfdd6ea87 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18509.obx [^]
(0031819)
psarobe (viewer)
2010-10-13 17:18

 Tested working fine

- Issue History
Date Modified Username Field Change
2010-01-27 16:10 mgerke New Issue
2010-01-27 16:10 mgerke Assigned To => mtaal
2010-01-27 16:56 mtaal Note Added: 0023835
2010-01-27 16:56 mtaal Status new => feedback
2010-02-03 10:11 mgerke Note Added: 0023918
2010-02-03 10:18 mtaal Assigned To mtaal => rafaroda
2010-02-03 10:18 mtaal Note Added: 0023919
2010-02-16 15:29 rafaroda Assigned To rafaroda => mtaal
2010-02-16 15:30 rafaroda Project Modules => Openbravo ERP
2010-02-16 15:30 rafaroda OBNetwork customer => No
2010-02-16 15:30 rafaroda Assigned To mtaal => adrianromero
2010-02-16 15:30 rafaroda Status feedback => new
2010-02-16 15:30 rafaroda Category Multi-Business Partner Selector => 02. Master data management
2010-02-16 15:31 rafaroda Note Added: 0024416
2010-08-21 14:36 Jan De Bruyne - Abboss Issue Monitored: Jan De Bruyne - Abboss
2010-08-21 14:40 Jan De Bruyne - Abboss Note Added: 0030208
2010-08-23 09:40 shuehner Note Added: 0030214
2010-08-29 15:53 Jan De Bruyne - Abboss Note Added: 0030428
2010-10-05 13:49 shuehner Relationship added related to 0014766
2010-10-06 08:14 harikrishnan Assigned To adrianromero => harikrishnan
2010-10-11 08:27 hgbot Checkin
2010-10-11 08:27 hgbot Note Added: 0031727
2010-10-11 08:27 hgbot Status new => resolved
2010-10-11 08:27 hgbot Resolution open => fixed
2010-10-11 08:27 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ecd5a5db58bd257cad9e08034a5e10fb0459eb44 [^]
2010-10-11 08:31 harikrishnan Note Added: 0031729
2010-10-11 15:18 hudsonbot Checkin
2010-10-11 15:18 hudsonbot Note Added: 0031764
2010-10-13 17:18 psarobe Note Added: 0031819
2010-10-13 17:18 psarobe Status resolved => closed
2010-10-13 17:18 psarobe Fixed in Version => 2.50MP23
2010-10-14 00:00 anonymous sf_bug_id 0 => 3086961

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker