Openbravo Issue Tracking System - Openbravo ERP
|View Issue Details|
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0014229||Openbravo ERP||01. General setup||public||2010-08-18 11:20||2010-09-22 00:00|
|Assigned To||adrianromero|| |
|Product Version|| |
|Target Version||2.50MP22||Fixed in Version||2.50MP22|| |
|Review Assigned To|
|Regression introduced in release|
|Regression introduced by commit|
|Triggers an Emergency Pack||No|
|Summary||0014229: Delete Parent Organizations|
|Description||When 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 Reproduce||Create 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
|Tags||No tags attached.|
|related to ||defect ||0014545|| ||closed ||harikrishnan ||int-api 413 fails with a warning |
|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||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||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|
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
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.
*Before a condition is not checked but this condition is checked added now.
*Because of my commit it ll break the API.We need to fix their also.
Tested working fine but since the ondelete cascade rule has been remove, which is correct, then is impossible to test the added message