Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021073Openbravo ERPA. Platformpublic2012-07-13 14:312012-07-17 11:30
ReporterSandrahuguet 
Assigned ToAugustoMauch 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Versionpi 
Target Version3.0MP13Fixed in Version3.0MP13 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0021073: Impossible to do export.database with computed column
DescriptionImpossible to do export.database with computed column


Steps To ReproduceWith the new concept computed column
-Create a column with sqllogic
-Create a field asociate, this field must be read only
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-07-13 14:31SandrahuguetNew Issue
2012-07-13 14:31SandrahuguetAssigned To => alostale
2012-07-13 14:31SandrahuguetModules => Core
2012-07-13 14:32SandrahuguetDescription Updatedbug_revision_view_page.php?rev_id=3632#r3632
2012-07-13 14:32SandrahuguetNote Added: 0050569
2012-07-13 14:32SandrahuguetDescription Updatedbug_revision_view_page.php?rev_id=3633#r3633
2012-07-16 13:36AugustoMauchAssigned Toalostale => AugustoMauch
2012-07-16 13:42hgbotCheckin
2012-07-16 13:42hgbotNote Added: 0050604
2012-07-16 13:42hgbotStatusnew => resolved
2012-07-16 13:42hgbotResolutionopen => fixed
2012-07-16 13:42hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/eefb7b36438c4aa907c7542f44e0bf00cf684d63 [^]
2012-07-16 13:48AugustoMauchNote Added: 0050605
2012-07-16 18:31alostaleNote Added: 0050630
2012-07-16 18:31alostaleStatusresolved => closed
2012-07-16 18:31alostaleFixed in Version => 3.0MP13
2012-07-17 11:30hudsonbotCheckin
2012-07-17 11:30hudsonbotNote Added: 0050649

Notes
(0050569)
Sandrahuguet   
2012-07-13 14:32   
Error:

Errors for Validation type: NOT_EXIST_IN_DB
+++++++++++++++++++++++++++++++++++++++++++++++++++
Column FIN_Financial_Account.lastreconciliation defined in the Application Dictionary but not present in the database.
Module validation failed, see the above list of errors for more information

BUILD FAILED
/home/openbravo/workspace4o/pi/openbravo/build.xml:746: The following error occurred while executing this line:
/home/openbravo/workspace4o/pi/openbravo/src-db/database/build.xml:155: org.openbravo.base.exception.OBException: Module validation failed, see the above list of errors for more information
    at org.openbravo.ddlutils.task.ExportDatabase.validateDatabaseForModule(ExportDatabase.java:287)
    at org.openbravo.ddlutils.task.ExportDatabase.execute(ExportDatabase.java:161)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
    at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
    at org.apache.tools.ant.Task.perform(Task.java:348)
    at org.apache.tools.ant.Target.execute(Target.java:390)
    at org.apache.tools.ant.Target.performTasks(Target.java:411)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
    at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
    at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:442)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
    at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
    at org.apache.tools.ant.Task.perform(Task.java:348)
    at org.apache.tools.ant.Target.execute(Target.java:390)
    at org.apache.tools.ant.Target.performTasks(Target.java:411)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
    at org.apache.tools.ant.Project.executeTarget(Project.java:1368)
    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
    at org.apache.tools.ant.Main.runBuild(Main.java:809)
    at org.apache.tools.ant.Main.startAnt(Main.java:217)
    at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
    at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
(0050604)
hgbot   
2012-07-16 13:42   
Repository: erp/devel/pi
Changeset: eefb7b36438c4aa907c7542f44e0bf00cf684d63
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Mon Jul 16 13:41:04 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/eefb7b36438c4aa907c7542f44e0bf00cf684d63 [^]

Fixes issue 21073: Computed columns do not need a database column

If a column is a computed column (it has defined sql logic), it does not need to have a database column.

---
M src/org/openbravo/service/system/DatabaseValidator.java
---
(0050605)
AugustoMauch   
2012-07-16 13:48   
Test plan:
- Open the Tables and Columns window and add a column with Sql logic.
- Run export.database. It should not fail, because columns with sql logic defined do not need a physical column
- Delete the sql logic from the previously defined column.
- Run again export.database. Now it should fail, because the new column does not have sql logic and does not have a column defined in the database.

The fix is not risky.
(0050630)
alostale   
2012-07-16 18:31   
Code reviewed and verified on pi@eefb7b36438c
(0050649)
hudsonbot   
2012-07-17 11:30   
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/e0c03882496c [^]

Maturity status: Test