Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018414Openbravo ERPA. Platformpublic2011-09-02 08:152011-10-12 01:59
Reporterjecharri 
Assigned Tomarvintm 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP4Fixed in Version3.0MP4 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browserGoogle Chrome
ModulesCore
Support ticket12483
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0018414: Problems with WAD and default values in parameters for Bundle Process
DescriptionExist a problem with WAD, when you put one default value to one parameter in a Bundle Process.

The default value must be a SQL sentence.
Steps To ReproduceAs System, go to Reports and Process.
Go to process "FIN_DeleteTransaction"
Now, after you have selected the process, go to tab Parameter.
In this tab, create a new parameter (it doesn't mind what you put in all fields apart from the default value) and put one SQL sentence like a default value. For example @SQL=select hola from c_invoice.
Now compile the Financial account window: ant compile -Dtab=Financial
It must be appear the next error:

compileSqlc:
    [javac] Compiling 302 source files to /home/openbravo/src/30POSTGRES/pi/build/classes
    [javac] Note: Some input files use or override a deprecated API.
    [javac] Note: Recompile with -Xlint:deprecation for details.
    [javac] Compiling 25 source files to /home/openbravo/src/30POSTGRES/pi/build/classes
    [javac] /home/openbravo/src/30POSTGRES/pi/srcAD/org/openbravo/erpCommon/ad_actionButton/ActionButtonJava_Responser.java:633: cannot find symbol
    [javac] symbol : variable ActionButtonSQLDefaultData
    [javac] location: class org.openbravo.erpCommon.ad_actionButton.ActionButtonJava_Responser
    [javac] xmlDocument.setParameter("c_invoice_id", ActionButtonSQLDefaultData.selectActPFF8080812F348A97012F349DC24F0007_c_invoice_id(this));
    [javac] ^
    [javac] /home/openbravo/src/30POSTGRES/pi/srcAD/org/openbravo/erpWindows/FinancialAccount/TransactionFF8080812F213146012F2135BC25000E.java:1084: cannot find symbol
    [javac] symbol : method selectActPFF8080812F348A97012F349DC24F0007_c_invoice_id(org.openbravo.erpWindows.FinancialAccount.TransactionFF8080812F213146012F2135BC25000E)
    [javac] location: class org.openbravo.erpWindows.FinancialAccount.TransactionFF8080812F213146012F2135BC25000EData
    [javac] xmlDocument.setParameter("c_invoice_id", TransactionFF8080812F213146012F2135BC25000EData.selectActPFF8080812F348A97012F349DC24F0007_c_invoice_id(this));
    [javac] ^
    [javac] 2 errors

The problem is that ActionButtonSQLDefaultData java class doesn't exist.
Like a note, I have to say that in the xsql OF THE WINDOW IN WHICH THE PROCESS IS CALLED have been created the query selectActPFF8080812F348A97012F349DC24F0007_c_invoice_id.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00184152.50MP35 closed marvintm Problems with WAD and default values in parameters for Bundle Process 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-09-02 08:15jecharriNew Issue
2011-09-02 08:15jecharriAssigned To => alostale
2011-09-02 08:15jecharriWeb browser => Google Chrome
2011-09-02 08:15jecharriModules => Core
2011-09-02 08:15jecharriOBNetwork customer => Yes
2011-09-02 08:15jecharriSupport ticket => 12483
2011-09-02 08:15jecharriResolution time => 1318456800
2011-09-02 08:16jecharriStatusnew => scheduled
2011-09-02 08:16jecharrifix_in_branch => pi
2011-09-02 09:15jecharriWeb browserGoogle Chrome => Google Chrome
2011-09-02 09:15jecharrifix_in_branchpi =>
2011-09-02 09:15jecharriSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=2658#r2658
2011-09-28 17:53iperdomoAssigned Toalostale => marvintm
2011-09-29 11:07hgbotCheckin
2011-09-29 11:07hgbotNote Added: 0041366
2011-09-29 11:07hgbotStatusscheduled => resolved
2011-09-29 11:07hgbotResolutionopen => fixed
2011-09-29 11:07hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/556f30b43dbbb2720621c102e0d89e780020541d [^]
2011-10-05 08:49alostaleStatusresolved => closed
2011-10-05 08:49alostaleFixed in Version => 3.0MP4
2011-10-12 01:59hudsonbotCheckin
2011-10-12 01:59hudsonbotNote Added: 0041728

Notes
(0041366)
hgbot   
2011-09-29 11:07   
Repository: erp/devel/pi
Changeset: 556f30b43dbbb2720621c102e0d89e780020541d
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Thu Sep 29 11:06:23 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/556f30b43dbbb2720621c102e0d89e780020541d [^]

Fixed issue 18414. Now the sqlc method will be generated even if the process doesn't have a menu entry.

---
M src-wad/src/org/openbravo/wad/ProcessRelation_data.xsql
---
(0041728)
hudsonbot   
2011-10-12 01:59   
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/9bd2b5c2d982 [^]

Maturity status: Test