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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0014229
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setupminoralways2010-08-18 11:202010-09-22 00:00
ReporternetworkbView Statuspublic 
Assigned Toadrianromero 
PrioritynormalResolutionfixedFixed in Version2.50MP22
StatusclosedFix in branchFixed in SCM revision97a50a6985e3
ProjectionnoneETAnoneTarget Version2.50MP22
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0014229: Delete Parent Organizations

DescriptionWhen having the following organization structure:

Entity *, two organization of "organization type" and summary level, and inside of them two being "legal entity".

Being all of them validated, try to delete one parent organization, the application behaves differently depending on the database:

a) If it is oracle, it does not allow you to delete the parent organization and gives you the following error message:

ORA-04091: table TAD_MAIN_FULL.AD_TREENODE is mutating, trigger/function may not see it ORA-06512: at "TAD_MAIN_FULL.AD_ORG_TRG", line 111 ORA-04088: error during execution of trigger 'TAD_MAIN_FULL.AD_ORG_TRG'

b) If it is postgres, it allows you to delete the parent organization, and the child ones are not visible in the organization tree anymore.
Steps To ReproduceCreate an organization structure that contains at least one parent organization and inside one child that is legal entity. Validate all organizations. Then choose the parent organization and try to delete it: (From Big Bazaar data, this would be deleting organization "A")

a) Being in an Oracle database, see that is not possible

b) Being in Postgres, see that the organization is deleted, and the child ones are not visible in the tree anymore
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0014545 closedharikrishnan int-api 413 fails with a warning 

-  Notes
(0031022)
hgbot (developer)
2010-09-14 10:02

 Repository: erp/devel/pi
Changeset: 97a50a6985e36bed6f3dbe197111877b2a5206e2
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Tue Sep 14 13:32:07 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/97a50a6985e36bed6f3dbe197111877b2a5206e2 [^]

Fixes Issue 14229: Delete Parent Organizations

---
M src-db/database/model/tables/AD_TREENODE.xml
M src-db/database/model/triggers/AD_ORG_TRG.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
---
(0031024)
harikrishnan (reporter)
2010-09-14 10:19

 Steps to Test:

*If the Organization has child organization and if we try to delete the parent organization then error will be thrown other wise this organization can be deleted.
*In the case of Small Bazaar Client Org A cannot be deleted since it has child Org A1 and A2.
*So to delete A first to delete the child Org and then the parent.

Root Cause:

*Before a condition is not checked but this condition is checked added now.

Impact:

*Because of my commit it ll break the API.We need to fix their also.
(0031115)
hudsonbot (developer)
2010-09-15 20:55

 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/97a50a6985e3 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/80bfed94a6e8 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18410.obx [^]
(0031265)
psarobe (manager)
2010-09-21 11:59

 Tested working fine but since the ondelete cascade rule has been remove, which is correct, then is impossible to test the added message

- Issue History
Date Modified Username Field Change
2010-08-18 11:20 networkb New Issue
2010-08-18 11:20 networkb Assigned To => adrianromero
2010-08-26 09:07 jonalegriaesarte Target Version => 2.50MP23
2010-08-26 13:05 adrianromero Status new => scheduled
2010-08-26 13:05 adrianromero fix_in_branch => pi
2010-09-03 16:53 networkb Issue Monitored: emartinez
2010-09-06 10:46 jonalegriaesarte Target Version 2.50MP23 => 2.50MP22
2010-09-06 10:46 jonalegriaesarte fix_in_branch pi =>
2010-09-14 10:02 hgbot Checkin
2010-09-14 10:02 hgbot Note Added: 0031022
2010-09-14 10:02 hgbot Status scheduled => resolved
2010-09-14 10:02 hgbot Resolution open => fixed
2010-09-14 10:02 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/97a50a6985e36bed6f3dbe197111877b2a5206e2 [^]
2010-09-14 10:19 harikrishnan Note Added: 0031024
2010-09-14 15:33 shuehner Relationship added related to 0014545
2010-09-15 20:55 hudsonbot Checkin
2010-09-15 20:55 hudsonbot Note Added: 0031115
2010-09-21 11:59 psarobe Note Added: 0031265
2010-09-21 11:59 psarobe Status resolved => closed
2010-09-21 11:59 psarobe Fixed in Version => 2.50MP22
2010-09-22 00:00 anonymous sf_bug_id 0 => 3072968

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker