Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0006890 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 01. General setup | major | have not tried | 2009-01-14 17:43 | 2009-03-02 07:30 | |||
| Reporter | plujan | View Status | public | |||||
| Assigned To | vmromanos | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 2.50beta | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 13447 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.50alpha-r6 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0006890: Recently created organization can not be deleted | |||||||
| Description | I create an organization. Doing nothing else, I try to delete it. I can not because of linked items. I move to linked items and delete all of them, but I still can not delete the organization. | |||||||
| Steps To Reproduce | 1. Go General Setup > Enterprise > Organization 2. Create a new Organization by filling all mandatory fields 3. Delete the org. It can not be deleted because of linked items. 4. Open linked items window and navigate to all of the related records, deleting them all. 5. With no linked items remaining, try to delete the org again. It is still not possible because of linked items. See attach | |||||||
| Tags | QA_review_pre_beta | |||||||
| Attached Files |  BUG_250-a-r6-LinkedItemsOrganization.PNG [^] (99,154 bytes) 2009-01-14 17:43
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0012412) eduardo_Argal (developer) 2009-01-20 18:56 |
I think it is because of ad_treenode records. ad_org_trg is trying to delete ad_treenode record but as that trg fires after the delete sentence fails first. we should build a delete on cascade constraint for ad_org and ad_treenode |
|
(0012519) svnbot (reporter) 2009-01-22 12:23 |
Repository: openbravo Revision: 12147 Author: vmromanos Date: 2009-01-22 12:23:00 +0100 (Thu, 22 Jan 2009) Fixed bug 6890: Recently created organization can not be deleted. It is now not necessary to manually delete the organization info and the role org access before deleting the organization. The organization can only be deleted if it has no records associated (like for example an invoice). --- U trunk/src-db/database/model/tables/AD_ORGINFO.xml U trunk/src-db/database/model/tables/AD_ROLE_ORGACCESS.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=12147&sc=1 [^] |
|
(0013727) sureshbabu (reporter) 2009-02-19 12:43 |
Retested in Context 79.125.56.185/openbravotrunk, still not able to delete the newly created organization after deleting all the link items manually. |
|
(0013738) vmromanos (manager) 2009-02-19 13:34 |
This bug only happens using PostgreSQL. In Oracle it is working fine. |
|
(0013813) svnbot (reporter) 2009-02-20 11:21 |
Repository: openbravo Revision: 13447 Author: vmromanos Date: 2009-02-20 11:21:28 +0100 (Fri, 20 Feb 2009) Fixed bug 6890: Recently created organization can not be deleted. Now it also works on PostgreSQL --- U trunk/src-db/database/model/tables/AD_TREENODE.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=13447&sc=1 [^] |
|
(0014189) sureshbabu (reporter) 2009-03-02 07:30 |
Retested in context 79.125.56.185/openbravotrunk |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-01-14 17:43 | plujan | New Issue | |
| 2009-01-14 17:43 | plujan | Assigned To | => rafaroda |
| 2009-01-14 17:43 | plujan | sf_bug_id | 0 => 2507361 |
| 2009-01-14 17:43 | plujan | File Added: BUG_250-a-r6-LinkedItemsOrganization.PNG | |
| 2009-01-14 17:43 | plujan | Regression testing | => No |
| 2009-01-14 17:44 | plujan | Tag Attached: QA_review_pre_beta | |
| 2009-01-19 11:00 | psarobe | Status | new => scheduled |
| 2009-01-19 11:00 | psarobe | Assigned To | rafaroda => vmromanos |
| 2009-01-19 11:00 | psarobe | fix_in_branch | => trunk |
| 2009-01-20 18:56 | eduardo_Argal | Note Added: 0012412 | |
| 2009-01-21 11:00 | vmromanos | Relationship added | related to 0005848 |
| 2009-01-22 12:23 | svnbot | Checkin | |
| 2009-01-22 12:23 | svnbot | Note Added: 0012519 | |
| 2009-01-22 12:23 | svnbot | Status | scheduled => resolved |
| 2009-01-22 12:23 | svnbot | Resolution | open => fixed |
| 2009-01-22 12:23 | svnbot | svn_revision | => 12147 |
| 2009-02-19 12:43 | sureshbabu | Status | resolved => new |
| 2009-02-19 12:43 | sureshbabu | Resolution | fixed => open |
| 2009-02-19 12:43 | sureshbabu | Note Added: 0013727 | |
| 2009-02-19 13:34 | vmromanos | Note Added: 0013738 | |
| 2009-02-20 11:21 | svnbot | Checkin | |
| 2009-02-20 11:21 | svnbot | Note Added: 0013813 | |
| 2009-02-20 11:21 | svnbot | Status | new => resolved |
| 2009-02-20 11:21 | svnbot | Resolution | open => fixed |
| 2009-02-20 11:21 | svnbot | svn_revision | 12147 => 13447 |
| 2009-03-02 07:30 | sureshbabu | Status | resolved => closed |
| 2009-03-02 07:30 | sureshbabu | Note Added: 0014189 | |
| 2009-03-02 07:30 | sureshbabu | Fixed in Version | => trunk |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |