Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0005848 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 01. General setup | major | always | 2008-11-06 12:12 | 2008-12-15 14:49 | |||
| Reporter | rafaroda | View Status | public | |||||
| Assigned To | shuehner | |||||||
| Priority | high | Resolution | unable to reproduce | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | ||||
| Projection | none | ETA | none | Target Version | 2.50 | |||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.5 | |||
| OS Version | Ubuntu 7.10 | Database version | 8.3 | Ant version | 1.7 | |||
| Product Version | pi | SCM revision | 9731 | |||||
| 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 | 0005848: Can not delete an organization | |||||||
| Description | Using PostgreSQL, I create a new organization but then I'm unable to delete it. | |||||||
| Steps To Reproduce | 1) Go to 'General Setup || Enterprise || Organization' 2) Create a new record. 3) Try to delete this new created record. 4) You can not with message: This record cannot be deleted because it is associated with other existing elements. Please see Linked Items 5) Try to see Linked Items: @CODE=0@ERROR: operator does not exist: character varying = integer | |||||||
| Tags | multi-org | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0010254) vmromanos (manager) 2008-11-13 17:19 |
I think this bug is not related with the multiorg project. Currently (version 2.40), the application does not allow the user to delete an organization because of a foreign key constraint ("ad_org_ad_orginfo") on the "AD_OrgInfo" table. On the other hand, the "@CODE=0@ERROR: operator does not exist: character varying = integer" error is related to a SQL sentence which is executed by the org.openbravo.erpCommon.utility.UsedByLinkData class: 12:58:20 [ajp-8009-15] ERROR org.openbravo.erpCommon.utility.UsedByLinkData - SQL error in query: SELECT COUNT(*) AS ID FROM M_RequisitionLine WHERE AD_Org_ID = ? AND EXISTS (SELECT 1 FROM M_Requisition WHERE M_Requisition.M_Requisition_ID = M_RequisitionLine.M_Requisition_ID AND M_Requisition.Ad_User_ID = 100) AND AD_ORG_ID NOT IN ('0','1000000','1000002','1000003','1000004','1000005','1000006','1000008','1000009','1000007','68FE30EBEE36477D9E8D632B22FCB4E3')Exception:org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer 12:58:20 [ajp-8009-15] ERROR org.openbravo.erpCommon.utility.UsedByLink - Error captured: javax.servlet.ServletException: @CODE=0@ERROR: operator does not exist: character varying = integer So, from my point of view, we should remove the multiorg tag and reassign this bug to the responsible of the 'Linked Items' issue. |
|
(0011368) shuehner (administrator) 2008-12-15 14:45 |
The Linked Items problems it not reproducible anymore in current trunk (r11204) |
|
(0011369) shuehner (administrator) 2008-12-15 14:49 |
The Linked Items issue is not reproducible anymore. The other topic is not a bug as it is the same behavior as present in 2.40 . |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-11-06 12:12 | rafaroda | New Issue | |
| 2008-11-06 12:12 | rafaroda | Assigned To | => vmromanos |
| 2008-11-06 12:12 | rafaroda | sf_bug_id | 0 => 2229176 |
| 2008-11-06 12:12 | rafaroda | Regression testing | => No |
| 2008-11-06 12:12 | rafaroda | Tag Attached: multi-org | |
| 2008-11-09 20:29 | psarobe | Status | new => scheduled |
| 2008-11-09 20:29 | psarobe | fix_in_branch | => trunk |
| 2008-11-13 17:19 | vmromanos | Note Added: 0010254 | |
| 2008-11-13 17:20 | vmromanos | Assigned To | vmromanos => rafaroda |
| 2008-11-13 17:20 | vmromanos | Status | scheduled => feedback |
| 2008-11-20 10:40 | rafaroda | Status | feedback => scheduled |
| 2008-11-20 10:40 | rafaroda | Assigned To | rafaroda => alostale |
| 2008-12-10 09:48 | alostale | Assigned To | alostale => shuehner |
| 2008-12-15 14:45 | shuehner | Note Added: 0011368 | |
| 2008-12-15 14:49 | shuehner | Status | scheduled => closed |
| 2008-12-15 14:49 | shuehner | Note Added: 0011369 | |
| 2008-12-15 14:49 | shuehner | Resolution | open => unable to reproduce |
| 2009-01-21 11:00 | vmromanos | Relationship added | related to 0006890 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |