Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0006890 | Openbravo ERP | 01. General setup | public | 2009-01-14 17:43 | 2009-03-02 07:30 |
|
| Reporter | plujan | |
| Assigned To | vmromanos | |
| Priority | normal | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 30 | OS Version | |
| Product Version | 2.50alpha-r6 | |
| Target Version | | Fixed in Version | 2.50beta | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| 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 |
| Proposed Solution | |
| Additional Information | |
| Tags | QA_review_pre_beta |
| Relationships | | related to | defect | 0005848 | 2.50 | closed | shuehner | Can not delete an organization |
|
| Attached Files |  BUG_250-a-r6-LinkedItemsOrganization.PNG (99,154) 2009-01-14 17:43
https://issues.openbravo.com/file_download.php?file_id=640&type=bug
|
|
| 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 |
|
Notes |
|
|
|
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
|
|
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 [^]
|
|
|
|
|
|
Retested in Context 79.125.56.185/openbravotrunk, still not able to delete the newly created organization after deleting all the link items manually. |
|
|
|
|
|
This bug only happens using PostgreSQL. In Oracle it is working fine. |
|
|
|
(0013813)
|
|
svnbot
|
|
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 [^]
|
|
|
|
|
|
Retested in context 79.125.56.185/openbravotrunk |
|