Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0000410Openbravo ERPB. User interfacepublic2008-05-22 17:422008-08-14 16:15
Reporterrafaroda 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 7.10
Product Versionpi 
Target VersionFixed in Version2.40beta 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0000410: Son tab relation view error
DescriptionWhen 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 Reproduce1) 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 00004092.40 closed alostale Son tab relation view error 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-05-22 17:42alostaleNew Issue
2008-05-22 17:42alostaleAssigned To => alostale
2008-05-22 17:42alostaleStatusnew => scheduled
2008-05-22 17:55alostaleStatusscheduled => resolved
2008-05-22 17:55alostaleFixed in Version => R2.40alpha r2
2008-05-22 17:55alostaleResolutionopen => fixed
2008-05-22 17:55alostaleNote Added: 0000313
2008-07-04 17:23plujanStatusresolved => closed
2008-07-04 17:23plujanFixed in Version2.40alpha-r2 => 2.40beta
2008-08-14 16:15jaimetorresf_bug_id0 => 2051544

Notes
(0000313)
alostale   
2008-05-22 17:55   
r4473.