0000409: Son tab relation view error - Openbravo Issue Tracking System

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0000409

Openbravo ERP

B. User interface

public

2008-05-22 16:36

2008-07-01 17:56

Reporter

rafaroda

Assigned To

alostale

Priority

normal

Severity

critical

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Ubuntu 7.10

Product Version

Target Version

2.40

Fixed in Version

2.40alpha-r3

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

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.

Proposed Solution

Additional Information