Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0000409 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] B. User interface | critical | always | 2008-05-22 16:36 | 2008-07-01 17:56 | |||
| Reporter | rafaroda | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 2.40alpha-r3 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | 2.40 | |||
| OS | Linux 32 bit | Database | Oracle | Java version | 1.5 | |||
| OS Version | Ubuntu 7.10 | Database version | 10 g SE | Ant version | 1.7 | |||
| Product Version | pi | SCM revision | 4468 | |||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0000409: Son tab relation view error | |||||||
| Description | When navigating a son tab from his parent, select Edit mode then Relation mode: a 'The number is not correct.You may check the data' error message will display. 16:25:26 [ajp-8009-5] ERROR org.openbravo.erpCommon.utility.ExecuteQuery - SQL error in query: SELECT COUNT(*) AS TOTAL FROM C_OrderLine left join (SELECT M_Product_ID, Name FROM M_Product) td0 on C_OrderLine.M_Product_ID = td0.M_Product_ID left join (SELECT C_UOM_ID, Name FROM C_UOM) td1 on C_OrderLine.C_UOM_ID = td1.C_UOM_ID left join (SELECT AD_Language, C_UOM_ID, Name FROM C_UOM_Trl) td_trl2 on td1.C_UOM_ID = td_trl2.C_UOM_ID AND td_trl2.AD_Language = ? left join (SELECT C_Tax_ID, Name, C_TaxCategory_ID FROM C_Tax) td3 on C_OrderLine.C_Tax_ID = td3.C_Tax_ID left join (SELECT AD_Language, C_Tax_ID, Name FROM C_Tax_Trl) td_trl4 on td3.C_Tax_ID = td_trl4.C_Tax_ID AND td_trl4.AD_Language = ? left join (SELECT C_TaxCategory_ID, Name FROM C_TaxCategory) td5 on td3.C_TaxCategory_ID = td5.C_TaxCategory_ID left join (SELECT AD_Language, C_TaxCategory_ID, Name FROM C_TaxCategory_Trl) td_trl6 on td5.C_TaxCategory_ID = td_trl6.C_TaxCategory_ID AND td_trl6.AD_Language = ? WHERE C_OrderLine.AD_Client_ID IN (0,1000000) AND C_OrderLine.AD_Org_ID IN (1000000,1000002,1000003,1000004,1000005,1000006,1000008,1000009,1000007) AND C_OrderLine.C_Order_ID = ? Exception:java.sql.SQLException: ORA-01722: invalid number | |||||||
| Steps To Reproduce | 1) Go to a Sale Order. 2) Go to Lines tab in Edit mode. 3) Select Relation mode. 4) 'The number is not correct.You may check the data' error message will display. This happens following the steps Header > Lines (edition) > Lines (Relation) in all generated windows. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0000309) alostale (viewer) 2008-05-22 17:11 |
it's working in r4404 but not in r4438 |
|
(0000310) alostale (viewer) 2008-05-22 17:42 |
r4471. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-05-22 16:36 | rafaroda | New Issue | |
| 2008-05-22 16:36 | rafaroda | Assigned To | => alostale |
| 2008-05-22 16:36 | rafaroda | OBNetwork customer | => N |
| 2008-05-22 17:11 | alostale | Note Added: 0000309 | |
| 2008-05-22 17:42 | alostale | Status | new => scheduled |
| 2008-05-22 17:42 | alostale | Status | scheduled => resolved |
| 2008-05-22 17:42 | alostale | Fixed in Version | => trunk |
| 2008-05-22 17:42 | alostale | Resolution | open => fixed |
| 2008-05-22 17:42 | alostale | Note Added: 0000310 | |
| 2008-05-22 18:03 | admin | OBNetwork customer | N => |
| 2008-05-22 18:03 | admin | Severity | minor => critical |
| 2008-06-11 14:47 | cromero | Target Version | => 2.40 |
| 2008-06-11 14:50 | cromero | Fixed in Version | trunk => 2.40alpha r3 |
| 2008-06-19 11:52 | plujan | Status | resolved => closed |
| 2008-07-01 17:56 | anonymous | sf_bug_id | 0 => 2007886 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |