Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0022962Openbravo ERP00. Application dictionarypublic2013-02-04 10:122013-02-05 22:44
Reportermirurita 
Assigned Tomirurita 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Topramakrishnan
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0022962: Not possible to create a field based on Fact_Acct.Seqno column. Default value contains an invalid sql (since 2009)
DescriptionFact_Acct.Seqno column contains an invalid sql query.

@SQL=SELECT COALESCE(MAX(SEQNO),0)+10 AS DefaultValue FROM FACT_ACCT WHERE xxParentColumn=@xxParentColumn@
Steps To Reproduce1) 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.
Proposed SolutionRemove invalid default value.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-02-04 10:12miruritaNew Issue
2013-02-04 10:12miruritaAssigned To => mirurita
2013-02-04 10:12miruritaModules => Core
2013-02-04 10:12miruritaOBNetwork customer => No
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