Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0022962Openbravo ERP00. Application dictionarypublic2013-02-04 10:122013-02-05 22:44
mirurita 
mirurita 
highminoralways
closedfixed 
20Community Appliance
 
 
pramakrishnan
Core
No
0022962: Not possible to create a field based on Fact_Acct.Seqno column. Default value contains an invalid sql (since 2009)
Fact_Acct.Seqno column contains an invalid sql query.

@SQL=SELECT COALESCE(MAX(SEQNO),0)+10 AS DefaultValue FROM FACT_ACCT WHERE xxParentColumn=@xxParentColumn@
1) Do not apply the patch
2) ant compile.complete -Dwad.generateAllClassic250Windows=true
3) It will fail because of the invalid sql
4) Apply the patch
5) ant update.database compile.complete -Dwad.generateAllClassic250Windows=true
6) Go to Application Dictionary and display the Line No field for Sales Invoice >> Accounting tab.
7) Go to Sales Invoice >> Accounting tab and realize the line no field is displayed.
Remove invalid default value.
No tags attached.
Issue History
2013-02-04 10:12miruritaNew Issue
2013-02-04 10:12miruritaAssigned To => mirurita
2013-02-04 10:12miruritaModules => Core
2013-02-04 10:12miruritaTriggers an Emergency Pack => No
2013-02-04 10:13hgbotCheckin
2013-02-04 10:13hgbotNote Added: 0056119
2013-02-04 10:13hgbotStatusnew => resolved
2013-02-04 10:13hgbotResolutionopen => fixed
2013-02-04 10:13hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/29ce12396f337649c248965bea3f3f75d9be9b67 [^]
2013-02-05 11:33pramakrishnanReview Assigned To => pramakrishnan
2013-02-05 11:33pramakrishnanNote Added: 0056153
2013-02-05 11:33pramakrishnanStatusresolved => closed
2013-02-05 22:44hudsonbotCheckin
2013-02-05 22:44hudsonbotNote Added: 0056188

Notes
(0056119)
hgbot   
2013-02-04 10:13   
Repository: erp/devel/pi
Changeset: 29ce12396f337649c248965bea3f3f75d9be9b67
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Mon Feb 04 10:13:06 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/29ce12396f337649c248965bea3f3f75d9be9b67 [^]

Fixes issue 22962: Not possible to create a field based on Fact_Acct.Seqno column.
Default value contains an invalid sql (since 2009)

---
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0056153)
pramakrishnan   
2013-02-05 11:33   
Code Review + Testing - OK
(0056188)
hudsonbot   
2013-02-05 22:44   
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/86db3ad54671 [^]

Maturity status: Test