Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026193Openbravo ERP09. Financial managementpublic2014-04-07 14:292014-06-02 17:27
Reportershuehner 
Assigned ToSandrahuguet 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Torafaroda
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0026193: Error in CI int-basic-oracle: Error while computing auxiliary input parameter: showAddPayment from tab: Header
DescriptionWhen running the int-basic-oracle test in ci the following error is printed into the application logfile.

2014-04-06 17:06:18,491 [TP-Processor6] ERROR org.openbravo.client.application.window.FormInitializationComponent - Error while computing auxiliary input parameter: showAddPayment from tab: Header
java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
    at org.openbravo.client.application.window.FormInitializationComponent.computeAuxiliaryInput(FormInitializationComponent.java:1812)
    at org.openbravo.client.application.window.FormInitializationComponent.computeAuxiliaryInputs(FormInitializationComponent.java:893)
    at org.openbravo.client.application.window.FormInitializationComponent.execute(FormInitializationComponent.java:251)


as can be seen in this build-log:
https://ci.openbravo.com/job/int-basic-oracle/204/artifact/SANDBOX/tomcat-logs/int-basic-oracle.log [^]

Note: from aux input name this seems to be in either Sales Invoice or Purchase Invoice window.

Note: This error seems to only happen on oracle.

Steps To Reproducerun int-basic-oracle test in pi
check openbravo.log for error output.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0026195 closed guillermogil FIC Error message about failing aux-input computation is missing window name. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-04-07 14:29shuehnerNew Issue
2014-04-07 14:29shuehnerAssigned To => dmiguelez
2014-04-07 14:29shuehnerModules => Core
2014-04-07 14:29shuehnerOBNetwork customer => No
2014-04-07 14:29shuehnerTriggers an Emergency Pack => No
2014-04-07 14:30shuehnerNote Added: 0066207
2014-04-07 14:37shuehnerRelationship addedrelated to 0026195
2014-05-12 17:45SandrahuguetAssigned Todmiguelez => Sandrahuguet
2014-05-14 08:45hgbotCheckin
2014-05-14 08:45hgbotNote Added: 0067117
2014-05-14 08:45hgbotStatusnew => resolved
2014-05-14 08:45hgbotResolutionopen => fixed
2014-05-14 08:45hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e7aee54e4fb2433503276cbaea371d0ef49ed2b3 [^]
2014-05-14 10:58SandrahuguetReview Assigned To => gorkaion
2014-05-15 17:34hudsonbotCheckin
2014-05-15 17:34hudsonbotNote Added: 0067165
2014-05-29 10:19dmitry_mezentsevNote Added: 0067559
2014-06-02 16:24dmitry_mezentsevNote Added: 0067680
2014-06-02 17:27rafarodaReview Assigned Togorkaion => rafaroda
2014-06-02 17:27rafarodaNote Added: 0067682
2014-06-02 17:27rafarodaStatusresolved => closed

Notes
(0066207)
shuehner   
2014-04-07 14:30   
Note: Those aux-input seem to have been added only recently. So maybe that could mean this is a regression, depending on user-visible outcome of this error (or just fix not working on oracle).

changeset: 22330:ee9a0da05d43
user: Sandra Huguet <sandra.huguet@openbravo.com>
date: Mon Mar 03 12:13:55 2014 +0100
files: modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml src-db/database/sourcedata/AD_AUXILIARINPUT.xml
description:
Fixed bug 25877: Error when adding payments
(0067117)
hgbot   
2014-05-14 08:45   
Repository: erp/devel/pi
Changeset: e7aee54e4fb2433503276cbaea371d0ef49ed2b3
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Mon May 12 17:45:19 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/e7aee54e4fb2433503276cbaea371d0ef49ed2b3 [^]

Fixed issue 26193 Error while computing auxiliary input showAddPayment

---
M src-db/database/sourcedata/AD_AUXILIARINPUT.xml
---
(0067165)
hudsonbot   
2014-05-15 17:34   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/8d6658b982c0 [^]
Maturity status: Test
(0067559)
dmitry_mezentsev   
2014-05-29 10:19   
Not closed for 15 days!!
(0067680)
dmitry_mezentsev   
2014-06-02 16:24   
Not closed for 19 days!!
Please make an action immediately.
Everything else has to wait.
(0067682)
rafaroda   
2014-06-02 17:27   
In an Oracle environment:
* Switched to changeset 23020 https://code.openbravo.com/erp/devel/pi/rev/e7aee54e4fb2 [^]
* ant smartbuild -Dlocal=no: successfully built
* Went to both Sales Invoice and Purchase Invoice windows
* Created invoices
* Added payments to invoices until fully pay them
* Button Add Payment displayed, worked and hided as expected